| Server IP : 79.136.114.73 / Your IP : 13.59.90.172 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/appsrv.astacus.se/thermotech/ |
Upload File : |
<?php
?>
<link href="../main.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="calendar.js"></script>
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
-->
</style>
<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"><span class="heading2">Dina uppgifter: </span><br>
<table width="651" border="0" cellpadding="0" cellspacing="0">
<tr >
<td width="60" class="text">Namn:</td>
<td width="215" class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][1]);?> (<?php echo($_SESSION['ASTACUS_SSO_INFO'][10]);?>) </td>
<td width="106" class="text">Adress:</td>
<td width="270" class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][7]);?></td>
</tr>
<tr >
<td class="text">E-post:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][2]);?></td>
<td class="text">Postnummer:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][8]);?></td>
</tr>
<tr >
<td class="text">Telefon:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][6]);?></td>
<td class="text">Stad:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][9]);?></td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<hr width="820" size="1">
<span class="heading2"><br>
</span>
<table width="820" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="455" height="677" valign="top"><span class="heading2">Dina projekt: </span><br>
<table width="455" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="60" class="style6"><strong><a href="?order=ProjectId" class="blacklink">ProjektID</a></strong></td>
<td width="200" class="style6"><strong><a href="?order=Name" class="blacklink">Namn</a></strong></td>
<td width="95" class="style6"><strong><a href="?order=ProjectStatusId" class="blacklink">Beräknad lev.</a></strong></td>
<td width="100"><span class="style6"><strong><a href="?order=clientProjectManagerName" class="blacklink">Skapat av </a></strong></span></td>
</tr>
</table>
<span class="style6">
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$orderby = $_GET['order'];
if($orderby == ""){
$orderby = "ProjectId";
}
if($orderby == "ProjectStatusId"){
$orderby = "ProjectStatus.ProjectStatusId";
}
$CompanyId = $_SESSION['ASTACUS_SSO_INFO'][4];
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and CompanyId = $CompanyId and not ProjectStatus.ProjectStatusID = 11 and not ProjectStatus.ProjectStatusID = 10 order by $orderby desc";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$ProjectStatusId = $row['ProjectStatusId'];
if($ProjectStatusId == 1 || $ProjectStatusId == 2 || $ProjectStatusId == 3 ){
$status = "process1.jpg";
}else if($ProjectStatusId == 4){
$status = "process2.jpg";
}else if($ProjectStatusId == 5){
$status = "process3.jpg";
}else if($ProjectStatusId == 6){
$status = "process6.jpg";
}else if($ProjectStatusId == 7){
$status = "process7.jpg";
}else if($ProjectStatusId == 8 || $ProjectStatusId == 9 || $ProjectStatusId == 10){
$status = "process8.jpg";
}else if($ProjectStatusId == 11){
$status = "process10.jpg";
} else if($ProjectStatusId == 12){
$status = "process9.jpg";
}
$price = $row['TimeEstimationFromIndia'];
/* if($price != 0){
$price = round($price * 140,0);
$price = $price . " kr";
}else {
$price = "";
}*/
if($row['ProjectStatusId'] == 12){
$color = "#FF0000";
}else if($row['ProjectStatusId'] == 1) {
$color = "#ffc600";
}else{
$color = "#ffffff";
}
?>
</span>
<table width="455" border="0" cellspacing="0" cellpadding="0">
<tr align="left" >
<td width="60" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['ProjectId']);?></a></td>
<td width="200" height="20" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['Name']);?></a></td>
<td width="95" valign="middle" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php
$RDate = $row['RequestedDeliveryDate'];
if($RDate != ""){
echo("Vecka ".date("W",strtotime($row['RequestedDeliveryDate'])));
}
?></a> </td>
<td width="100" bgcolor="<?php echo($color);?>" ><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['clientProjectManagerName']);?></a></td>
</tr>
</table>
<span class="style6">
<?php } ?>
<br>
<br>
</span>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="14" bgcolor="#FF0000"> </td>
<td width="151"> Mer i nformation krävs </td>
<td width="14" bgcolor="#ffc600"> </td>
<td width="162"> Projektet ej i produktion</td>
<td width="32"> </td>
<td width="9"> </td>
<td width="68"> </td>
</tr>
</table>
<span class="style6"> </span></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">Skapa nytt projekt</span><form name="form1" method="post" action="addproject.php">
<table width="300" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90" class="text">Namn:</td>
<td width="210"><div align="right">
<input name="Projectname" type="text" class="textthin" id="Projectname" size="30">
</div></td>
</tr>
<tr>
<td class="text">Önskat leveransdatum:</td>
<td><div align="right" class="textthin">
<script>DateInput('orderdate', true, 'YYYY-MON-DD')</script>
</div></td>
</tr>
<tr>
<td> </td>
<td><div align="right">
<input name="Submit" type="submit" class="textthin" value="Skapa projekt!">
</div></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" background="../images/platta2.jpg"><table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2">Dina resurser </span> <table width="160" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="163" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="92" class="textthin">Avtalstyp</td>
<td width="68" class="textthin">Antal</td>
<td rowspan="8" class="textthin"></td>
</tr>
<tr >
<td colspan="2">
<table width="164" height="9" border="0" cellpadding="0" cellspacing="0">
<?php
$total = 0;
$daysleft = "2010-06-17";
$sql = "SELECT * FROM ICADType where Type < 3;";
$count = 1;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$nbr = "0 st";
$sql2 = "SELECT count(ICADTypeID) as Number, ICADTypeId, CustomerId, WorkDays FROM ICADAccount, ICADFlush where CustomerId = $CompanyId and ICADFlush.CompanyID = ICADAccount.CustomerId group by ICADTypeID ";
$result2 = mysql_query($sql2);
while ($row2 = mysql_fetch_assoc($result2)){
if($row2['ICADTypeId'] == $row['ICADTypeId']){
$nbr = $row2['Number']. " st";
$total += $row['Hours']*$row2['Number']*($row2['WorkDays']);
}
}
?>
<tr class="textthin">
<td width="93" class="textthin"><?php echo($row['Name']);?></td>
<td width="71" class="textthin"><?php echo($nbr);?></td>
</tr>
<?php
if($count == 3){
?>
<tr>
<td height="9" class="textthin"> </td>
<td class="textthin"> </td>
</tr>
<?php
}
$count++;
?>
<?php
}
?>
</table></td>
</tr>
</table></td>
<td valign="top"><table width="160" height="110" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<?php
$sql = "SELECT * FROM ICADTime, Project where Project.ProjectId = ICADTime.ProjectId and Project.CompanyId = $CompanyId;";
$result = mysql_query($sql);
$TimeSpent = 0;
while ($row = mysql_fetch_assoc($result)){
$TimeSpent += $row['Hours'];
}
$left = $total - $TimeSpent;
$percent = $TimeSpent / $total;
$percent = (100-round($percent,1)*100);
?>
<td background="../images/procent/p<?php echo($percent);?>.jpg"><div align="center" class="textthin">
<?php
echo("$left timmar kvar t.o.m. <br>$daysleft");
?> </div></td>
</tr>
</table></td>
</tr>
</table>
<a href="#" class="blacklink"><br>
Behöver du köpa till fler resurser? Klicka här. </a> <span class="heading2"></span></td>
</tr>
</table></td>
</tr>
</table>
<br> <br>
</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>