Preview: gift-approve.php
Size: 1.26 KB
/home/urbanman/roadkaraja.in/manager/gift-approve.php
<?php
error_reporting(~E_ALL);
include("config.php");
$mode = $_GET['mode'];
//$cid = $_GET['cid'];
$id = $_GET[id];
$typ = $_GET[typ];
$tdate = date("Y/m/d");
$vnumber = $_GET[vnumber];
$pid = $_GET[pid];
if($typ =="unapprove")
{
$query1 = sprintf("update tbl_order set permition = 'approve' where id = '%d' ",$id);
if(!($result1=mysql_query($query1))){echo mysql_error($query1); exit;}
header("location:gift-list.php?flag=unapprove&number=$vnumber"); exit;
}
if($typ =="approve")
{
$branch = $_SESSION['branch'];
$query = sprintf("update tbl_order set permition = 'approve' , ddate='$tdate' , branch='$branch' where id = '%d' ",$id);
if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
$que = sprintf("Select * from product WHERE id = '%d' ",$pid);
if(!($res=mysql_query($que))){echo "Error : - ".$que.mysql_error(); exit;}
$row_cart = mysql_fetch_array($res);
$stock = $row_cart['qty'];
$avilable_qty = $stock - 1;
$query_update=sprintf("UPDATE product SET qty='%s' where id='%d' ",$avilable_qty,$pid);
if(!($res=mysql_query($query_update))){echo $query_update.mysql_error(); exit;}
header("location:gift-list.php?vnumber=$vnumber");exit;
}
?>
Directory Contents
Dirs: 5 × Files: 59