| 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/customerzon/ |
Upload File : |
<?php
session_start();
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$_SESSION['message'] = "";
$ProjectId = $_GET['projectId'];
$CompanyId = $_SESSION['ASTACUS_SSO_INFO'][4];
$UserGroupId = $_SESSION['ASTACUS_SSO_INFO'][3];
if($UserGroupId == 2 || $UserGroupId == 7 || $UserGroupId == 8 || $UserGroupId == 10 ){
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and ProjectId = $ProjectId";
}else{
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and ProjectId = $ProjectId and CompanyId = $CompanyId";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$CompanyId = $row['CompanyId'];
$ProjectName = $row['Name'];
$Description = $row['Description'];
$RequestedDeliveryDate = $row['RequestedDeliveryDate'];
$ProjectStatusId = $row['ProjectStatusId'];
$ClientProjectManagerName = $row['clientProjectManagerName'];
$SpecialId = $row['iCADSpecialCompanyID'];
}
if($ProjectName == "" && $ProjectStatusId == "" && ($UserGroupId != 2 && $UserGroupId != 8 && $UserGroupId != 10 )){
$CompanyId = "";
$ProjectId = "";
echo("<center><h1>Kunde inte hitta detta ProjektID till ditt konto!</h1></center>");
exit;
}
$sql = "SELECT * FROM SystemUser WHERE SystemUserId = ".$_SESSION['ASTACUS_SSO_INFO'][0];
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$UserName = $row['Username'];
$Phone = $row['Phone'];
$SkypeId = $row['SkypeId'];
}
?>
<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="http://www.google.com/jsapi">
</script>
<script type="text/javascript">
<!--
google.load("language", "1");
var s;
function initialize() {
var text = document.getElementById("text").value;
google.language.detect(text, function(result) {
if (!result.error && result.language) {
google.language.translate(text, result.language, "en",
function(result) {
var translated = document.getElementById("translation");
if (result.translation) {
translated.value = result.translation;
}
});
}
});
s=setTimeout("initialize()",1000);
}
google.setOnLoadCallback(initialize);
//-->
</script>
<table width="850" height="64" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/tabb5.jpg"><table width="850" height="23" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="5" height="23"> </td>
<td width="111" valign="bottom" class="blacklink"><div align="center"><a href="?page=project&projectId=<?php echo($ProjectId);?>" class="blacklink"><?php echo($a60);?></a></div></td>
<td width="22" valign="bottom" class="blacklink"><div align="center"></div></td>
<td width="106" valign="bottom" class="blacklink"><div align="center"><a href="?page=upload&projectId=<?php echo($ProjectId);?>" class="blacklink"><?php echo($a50);?></a></div></td>
<td width="18" valign="bottom" class="blacklink"><div align="center"></div></td>
<td width="107" valign="bottom" class="blacklink"><div align="center"><a href="?page=download&projectId=<?php echo($ProjectId);?>" class="blacklink"><?php echo($a49);?></a></div></td>
<td width="22" class="blacklink"> </td>
<td width="103" valign="bottom" class="blacklink"><div align="center"><a href="?page=logg&projectId=<?php echo($ProjectId);?>" class="blacklink"><?php echo($a61);?></a></div></td>
<td width="21" class="blacklink"> </td>
<td width="104" valign="bottom" class="blacklink"><div align="center"><a href="?page=settings&projectId=<?php echo($ProjectId);?>" class="blacklink"><?php echo($a62);?></a></div></td>
<td width="138" class="blacklink"> </td>
<td width="23" class="blacklink"> </td>
<td width="70" 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"><?php echo($a62);?></span>
<table width="397" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="398"><span class="heading2"><?php echo($a63);?> <?php echo($CompanyId);?>_<?php echo($ProjectName);?> (<?php echo($ProjectId);?>)</span> <br>
</td>
<td width="57"><div align="right"><span class="textthin"><br>
</span> </div></td>
</tr>
</table></td>
<td width="357" valign="top" class="textthin"><div align="right"><span class="heading1"><a href="/customerzon/"><img src="../images/Back-Arrow.jpg" alt="" width="37" height="36" border="0" align="absmiddle" /></a> <a href="/customerzon/" class="blacklinkhuge"><?php echo($a12);?></a></span></div></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"> </span><span class="heading2"><br>
<?php echo($a81);?><br>
</span>
<form name="form2" method="post" action="changeProjectName.php?projectId=<?php echo($ProjectId);?>">
<table width="450" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="142" class="text"><?php echo($a106);?></td>
<td width="308"><input name="projectname" type="text" id="projectname5" value="<?php echo($ProjectName);?>">
<input type="submit" name="Submit" value="Change">
<span class="heading2"></span></td>
</tr>
</table>
</form>
<form name="form2" method="post" action="changeSpecialId.php?projectId=<?php echo($ProjectId);?>">
<table width="450" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="142" class="text"><?php echo($a106b);?></td>
<td width="308"><input name="SpecialId" type="text" id="SpecialId" value="<?php echo($SpecialId);?>">
<input type="submit" name="Submit" value="Change">
<span class="heading2"></span></td>
</tr>
</table>
</form>
<form name="form2" method="post" action="changeProjectManager.php?projectId=<?php echo($ProjectId);?>">
<br>
<table width="450" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="142"><span class="text"><?php echo($a82);?></span> <span class="heading2"></span></td>
<td width="308"> <span class="heading2">
<span class="text">
<select name="SystemUserId">
<?php
/*$sql = "SELECT Name, SkypeId, Phone, Username, UserGroup.UserGroupId as UserGroupId, SystemUser.SystemUserId
FROM ProjectSystemUserJoin, UserGroup, SystemUser
WHERE UserGroup.UserGroupId = ProjectSystemUserJoin.UserGroupId
AND SystemUser.SystemUserId = ProjectSystemUserJoin.SystemUserId
AND `ProjectId` = $ProjectId
AND SystemUser.SystemUserStatusId = 1
AND (UserGroup.UserGroupId = 4)";*/
$sql = "SELECT *
FROM SystemUser
WHERE `CompanyId` = $CompanyId
AND SystemUser.SystemUserStatusId = 1
";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$SystemUserId = $row['SystemUserId'];
$Name = $row['Name'];
?>
<option value="<?php echo($SystemUserId );?>" <?php if($ClientProjectManagerName == $Name){echo("selected");}?>><?php echo($Name);?></option>
<?php }?>
</select>
</span>
<input type="submit" name="Submit2" value="Update">
</span></td>
</tr>
</table>
</form>
<hr size="1" noshade>
<span class="heading2"><?php echo($a83);?><br>
</span>
<table width="396" border="0" cellpadding="0" cellspacing="0">
<tr class="text">
<td width="203"><?php echo($a84);?></td>
<td width="85"><?php echo($a85);?></td>
<td width="108"><?php echo($a86);?></td>
</tr>
</table>
<br>
<?php
/*$sql = "SELECT Name, SkypeId, Phone, Username, UserGroup.UserGroupId as UserGroupId, SystemUser.SystemUserId
FROM ProjectSystemUserJoin, UserGroup, SystemUser
WHERE UserGroup.UserGroupId = ProjectSystemUserJoin.UserGroupId
AND SystemUser.SystemUserId = ProjectSystemUserJoin.SystemUserId
AND `ProjectId` = $ProjectId
AND SystemUser.SystemUserStatusId = 1
AND UserGroup.UserGroupId = 4";*/
$sql = "SELECT *
FROM SystemUser
WHERE `CompanyId` = $CompanyId
AND SystemUser.SystemUserStatusId = 1
";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$UserGroupdId = $row['UserGroupId'];
$SystemUserId = $row['SystemUserId'];
$Name = $row['Name'];
$Username = $row['Username'];
if($Name == $ClientProjectManagerName){
$Name = $Name . " (Projektledare)";
}
$sql = "Select * from ICADNotification where ProjectId = $ProjectId and SystemUserId=$SystemUserId";
$result2 = mysql_query($sql);
$not1 = 0;
$not2 = 0;
$not3 = 0;
$not4 = 0;
$not5 = 0;
$not6 = 0;
$not7 = 0;
$not8 = 0;
$not9 = 0;
$not10 = 0;
while ($row2 = mysql_fetch_assoc($result2)){
if( $row2['ICADNotificationTypeId'] == 1){
$not1 = 1;
}else if( $row2['ICADNotificationTypeId'] == 2){
$not2 = 2;
}else if( $row2['ICADNotificationTypeId'] == 3){
$not3 = 3;
}else if( $row2['ICADNotificationTypeId'] == 4){
$not4 = 4;
}else if( $row2['ICADNotificationTypeId'] == 5){
$not5 = 5;
}else if( $row2['ICADNotificationTypeId'] == 6){
$not6 = 6;
}else if( $row2['ICADNotificationTypeId'] == 7){
$not7 = 7;
}else if( $row2['ICADNotificationTypeId'] == 8){
$not8 = 8;
}else if( $row2['ICADNotificationTypeId'] == 9){
$not9 = 9;
}else if( $row2['ICADNotificationTypeId'] == 10){
$not10 = 10;
}
}
?>
<table width="397" border="0" cellspacing="0" cellpadding="0">
<tr class="textthin">
<td width="203"><div align="left" class="text"><?php echo($Name);?> <br>
(<?php echo($Username);?>)</div></td>
<td width="84"> </td>
<td width="110"> </td>
</tr>
</table>
<form name="form3" method="post" action="changeNotifications.php?projectId=<?php echo($ProjectId);?>">
<table width="397" border="0" cellspacing="0" cellpadding="0">
<tr class="textthin">
<td width="203"><div align="left"><?php echo($a87);?>
</div></td>
<td width="84"><input name="not1" type="checkbox" id="not1" value="1" <?php if($not1 == 1){echo("checked");}?>> </td>
<td width="110"><input name="not6" type="checkbox" id="not6" value="6" <?php if($not6 == 6){echo("checked");}?>> </td>
</tr>
<tr class="textthin">
<td><div align="left"><?php echo($a88);?> </div></td>
<td><input name="not2" type="checkbox" id="not2" value="2" <?php if($not2 == 2){echo("checked");}?>> </td>
<td><input name="not7" type="checkbox" id="not7" value="7" <?php if($not7 == 7){echo("checked");}?>>
</td>
</tr>
<tr class="textthin">
<td><?php echo($a89);?> </td>
<td><input name="not3" type="checkbox" id="not3" value="3" <?php if($not3 == 3){echo("checked");}?>>
</td>
<td><input name="not8" type="checkbox" id="not8" value="8" <?php if($not8 == 8){echo("checked");}?>> </td>
</tr>
<tr class="textthin">
<td><?php echo($a90);?> </td>
<td width="84"><input name="not4" type="checkbox" id="not4" value="4" <?php if($not4 == 4){echo("checked");}?>> </td>
<td width="110"><input name="not9" type="checkbox" id="not9" value="9" <?php if($not9 == 9){echo("checked");}?>> </td>
</tr>
<tr class="textthin">
<td><?php echo($a91);?></td>
<td><input name="not5" type="checkbox" id="not5" value="5" <?php if($not5 == 5){echo("checked");}?>> </td>
<td><input name="not10" type="checkbox" id="not10" value="10" <?php if($not10 == 10){echo("checked");}?>> </td>
</tr>
<tr class="textthin">
<td> </td>
<td colspan="2"><input type="submit" name="Submit3" value=" Update ">
<input name="SystemUserId" type="hidden" id="SystemUserId" value="<?php echo($SystemUserId);?>"></td>
</tr>
</table>
</form> <?php }?> <p class="text"><?php echo($a92);?><br />
<br />
</p>
<?php if($_SESSION['ASTACUS_SSO_INFO'][3] == 2 || $_SESSION['ASTACUS_SSO_INFO'][3] == 8 || $_SESSION['ASTACUS_SSO_INFO'][3] == 10){
$sql = "Select * from ICADNotification where ProjectId = $ProjectId and SystemUserId=".$_SESSION['ASTACUS_SSO_INFO'][0];
$result2 = mysql_query($sql);
$not1 = 0;
$not2 = 0;
$not3 = 0;
$not4 = 0;
$not5 = 0;
$not6 = 0;
$not7 = 0;
$not8 = 0;
$not9 = 0;
$not10 = 0;
while ($row2 = mysql_fetch_assoc($result2)){
if( $row2['ICADNotificationTypeId'] == 1){
$not1 = 1;
}else if( $row2['ICADNotificationTypeId'] == 2){
$not2 = 2;
}else if( $row2['ICADNotificationTypeId'] == 3){
$not3 = 3;
}else if( $row2['ICADNotificationTypeId'] == 4){
$not4 = 4;
}else if( $row2['ICADNotificationTypeId'] == 5){
$not5 = 5;
}else if( $row2['ICADNotificationTypeId'] == 6){
$not6 = 6;
}else if( $row2['ICADNotificationTypeId'] == 7){
$not7 = 7;
}else if( $row2['ICADNotificationTypeId'] == 8){
$not8 = 8;
}else if( $row2['ICADNotificationTypeId'] == 9){
$not9 = 9;
}else if( $row2['ICADNotificationTypeId'] == 10){
$not10 = 10;
}
}
?>
<hr />
<form name="form3" method="post" action="changeNotifications.php?projectId=<?php echo($ProjectId);?>">
<span class="style6"><strong>Ange vilka notifieringar du (<?php echo($UserName);?>) vill ha:</strong></span>
<table width="396" border="0" cellpadding="0" cellspacing="0">
<tr class="text">
<td width="203"><?php echo($a84);?></td>
<td width="85"><?php echo($a85);?></td>
<td width="108"><?php echo($a86);?></td>
</tr>
</table>
<table width="397" border="0" cellspacing="0" cellpadding="0">
<tr class="textthin">
<td width="203"><div align="left"><?php echo($a87);?> </div></td>
<td width="84"><input name="not1" type="checkbox" id="not11" value="1" <?php if($not1 == 1){echo("checked");}?> /></td>
<td width="110"><input name="not6" type="checkbox" id="not12" value="6" <?php if($not6 == 6){echo("checked");}?> /></td>
</tr>
<tr class="textthin">
<td><div align="left"><?php echo($a88);?></div></td>
<td><input name="not2" type="checkbox" id="not13" value="2" <?php if($not2 == 2){echo("checked");}?> /></td>
<td><input name="not7" type="checkbox" id="not14" value="7" <?php if($not7 == 7){echo("checked");}?> /></td>
</tr>
<tr class="textthin">
<td><?php echo($a89);?></td>
<td><input name="not3" type="checkbox" id="not15" value="3" <?php if($not3 == 3){echo("checked");}?> /></td>
<td><input name="not8" type="checkbox" id="not16" value="8" <?php if($not8 == 8){echo("checked");}?> /></td>
</tr>
<tr class="textthin">
<td><?php echo($a90);?></td>
<td width="84"><input name="not4" type="checkbox" id="not17" value="4" <?php if($not4 == 4){echo("checked");}?> /></td>
<td width="110"><input name="not9" type="checkbox" id="not18" value="9" <?php if($not9 == 9){echo("checked");}?> /></td>
</tr>
<tr class="textthin">
<td><?php echo($a91);?></td>
<td><input name="not5" type="checkbox" id="not19" value="5" <?php if($not5 == 5){echo("checked");}?> /></td>
<td><input name="not10" type="checkbox" id="not20" value="10" <?php if($not10 == 10){echo("checked");}?> /></td>
</tr>
<tr class="textthin">
<td> </td>
<td colspan="2"><input type="submit" name="Submit4" value=" Update " />
<input name="SystemUserId" type="hidden" id="SystemUserId" value="<?php echo($_SESSION['ASTACUS_SSO_INFO'][0]);?>" /></td>
</tr>
</table>
</form>
<strong><span class="style6">OBS: Gäller från både Indien och kunder!</span></strong><br />
<br />
<?php }?>
<p class="text"> </p>
<p class="heading2"> </p></td>
<td width="17"> </td>
<td width="348" valign="top"><table width="340" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><form name="form1" method="post" action="addlogg.php?ProjectId=<?php echo($ProjectId);?>&type=logg">
</form> </td>
</tr>
<tr>
<td><div align="right"><!--
Skype 'My status' button
http://www.skype.com/go/skypebuttons
-->
<br>
<br>
<span class="heading2"> </span></div></td>
</tr>
</table></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>