File manager

File manager - Edit - /home/autoph/public_html/pms_v1/mancom/saveActualByCompany.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveMe'])){ $inValue = sanitize($_POST['inValue']); $modelCode = sanitize($_POST['modelCode']); $selYear = sanitize($_POST['selYear']); $userID = sanitize($_POST['userID']); $selMonth = sanitize($_POST['selMonth']); $dealerID = sanitize($_POST['dealerID']); $selectedCompanyID = sanitize($_POST['selectedCompanyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); //CHECK IF RECORD EXIST IF. IF YES, UPDATE RECORD IF NOT INSERT RECORD $ckRec="SELECT * FROM mancom_synergy_out_company WHERE `year`='$selYear' AND `month_id`='$selMonth' AND `comp_code`='$modelCode' AND `comp_id`='$selectedCompanyID' AND `deal_id`='$dealerID' AND `mancom_hdr_id`='$manHeadercomID'"; $qRec = mysqli_query($conn,$ckRec); $recCount = mysqli_num_rows($qRec); if($recCount > 0){ $sql = "UPDATE mancom_synergy_out_company SET `sales_count`='$inValue',`date_added`='$myTimeStamp',`added_by`='$userID' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selMonth' AND `comp_code`='$modelCode'"; if($conn->query($sql) === TRUE) { } else { } }else{ $sqlA="INSERT INTO mancom_synergy_out_company( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `comp_code`, `sales_count`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$selectedCompanyID', '$dealerID', '$selYear', '$selMonth', '$modelCode', '$inValue', '$myTimeStamp', '$userID' )"; if($conn->query($sqlA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } $variant = "SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_code` ASC"; $qVar = mysqli_query($conn,$variant); $qvCount = mysqli_num_rows($qVar); if($qvCount > 0){ echo "<td class='text-center bg-light text-dark font-weight-bold'>TOTAL</td>"; while($row = mysqli_fetch_array($qVar)){ echo "<td class='text-center bg-light text-dark p-3 font-weight-bold'>"; $activeModel = $row['comp_code']; $totayModelSales = "SELECT SUM(sales_count) AS 'totaSalesCount' FROM `mancom_synergy_out_company` WHERE `comp_code`='$activeModel' AND `comp_id`='$selectedCompanyID' AND `year`='$selYear' AND `mancom_hdr_id`='$manHeadercomID' AND `month_id` !='' LIMIT 1"; $qCount = mysqli_query($conn,$totayModelSales); $qRow = mysqli_num_rows($qCount); if($qRow > 0){ while($sRow = mysqli_fetch_array($qCount)){ $totaSalesCount = $sRow['totaSalesCount']; } } echo $totaSalesCount; echo "</td>"; } } $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings