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 . "
" . $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 "TOTAL | ";
while($row = mysqli_fetch_array($qVar)){
echo "";
$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 " | ";
}
}
$conn->close();
}
//1 jan 1 1
//3 jan 1 3
?>