".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3); $countRB1=$srnum[0]; while($rowregB1=mysql_fetch_array($page_res3)){$countRB1++;} $queB2="select * from customer where regdte='$tdte' and branch='B2'"; if (!($page_resB2 = mysql_query($queB2))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resB2); $countRB2=$srnum[0]; while($rowregB2=mysql_fetch_array($page_resB2)){$countRB2++;} $queB3="select * from customer where regdte='$tdte' and branch='B3'"; if (!($page_resB3 = mysql_query($queB3))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resB3); $countRB3=$srnum[0]; while($rowregB3=mysql_fetch_array($page_resB3)){$countRB3++;} $queB4="select * from customer where regdte='$tdte' and branch='B4'"; if (!($page_resB4 = mysql_query($queB4))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resB4); $countRB4=$srnum[0]; while($rowregB4=mysql_fetch_array($page_resB4)){$countRB4++;} $queB5="select * from customer where regdte='$tdte' and branch='B5'"; if (!($page_resB5 = mysql_query($queB5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resB5); $countRB5=$srnum[0]; while($rowregB5=mysql_fetch_array($page_resB5)){$countRB5++;} $queRsum="select * from customer where status='Y' and regdte='$tdte'"; if (!($page_resRsum = mysql_query($queRsum))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resRsum); $countRsum=$srnum[0]; while($rowregBsum=mysql_fetch_array($page_resRsum)){$countRsum++;} $resultSB1 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='B1'") or die(mysql_error()); $rowsSB1 = mysql_fetch_array($resultSB1); $resultSB2 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='B2'") or die(mysql_error()); $rowsSB2 = mysql_fetch_array($resultSB2); $resultSB3 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='B3'") or die(mysql_error()); $rowsSB3 = mysql_fetch_array($resultSB3); $resultSB4 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='B4'") or die(mysql_error()); $rowsSB4 = mysql_fetch_array($resultSB4); $resultSB5 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='B5'") or die(mysql_error()); $rowsSB5 = mysql_fetch_array($resultSB5); $resultpmsum = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE())") or die(mysql_error()); $rowssumpm = mysql_fetch_array($resultpmsum); $que4="SELECT * FROM customer where branch='B1' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)"; if (!($page_res4 = mysql_query($que4))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res4); $count4B1=$srnum[0]; while($row4=mysql_fetch_array($page_res4)){$count4B1++;} $queb2="SELECT * FROM customer where branch='B2' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)"; if (!($page_resb2 = mysql_query($queb2))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resb2); $count4B2=$srnum[0]; while($row4=mysql_fetch_array($page_resb2)){$count4B2++;} $queb3="SELECT * FROM customer where branch='B3' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)"; if (!($page_resb3 = mysql_query($queb3))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resb3); $count4B3=$srnum[0]; while($row4=mysql_fetch_array($page_resb3)){$count4B3++;} $queb4="SELECT * FROM customer where branch='B4' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)"; if (!($page_resb4 = mysql_query($queb4))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resb4); $count4B4=$srnum[0]; while($row4=mysql_fetch_array($page_resb4)){$count4B4++;} $queb5="SELECT * FROM customer where branch='B5' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)"; if (!($page_resb5 = mysql_query($queb5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resb5); $count4B5=$srnum[0]; while($row4=mysql_fetch_array($page_resb5)){$count4B5++;} $rmdte = date("m-Y"); $que5="SELECT * FROM customer where rdte='$rmdte'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $count5=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$count5++;} $resultTSB1 = mysql_query("SELECT sum(price) FROM record where branch='B1'") or die(mysql_error()); $rowsTSB1 = mysql_fetch_array($resultTSB1); $resultTSB2 = mysql_query("SELECT sum(price) FROM record where branch='B2'") or die(mysql_error()); $rowsTSB2 = mysql_fetch_array($resultTSB2); $resultTSB3 = mysql_query("SELECT sum(price) FROM record where branch='B3'") or die(mysql_error()); $rowsTSB3 = mysql_fetch_array($resultTSB3); $resultTSB4 = mysql_query("SELECT sum(price) FROM record where branch='B4'") or die(mysql_error()); $rowsTSB4 = mysql_fetch_array($resultTSB4); $resultTSB5 = mysql_query("SELECT sum(price) FROM record where branch='B5'") or die(mysql_error()); $rowsTSB5 = mysql_fetch_array($resultTSB5); $resultTSsum = mysql_query("SELECT sum(price) FROM record") or die(mysql_error()); $rowssumTS = mysql_fetch_array($resultTSsum); $que3B1="select * from customer where branch='B1'"; if (!($page_res3B1 = mysql_query($que3B1))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3B1); $count3B1=$srnum[0]; while($row=mysql_fetch_array($page_res3B1)){$count3B1++;} $que3B2="select * from customer where branch='B2'"; if (!($page_res3B2 = mysql_query($que3B2))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3B2); $count3B2=$srnum[0]; while($row=mysql_fetch_array($page_res3B2)){$count3B2++;} $que3B3="select * from customer where branch='B3'"; if (!($page_res3B3 = mysql_query($que3B3))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3B3); $count3B3=$srnum[0]; while($row=mysql_fetch_array($page_res3B3)){$count3B3++;} $que3B4="select * from customer where branch='B4'"; if (!($page_res3B4 = mysql_query($que3B4))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3B4); $count3B4=$srnum[0]; while($row=mysql_fetch_array($page_res3B4)){$count3B4++;} $que3B5="select * from customer where branch='B5'"; if (!($page_res3B5 = mysql_query($que3B5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res3B5); $count3B5=$srnum[0]; while($row=mysql_fetch_array($page_res3B5)){$count3B5++;} $quetr="select * from customer"; if (!($page_restr = mysql_query($quetr))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_restr); $counttr=$srnum[0]; while($row=mysql_fetch_array($page_restr)){$counttr++;} /* start No of Active Customers */ $rmdte = date("m-Y"); //$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='B1'"; $que5="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B1'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $countA52=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$countA52++;} //$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='B2'"; $que5="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B2'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $countA53=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$countA53++;} //$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='B3'"; $que5="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B3'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $countA54=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$countA54++;} //$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='B4'"; $que5="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B4'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $countA55=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$countA55++;} //$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='B5'"; $que5="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B5'"; if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res5); $countA56=$srnum[0]; while($row5=mysql_fetch_array($page_res5)){$countA56++;} //$qt="SELECT * FROM customer_product_point where rdte='$rmdte'"; $qt="SELECT * FROM customer_product_point where endmonth >= DATE_SUB(CURDATE(), INTERVAL 0 DAY)"; if (!($page_resqt = mysql_query($qt))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resqt); $countActive=$srnum[0]; while($row5=mysql_fetch_array($page_resqt)){$countActive++;} /* end No of Active Customers */ /* start No of inActive Customers */ $rmdte = date("m-Y"); //$queB1="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='B1'"; $queB1="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B1'"; if (!($page_res6 = mysql_query($queB1))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res6); $countINB1=$srnum[0]; while($row6=mysql_fetch_array($page_res6)){$countINB1++;} //$queB2="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='B2'"; $queB2="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B2'"; if (!($page_res6 = mysql_query($queB2))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res6); $countINB2=$srnum[0]; while($row6=mysql_fetch_array($page_res6)){$countINB2++;} //$queB3="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='B3'"; $queB3="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B3'"; if (!($page_res6 = mysql_query($queB3))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res6); $countINB3=$srnum[0]; while($row6=mysql_fetch_array($page_res6)){$countINB3++;} //$queB4="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='B4'"; $queB4="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B4'"; if (!($page_res6 = mysql_query($queB4))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res6); $countINB4=$srnum[0]; while($row6=mysql_fetch_array($page_res6)){$countINB4++;} // $queB5="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='B5'"; $queB5="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY) and branch='B5'"; if (!($page_res6 = mysql_query($queB5))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res6); $countINB5=$srnum[0]; while($row6=mysql_fetch_array($page_res6)){$countINB5++;} //$qt="SELECT * FROM customer_product_point where rdte!='$rmdte'"; $qtinActive="SELECT * FROM customer_product_point where endmonth <= DATE_SUB(CURDATE(), INTERVAL 0 DAY)"; if (!($page_resqt = mysql_query($qtinActive))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_resqt); $countINActive=$srnum[0]; while($row5=mysql_fetch_array($page_resqt)){$countINActive++;} /* end No of inActive Customers */ $odte = date("Y/m/d"); $que7="SELECT * FROM tbl_order where odate='$odte' and branch='B1'"; if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res7); $countB17=$srnum[0]; while($row7=mysql_fetch_array($page_res7)){$countB17++;} $que7="SELECT * FROM tbl_order where odate='$odte' and branch='B2'"; if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res7); $countB27=$srnum[0]; while($row7=mysql_fetch_array($page_res7)){$countB27++;} $que7="SELECT * FROM tbl_order where odate='$odte' and branch='B3'"; if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res7); $countB37=$srnum[0]; while($row7=mysql_fetch_array($page_res7)){$countB37++;} $que7="SELECT * FROM tbl_order where odate='$odte' and branch='B4'"; if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res7); $countB47=$srnum[0]; while($row7=mysql_fetch_array($page_res7)){$countB47++;} $que7="SELECT * FROM tbl_order where odate='$odte'"; if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res7); $count00=$srnum[0]; while($row7=mysql_fetch_array($page_res7)){$count00++;} $odte = date("m-Y"); $que8="SELECT * FROM tbl_order where omdte='$odte' and branch='B1'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $countB18=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$countB18++;} $que8="SELECT * FROM tbl_order where omdte='$odte' and branch='B2'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $countB28=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$countB28++;} $que8="SELECT * FROM tbl_order where omdte='$odte' and branch='B3'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $countB38=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$countB38++;} $que8="SELECT * FROM tbl_order where omdte='$odte' and branch='B4'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $countB48=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$countB48++;} $que8="SELECT * FROM tbl_order where omdte='$odte' and branch='B5'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $countB58=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$countB58++;} $que8="SELECT * FROM tbl_order where omdte='$odte'"; if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res8); $count11=$srnum[0]; while($row8=mysql_fetch_array($page_res8)){$count11++;} $que9="SELECT * FROM tbl_order where branch='B1'"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $countB19=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$countB19++;} $que9="SELECT * FROM tbl_order where branch='B2'"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $countB29=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$countB29++;} $que9="SELECT * FROM tbl_order where branch='B3'"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $countB39=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$countB39++;} $que9="SELECT * FROM tbl_order where branch='B4'"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $countB49=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$countB49++;} $que9="SELECT * FROM tbl_order where branch='B5'"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $countB59=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$countB59++;} $que9="SELECT * FROM tbl_order"; if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql
".mysql_error(); exit;} $rowCount = mysql_num_rows($page_res9); $count22=$srnum[0]; while($row9=mysql_fetch_array($page_res9)){$count22++;} ?>

Dashboard

Welcome to Admin