| Server IP : 79.136.114.73 / Your IP : 216.73.216.107 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/icad.astacus.se/productionzon/JavaPowUpload/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$ProjectId = $_GET['projectId'];
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and ProjectId = $ProjectId";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$CompanyId = $row['CompanyId'];
$ProjectName = $row['Name'];
$Description = $row['Description'];
$RequestedDeliveryDate = $row['RequestedDeliveryDate'];
$scheduledDeliveryToCustomer = $row['scheduledDeliveryToCustomer'];
$ProjectStatusId = $row['ProjectStatusId'];
$TimeEstimationFromIndia = $row['TimeEstimationFromIndia'];
}
if($TimeEstimationFromIndia == ""){
$TimeEstimationFromIndia = 0.0;
}
$RequestedDeliveryDate = substr($RequestedDeliveryDate,0,10);
$scheduledDeliveryToCustomer = substr($scheduledDeliveryToCustomer,0,10);
if($scheduledDeliveryToCustomer == ""){
$scheduledDeliveryToCustomer = $RequestedDeliveryDate;
}
if($scheduledDeliveryToCustomer == ""){
$scheduledDeliveryToCustomer = date("Y")."-01-01";
}
if($ProjectStatusId == 12){
$color = "#FF0000";
}else if($ProjectStatusId == 1) {
$color = "#ffc600";
}else if($ProjectStatusId == 8) {
$color = "#00FF00";
}else if($ProjectStatusId == 9) {
$color = "#0099FF";
}else if($ProjectStatusId == 14) {
$color = "#9966FF";
}else{
$color = "#ffffff";
}
?>
<link href="../main.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
-->
</style>
<script type="text/javascript" src="calendar.js"></script>
<table width="850" height="64" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/tabb1.jpg"><table width="850" height="23" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="8" height="23"> </td>
<td width="108" valign="bottom" class="blacklink"><div align="center"><a href="?page=project&projectId=<?php echo($ProjectId);?>" class="blacklink">Project status</a></div></td>
<td width="22" valign="bottom" class="blacklink"><div align="center"></div></td>
<td width="100" valign="bottom" class="blacklink"><div align="center"><a href="?page=upload&projectId=<?php echo($ProjectId);?>" class="blacklink">Upload files</a></div></td>
<td width="24" valign="bottom" class="blacklink"><div align="center"></div></td>
<td width="105" valign="bottom" class="blacklink"><div align="center"><a href="?page=download&projectId=<?php echo($ProjectId);?>" class="blacklink">Download files</a></div></td>
<td width="21" class="blacklink"> </td>
<td width="104" valign="bottom" class="blacklink"><div align="center"><a href="?page=logg&projectId=<?php echo($ProjectId);?>" class="blacklink">Project log</a></div></td>
<td width="358" class="blacklink"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="90"> </td>
<td width="820"><table width="820" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" valign="top"> <table width="821" border="0" cellpadding="0" cellspacing="0">
<tr >
<td colspan="4" valign="top" class="text"><span class="heading1">Project status</span>
<table width="426" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="36" ><table width="24" height="24" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" class="textthin">
<tr>
<td bgcolor="<?php echo($color);?>"> </td>
</tr>
</table> <span class="text"><br>
</span></td>
<td width="390"><div align="left"><span class="textthin"><span class="heading2">Project: <?php echo($CompanyId);?>_<?php echo($ProjectName);?> (<?php echo($ProjectId);?>)</span> <br>
</span> </div></td>
</tr>
</table></td><td width="357" valign="top" class="textthin"><div align="right"><span class="heading1"><a href="index.php"><img src="../images/Back-Arrow.jpg" width="37" height="36" border="0" align="absmiddle"></a> <a href="index.php" class="blacklinkhuge">Back to search </a></span></div></td>
</tr>
</table>
<hr width="820" size="1">
<span class="heading2"><br>
</span>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="455" valign="top"> <form name="form1" method="post" action="setdeliverydate.php?projectId=<?php echo($ProjectId);?>">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" class="style6">
<td width="225" valign="top">Set delivery date:<br>
<span class="textthin">(Requested delivery date: <?php echo($RequestedDeliveryDate); ?>)</span></td>
<td width="186">
<script>DateInput('orderdatedel', true, 'YYYY-MM-DD', '<?php echo($scheduledDeliveryToCustomer);?>')</script>
</td>
<td width="39"><input type="submit" name="Submit2" value="Set!"></td>
</tr>
</table>
</form>
<form name="form2" method="post" action="setestimate.php?projectId=<?php echo($ProjectId);?>">
<br>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" class="style6">
<td width="225" valign="top">Enter how many hours that is spent in this projekt so far: <br>
</td>
<td width="186">
<?php
/*
$sql = "SELECT count( ICADType.ICADTypeID ) AS Number,Type ,ICADType.ICADTypeId, CustomerId, WorkDays, Hours, NextFlushDate FROM ICADAccount, ICADFlush, ICADType WHERE CustomerId = $CompanyId AND ICADFlush.CompanyID = ICADAccount.CustomerId AND ICADType.ICADTypeId = ICADAccount.ICADTypeId GROUP BY ICADTypeID";
$result = mysql_query($sql);
$icad = 0;
$icad_plus = 0;
while ($row = mysql_fetch_assoc($result)){
if($row['Type'] == "1"){
$icad += $row['Hours']*$row['WorkDays']*$row['Number'];
}else{
$icad_plus += $row['Hours']*$row['WorkDays']*$row['Number'];
}
}
$sql = "select * from ICADTime where CompanyId = $CompanyId and ICADType = 1;";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$icad = $icad - $row['Hours'] ;
}
*/
$sql = "select * from ICADTime, ICADTimeHistory where ICADTime.ProjectId = $ProjectId;";
$result = mysql_query($sql);
$OldAdditionalHours = 0;
while ($row = mysql_fetch_assoc($result)){
$ICADType = $row['ICADType'];
$OldAdditionalHours += $row['AdditionalHours'];
}
if($OldAdditionalHours == ""){
$OldAdditionalHours = "0";
}
?>
<input name="hours" type="text" id="hours2" value="<?php echo($TimeEstimationFromIndia);?>" size="3">
<select name="typeid" id="typeid">
<option value="1" <?php if($ICADType == 1){echo("selected");}?>>iCAD </option>
<option value="2" <?php if($ICADType == 2){echo("selected");}?>>iCAD+ </option>
</select>
<input name="companyId" type="hidden" id="companyId" value="<?php echo($CompanyId);?>">
</td>
<td width="39"><input type="submit" name="Submit3" value="Set!"></td>
</tr>
</table>
<br />
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" class="style6">
<td width="225" valign="top">Enter how many additional hours that is spent in this projekt so far: <br /></td>
<td width="186">
<input name="additionalhours" type="text" id="hours" value="<?php echo($OldAdditionalHours);?>" size="3" />
</td>
<td width="39"> </td>
</tr>
</table>
</form>
<form name="form2" method="post" action="acceptgotomeeting.php?projectId=<?php echo($ProjectId);?>&action=gotomeeting">
<br>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" class="style6">
<td width="225" valign="top">Accept GoToMeeting:</td>
<td width="162">
</td>
<td width="63"><div align="right">
<input type="submit" name="Submit2" value="Accept!">
</div></td>
</tr>
</table>
</form>
<?php if($ProjectStatusId == 1){?>
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center" class="heading1"><br>
The project is stoped!<br>
<br>
</div>
</td>
</tr>
</table>
<?php }else if($ProjectStatusId == 9){?>
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><span class="heading1"><br>
The project is COMPLETED! </span><br>
<br>
<br>
</div></td>
</tr>
</table>
<?php }else if($ProjectStatusId == 12){?>
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=partdelivered"><img src="../images/delivered.jpg" width="150" height="149" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press DELIVERED to tell the client that the project is PART delivered. </span><br>
</div></td>
</tr>
</table>
<hr size="1">
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=delivered"><img src="../images/delivered.jpg" width="150" height="149" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press DELIVERED to tell the client that the project is FINAL delivered. </span><br>
</div></td>
</tr>
</table>
<hr size="1">
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=continue"><img src="../images/continue.jpg" width="150" height="149" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press CONTINE to tell the client that you have enough information to remove RFMI-status! </span><br>
</div></td>
</tr>
</table> <?php }else{?>
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=partdelivered"><img src="../images/delivered.jpg" width="150" height="149" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press DELIVERED to tell the client that the project is PART delivered. </span><br>
</div></td>
</tr>
</table>
<hr size="1">
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=delivered"><img src="../images/delivered.jpg" width="150" height="149" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press DELIVERED to tell the client that the project is FINAL delivered. </span><br>
</div></td>
</tr>
</table>
<hr size="1">
<table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="169"><a href="action.php?projectId=<?php echo($ProjectId);?>&action=rfmi"><img src="../images/stop.jpg" width="150" height="150" border="0"></a></td>
<td width="261" valign="middle"><div align="center"><span class="heading2">Press STOP to tell the client that more information is requiered. <br>
Also state the problems in the log!
</span><br>
</div></td>
</tr>
</table>
<?php }?> <br>
<span class="heading2"><br>
</span><span class="heading2"> </span>
<table width="341" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="14" bgcolor="#FF0000"> </td>
<td width="151"> RFMI</td>
<td width="14" bgcolor="#ffc600"> </td>
<td width="162"> Not in production </td>
</tr>
<tr class="text">
<td width="14"> </td>
<td width="151"> </td>
<td width="14"> </td>
<td> </td>
</tr>
<tr class="text">
<td width="14" bgcolor="#00FF00"> </td>
<td width="151"> Delivered</td>
<td width="14" bgcolor="#0099FF"> </td>
<td> Completed</td>
</tr>
</table>
<p><span class="heading2"><br>
</span><span class="heading2"> </span> </p></td>
<td width="17"> </td>
<td width="348" valign="top"><table width="342" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" background="../images/platta1.jpg"><table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2"><br>
Book GoToMeeting
</span>
<form name="meeting" action="addlogg.php?ProjectId=<?php echo($ProjectId);?>&type=meeting" method="post">
<table width="251" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="79">Day</td>
<td colspan="2"><div align="left">
<script>DateInput('orderdate', true, 'YYYY-MON-DD')</script>
<!--<input type="button" onClick="alert(this.form.orderdate.value)" value="Show date value passed">-->
</div></td>
</tr>
<tr class="text">
<td>Time:</td>
<td width="78"><select name="time" class="textthin">
<option value="07:30">07:30</option>
<option>08:00</option>
<option>08:30</option>
<option>09:00</option>
<option>09:30</option>
<option>10:00</option>
<option>10:30</option>
<option>11:00</option>
<option>11:30</option>
<option>12:00</option>
<option>12:30</option>
<option>13:00</option>
<option>13:30</option>
<option>14:00</option>
<option>14:30</option>
<option>15:00</option>
<option>15:30</option>
<option>16:00</option>
<option>16:30</option>
</select>
</td>
<td width="94"><div align="right">
<input type="submit" name="Submit" value="Book!">
</div></td>
</tr>
<tr class="text">
<td> </td>
<td colspan="2"> </td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br>
<table width="342" height="188" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" valign="top" background="../images/platta2.jpg"><br>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2">Your contacts: </span><br>
<table width="300" border="0" cellspacing="0" cellpadding="0">
<?php
$sql = "SELECT Name, SkypeId, Phone, Email, UserGroup.UserGroupId as UserGroupId
FROM ProjectSystemUserJoin, UserGroup, SystemUser
WHERE UserGroup.UserGroupId = ProjectSystemUserJoin.UserGroupId
AND SystemUser.SystemUserId = ProjectSystemUserJoin.SystemUserId
AND `ProjectId` = $ProjectId
AND (
UserGroup.UserGroupId =6
OR UserGroup.UserGroupId =5
OR UserGroup.UserGroupId =4
)";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$UserGroupdId = $row['UserGroupId'];
$Name = $row['Name'];
if($UserGroupdId == 6){
$Name = $Name .", Astacus Indien";
}else if($UserGroupdId == 5){
$Name = $Name .", Astacus Sverige";
}
$SkypeId = $row['SkypeId'];
$Phone = $row['Phone'];
$Email = $row['Email'];
if($SkypeId == ""){
$SkypeId = "AstacusDemoAccount";
}
?>
<tr class="textthin">
<td width="35"><a href="skype:<?php echo($SkypeId);?>?call"><img src="http://mystatus.skype.com/smallicon/<?php echo($SkypeId);?>" alt="Skype?" width="16" height="16" border="0" style="border: none;" /></a></td>
<td width="265"><div align="left"><?php echo($Name);?></div></td>
</tr>
<?php }?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<br>
<table width="342" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" valign="top" background="../images/platta1.jpg"><br>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><span class="heading2">Customer documents <br>
</span>
<table width="295" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="213" valign="top" class="textthin">On this page you can upload and download customer specific documents that are generic for all the customers projects! <a href="?page=shared"><br>
</a></td>
<td width="30"> </td>
<td width="52"><span class="heading2"><a href="?page=shared&customerId=<?php echo($CompanyId);?>"><img src="../images/Forward-Arrow.png" width="45" height="45" border="0"></a></span></td>
</tr>
</table>
<span class="heading2"> </span></td>
</tr>
</table></td>
</tr>
</table> <p class="heading2"> </p></td></tr>
</table>
<span class="style6"><br>
</span>
<hr width="820" size="1">
<span class="style6"> </span></td>
</tr>
</table>
</td>
<td width="90"> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
</table>