コード例 #1
0
ファイル: DB.php プロジェクト: sandeepsis/nuwax
         $_SESSION['msg'] = 'Please enter valid seller / purchaser contact no';
         $num = 'danger';
         $url = ADMIN_URL . "/purchaseorders/add.php";
         $general->redirectUrl($url, $num);
         exit;
     }
 }
 if (trim($_REQUEST['voucherdate']) == "") {
     $_SESSION['msg'] = 'Please select Voucher date';
     $num = 'danger';
     $url = ADMIN_URL . "/purchaseorders/add.php";
     $general->redirectUrl($url, $num);
     exit;
 }
 $fieldvalues = array('voucherno' => $_REQUEST['voucherno'], 'productid' => $_REQUEST['product'], 'productquantity' => $_REQUEST['productqty'], "name" => $_REQUEST['name'], "emailaddress" => $_REQUEST['emailaddress'], "contactno" => $_REQUEST['contactno'], "voucherdate" => $_REQUEST['voucherdate'], 'vouchertype' => $_REQUEST['vouchertype'], "remark" => $_REQUEST['remark'], "date_added" => date('Y-m-d H:i:s'));
 $updated = $Purchaseorder->addPurchaseorder($fieldvalues);
 if ($updated) {
     $rows = $Purchaseorder->getProductById($_REQUEST['product']);
     $curr_stock = $rows->current_stock;
     $new_stock = $curr_stock + $_REQUEST['productqty'];
     $fieldvalues1 = array('current_stock' => $new_stock);
     $cond = array('id' => $_REQUEST['product']);
     $Purchaseorder->updateProduct($fieldvalues1, $cond);
 }
 if ($updated) {
     $general->addLogAction($_SESSION['adm_user_id'], 'Added', $updated, 'Purchase orders', $_SESSION['adm_status']);
     $error = 'success';
     $_SESSION['msg'] = 'Record added successfully.';
 } else {
     $error = 'danger';
     $_SESSION['msg'] = 'Error adding record.';