File manager

File manager - Edit - /home/autoph/public_html/pms_v1/mancom/saveActualByModel.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']); //GET MODEL ID $md = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `model_code`='$modelCode' LIMIT 1"; $qMD = mysqli_query($conn,$md); while($row = mysqli_fetch_array($qMD)){ $modelID = $row['id']; } $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_by_model WHERE `year`='$selYear' AND `month_id`='$selMonth' AND `model_id`='$modelID' 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_by_model SET `sales_count`='$inValue',`date_added`='$myTimeStamp',`added_by`='$userID' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selMonth' AND `model_id`='$modelID'"; if($conn->query($sql) === TRUE) { } else { } }else{ $sqlA="INSERT INTO mancom_synergy_by_model( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `model_id`, `sales_count`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$selectedCompanyID', '$dealerID', '$selYear', '$selMonth', '$modelID', '$inValue', '$myTimeStamp', '$userID' )"; if($conn->query($sqlA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } $variant = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `brand_id`='$selectedCompanyID' ORDER BY `model_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['id']; $totaSalesCount=0; $totayModelSales = "SELECT SUM(sales_count) AS 'totaSalesCount' FROM `mancom_synergy_by_model` WHERE `model_id`='$activeModel' AND `comp_id`='$selectedCompanyID' AND `year`='$selYear' AND `mancom_hdr_id`='$manHeadercomID'"; $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