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