PHP grn_goods::update_purchase_order_status Examples

Example #1

File: purchase_order.php Project: patmark/care2x-tz

         $supplierno = $result1->supplier_id;
         $datecreated = $result1->order_date;
         $orderedby = $result1->ordered_by;
     }
     $supplier = $purchaseorder->get_supplier($supplierno);
     echo $purchaseorder->generate_order($orderno, $supplier, $orderedby, $datecreated);
 } else {
     if ($_POST['add'] && $_REQUEST['mode'] == "order_items") {
         $order_id = $_REQUEST['orderid'];
         $product_Id = $_POST['product_id'];
         $quantity = $_POST['quantity'];
         $unitcost = $_POST['unitprice'];
         $amount = $quantity * $unitcost;
         $purchaseorder->add_order_items($order_id, $product_Id, $quantity, $unitcost, $amount);
         $stat = new grn_goods();
         $stat->update_purchase_order_status($orderno);
         $order1 = $purchaseorder->get_order($order_id);
         while ($result1 = $purchaseorder->fetch_object($order1)) {
             $orderno = $result1->order_no;
             $supplierno = $result1->supplier_id;
             $datecreated = $result1->order_date;
             $orderedby = $result1->ordered_by;
         }
         $supplier = $purchaseorder->get_supplier($supplierno);
         echo $purchaseorder->generate_order($orderno, $supplier, $orderedby, $datecreated);
     } else {
         if ($_REQUEST['mode'] == "show") {
             $order_id = $_REQUEST['order_id'];
             $order1 = $purchaseorder->get_order($order_id);
             while ($result1 = $purchaseorder->fetch_object($order1)) {
                 $orderno = $result1->order_no;

Example #2

File: receiving_goods.php Project: patmark/care2x-tz

 $grno = $_REQUEST['grno'];
 $orderno = $_REQUEST['orderno'];
 $itemid = $_POST['itemid'];
 $oquantity = $_POST['oquantity'];
 $rquantity = $_POST['rquantity'];
 $invototal = $rquantity * $_POST['uprice'];
 $status = $_POST['cash_credit'];
 $batch = $_POST['batchno'];
 $expdate = $_POST['expdate'];
 $process = new grn_goods();
 $process->dbconnect();
 $process->dbselect();
 if ($process->add_grn_detail($no, $grno, $orderno, $itemid, $oquantity, $rquantity, $invototal, $status, $batch, $expdate)) {
     $process->update_invoice_grn_master($grno, $orderno, $invototal);
     $process->update_purchase_detail($no, $orderno, $rquantity);
     $process->update_purchase_order_status($orderno);
     $additem->insert_item($itemid, 1, $batch, $expdate, $rquantity);
     echo "The Item is succesful received. ";
     $data = $process->get_grn_details($orderno);
     echo "\n<table padding='2' cellspacing='2' border='1'>\n<tr bgcolor='#CCCCCC'>\n<th>Item name</th><th>Oder number</th><th>Ordered quntity</th><th>Received quanity</th><th>Unit price</th><th>Order Amount</th><th>Invoice Amount</th><th>Receive</th>\n</tr>";
     while ($row = $process->fetch_object($data)) {
         $trans_no = $row->no;
         $order_no = $row->order_no;
         $item_id = $row->itid;
         $orderedquantity = $row->quantity;
         $receivedq = $row->received_quantity;
         $unitcost = $row->unit_cost;
         $totalodered = $row->total_cost;
         $itemname = $row->item_description;
         $am = $row->invoice_total;
         $amount1 = $process->formatMoney($totalodered);