Success! Data Edited Sucessfully.
| S.No |
Product Name |
Patient |
Dealer |
Offer |
Total Sales |
='".$date_paid1."' and DATE(orderdate) <='".$date_paid12."' ";
}
if($_REQUEST['from']!="" && $_REQUEST['to']=="" )
{
$cond9.="and DATE(orderdate) ='".$date_paid1."'";
}
if($_REQUEST['from']!="" && $_REQUEST['to']=="" )
{
$cond9.="and DATE(orderdate) ='".$date_paid12."'";
}
if($_REQUEST['from']!="" && $_REQUEST['to']!="" )
{
$cond9.="and DATE(orderdate) >='".$date_paid1."' and DATE(orderdate) <='".$date_paid12."' ";
}
$table_name="shop_product";
$Query = "SELECT * from shop_product order by name asc";
$namesss=$DB->query($Query);
$nsssss=mysql_num_rows($namesss);
$manssss='0';
$si=0;
while ($rowsss = mysql_fetch_array($namesss)) {
$product_id=$rowsss['product_id'];
$vstatus=$rowsss['vstatus'];
//$status=$rowsss['status'];
//$cat_id=$rowsss['manufacturer_id'];
//SELECT sum(qty) as newqtyy from `tbl_order` where productid='$product_id' $cond9
$no_1=0;
$no=0;
$Query = "SELECT sum(qty) as newqtyy from `tbl_order` where productid='$product_id' and orderid IN(SELECT orderid from tbl_confirmorder ) and user_id IN( SELECT user_id from shop_user where new_status='0') $cond9 ";
$name=$DB->query($Query);
$no=mysql_num_rows($name);
$row = mysql_fetch_array($name);
$nn_ssss="";
$nn_ssss_1="";
$Query_1 = "SELECT sum(qty) as newqtyy from `tbl_order` where productid='$product_id' and freeqty='0' and orderid IN(SELECT orderid from tbl_confirmorder ) and user_id IN( SELECT user_id from shop_user where new_status='1') $cond9 ";
$name_1=$DB->query($Query_1);
$no_1=mysql_num_rows($name_1);
$row_1 = mysql_fetch_array($name_1);
$Query_1_3 = "SELECT sum(qty) as newqtyy from `tbl_order` where productid='$product_id' and orderid IN(SELECT orderid from tbl_confirmorder ) and user_id IN( SELECT user_id from shop_user where new_status='1') $cond9 ";
$name_1_3=$DB->query($Query_1_3);
$no_1_3=mysql_num_rows($name_1_3);
$row_1_3 = mysql_fetch_array($name_1_3);
$Query_1_2 = "SELECT sum(freeqty) as newqtyy from `tbl_order` where productid='$product_id' and freeqty!='0' and orderid IN(SELECT orderid from tbl_confirmorder ) and user_id IN( SELECT user_id from shop_user where new_status='1') $cond9 ";
$name_1_2=$DB->query($Query_1_2);
$no_1_2=mysql_num_rows($name_1_2);
$row_1_2 = mysql_fetch_array($name_1_2);
$nn_ssss=$row_1['newqtyy'];
$nn_ssss_1=$row_1_2['newqtyy'];
$nn_ssss_3=$row_1_3['newqtyy'];
if($nn_ssss!='')
{
$nn_ssss;
if($vstatus==1)
{
$v_qty=($nn_ssss/2);
}
if($vstatus==7)
{
$v_qty=($nn_ssss/2);
}
if($vstatus==6)
{
$v_qty=($nn_ssss/2);
}
if($vstatus==2)
{
$v_qty=($nn_ssss/50);
}
$v_qty=($v_qty*12);
$x = (int)$v_qty;
}
//sprintf("%02d", $to_hour);
?>
|
|
|
|
|
|