X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fpo_entry_items.php;h=4a5aa39dea106fac0d1171781303a6f8ecc8066e;hb=0e15ca861655a6403f12a90f187c3fc00f35949d;hp=3820d7ef5383b6f3adaf2f5706b81e69a891072a;hpb=d9b4de9d7e9d3ba77f6ece752fd6cc988effd8f1;p=fa-stable.git diff --git a/purchasing/po_entry_items.php b/purchasing/po_entry_items.php index 3820d7ef..4a5aa39d 100644 --- a/purchasing/po_entry_items.php +++ b/purchasing/po_entry_items.php @@ -14,6 +14,7 @@ $page_security = 'SA_PURCHASEORDER'; include_once($path_to_root . "/purchasing/includes/po_class.inc"); include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc"); +include_once($path_to_root . "/purchasing/includes/db/suppliers_db.inc"); include_once($path_to_root . "/reporting/includes/reporting.inc"); set_page_security( @$_SESSION['PO']->trans_type, @@ -22,14 +23,17 @@ set_page_security( @$_SESSION['PO']->trans_type, ST_SUPPINVOICE => 'SA_SUPPLIERINVOICE'), array( 'NewOrder' => 'SA_PURCHASEORDER', 'ModifyOrderNumber' => 'SA_PURCHASEORDER', + 'AddedID' => 'SA_PURCHASEORDER', 'NewGRN' => 'SA_GRN', - 'NewInvoice' => 'SA_SUPPLIERINVOICE') + 'AddedGRN' => 'SA_GRN', + 'NewInvoice' => 'SA_SUPPLIERINVOICE', + 'AddedPI' => 'SA_SUPPLIERINVOICE') ); $js = ''; -if ($use_popup_windows) +if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(900, 500); -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); if (isset($_GET['ModifyOrderNumber']) && is_numeric($_GET['ModifyOrderNumber'])) { @@ -56,6 +60,9 @@ if (isset($_GET['ModifyOrderNumber']) && is_numeric($_GET['ModifyOrderNumber'])) page($_SESSION['page_title'], false, false, "", $js); +if (isset($_GET['ModifyOrderNumber'])) + check_is_editable(ST_PURCHORDER, $_GET['ModifyOrderNumber']); + //--------------------------------------------------------------------------------------------------- check_db_has_suppliers(_("There are no suppliers defined in the system.")); @@ -77,7 +84,7 @@ if (isset($_GET['AddedID'])) display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type), 0, 1); - display_note(print_document_link($order_no, _("&Email This Order"), true, $trans_type, false, "", "", 1)); + display_note(print_document_link($order_no, _("&Email This Order"), true, $trans_type, false, "printlink", "", 1)); hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("&Receive Items on this Purchase Order"), "PONumber=$order_no"); @@ -96,6 +103,9 @@ if (isset($_GET['AddedID'])) display_note(get_trans_view_str($trans_type, $trans_no, _("&View this GRN")), 0); + $clearing_act = get_company_pref('grn_clearing_act'); + if ($clearing_act) + display_note(get_gl_view_str($trans_type, $trans_no, _("View the GL Journal Entries for this Delivery")), 1); // not yet // display_note(print_document_link($trans_no, _("&Print This GRN"), true, $trans_type), 0, 1); @@ -124,7 +134,7 @@ if (isset($_GET['AddedID'])) display_note(get_gl_view_str($trans_type, $trans_no, _("View the GL Journal Entries for this Invoice")), 1); hyperlink_params("$path_to_root/purchasing/supplier_payment.php", _("Entry supplier &payment for this invoice"), - "PInvoice=".$trans_no); + "trans_type=$trans_type&PInvoice=".$trans_no); hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$trans_type&trans_no=$trans_no"); @@ -317,55 +327,84 @@ function can_commit() { global $Refs; + if (!get_post('supplier_id')) + { + display_error(_("There is no supplier selected.")); + set_focus('supplier_id'); + return false; + } + if (!is_date($_POST['OrderDate'])) { display_error(_("The entered order date is invalid.")); set_focus('OrderDate'); return false; } - + if (($_SESSION['PO']->trans_type == ST_SUPPRECEIVE || $_SESSION['PO']->trans_type == ST_SUPPINVOICE) + && !is_date_in_fiscalyear($_POST['OrderDate'])) { + display_error(_("The entered date is out of fiscal year or is closed for further data entry.")); + set_focus('OrderDate'); + return false; + } + + if (($_SESSION['PO']->trans_type==ST_SUPPINVOICE) && !is_date($_POST['due_date'])) + { + display_error(_("The entered due date is invalid.")); + set_focus('due_date'); + return false; + } + if (!$_SESSION['PO']->order_no) { - if (!$Refs->is_valid(get_post('ref'))) - { - display_error(_("There is no reference entered for this purchase order.")); - set_focus('ref'); - return false; - } - - if (!is_new_reference(get_post('ref'), $_SESSION['PO']->trans_type)) + if (!check_reference(get_post('ref'), $_SESSION['PO']->trans_type)) { - display_error(_("The entered reference is already in use.")); set_focus('ref'); return false; } } - + + if ($_SESSION['PO']->trans_type == ST_SUPPINVOICE && trim(get_post('supp_ref')) == false) + { + display_error(_("You must enter a supplier's invoice reference.")); + set_focus('supp_ref'); + return false; + } + if ($_SESSION['PO']->trans_type==ST_SUPPINVOICE + && is_reference_already_there($_SESSION['PO']->supplier_id, get_post('supp_ref'), $_SESSION['PO']->order_no)) + { + display_error(_("This invoice number has already been entered. It cannot be entered again.") . " (" . get_post('supp_ref') . ")"); + set_focus('supp_ref'); + return false; + } if ($_SESSION['PO']->trans_type == ST_PURCHORDER && get_post('delivery_address') == '') { display_error(_("There is no delivery address specified.")); set_focus('delivery_address'); return false; } - if (get_post('StkLocation') == '') { display_error(_("There is no location specified to move any items into.")); set_focus('StkLocation'); return false; } - + if (!db_has_currency_rates($_SESSION['PO']->curr_code, $_POST['OrderDate'])) + return false; if ($_SESSION['PO']->order_has_items() == false) { display_error (_("The order cannot be placed because there are no lines entered on this order.")); return false; } - + if (floatcmp(input_num('prep_amount'), $_SESSION['PO']->get_trans_total()) > 0) + { + display_error(_("Required prepayment is greater than total invoice value.")); + set_focus('prep_amount'); + return false; + } + return true; } -//--------------------------------------------------------------------------------------------------- - function handle_commit_order() { $cart = &$_SESSION['PO']; @@ -373,71 +412,19 @@ function handle_commit_order() if (can_commit()) { copy_to_cart(); - if ($cart->trans_type != ST_PURCHORDER) { - // for direct grn/invoice set same dates for lines as for whole document - foreach ($cart->line_items as $line_no =>$line) - $cart->line_items[$line_no]->req_del_date = $cart->orig_order_date; - } + new_doc_date($cart->orig_order_date); if ($cart->order_no == 0) { // new po/grn/invoice - /*its a new order to be inserted */ - $ref = $cart->reference; - if ($cart->trans_type != ST_PURCHORDER) { - $cart->reference = 'auto'; - begin_transaction(); // all db changes as single transaction for direct document - } - $order_no = add_po($cart); - new_doc_date($cart->orig_order_date); - $cart->order_no = $order_no; - - if ($cart->trans_type == ST_PURCHORDER) { - unset($_SESSION['PO']); - meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no"); - } - //Direct GRN - if ($cart->trans_type == ST_SUPPRECEIVE) - $cart->reference = $ref; - $cart->Comments = $cart->reference; //grn does not hold supp_ref - foreach($cart->line_items as $key => $line) - $cart->line_items[$key]->receive_qty = $line->quantity; - $grn_no = add_grn($cart); - if ($cart->trans_type == ST_SUPPRECEIVE) { - commit_transaction(); // save PO+GRN + $trans_no = add_direct_supp_trans($cart); + if ($trans_no) { unset($_SESSION['PO']); - meta_forward($_SERVER['PHP_SELF'], "AddedGRN=$grn_no"); - } -// Direct Purchase Invoice - $inv = new supp_trans; - $inv->is_invoice = true; - $inv->Comments = $cart->Comments; - $inv->supplier_id = $cart->supplier_id; - $inv->tran_date = $cart->orig_order_date; - $inv->reference = $ref; - $inv->supp_reference = $cart->supp_ref; - $supp = get_supplier($cart->supplier_id); - $inv->tax_group_id = $supp['tax_group_id']; -// $inv->ov_discount 'this isn't used at all' -// $inv->terms = not used, TODO - $terms = $supp['payment_terms']; - $inv->ov_amount = $inv->ov_gst = 0; - $inv->due_date = get_invoice_duedate($terms, $inv->tran_date); - foreach($cart->line_items as $key => $line) { - $inv->add_grn_to_trans($line->grn_item_id, $line->po_detail_rec, $line->stock_id, - $line->item_description, $line->receive_qty, 0, $line->receive_qty, - $line->price, $line->price, true, get_standard_cost($line->stock_id), ''); - $inv->ov_amount += round2(($line->receive_qty * $line->price), user_price_dec()); + if ($cart->trans_type == ST_PURCHORDER) + meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no"); + elseif ($cart->trans_type == ST_SUPPRECEIVE) + meta_forward($_SERVER['PHP_SELF'], "AddedGRN=$trans_no"); + else + meta_forward($_SERVER['PHP_SELF'], "AddedPI=$trans_no"); } - $taxes = $inv->get_taxes($inv->tax_group_id, 0, false); - foreach( $taxes as $taxitem) { - $inv->ov_gst += round2($taxitem['Value'], user_price_dec()); - } - $inv_no = add_supp_invoice($inv); - commit_transaction(); // save PO+GRN+PI - // payment for cash terms... - unset($_SESSION['PO']); - meta_forward($_SERVER['PHP_SELF'], "AddedPI=$inv_no"); - } - else { // order modification - + } else { // order modification $order_no = update_po($cart); unset($_SESSION['PO']); meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1"); @@ -445,6 +432,11 @@ function handle_commit_order() } } //--------------------------------------------------------------------------------------------------- +if (isset($_POST['update'])) { + copy_to_cart(); + $Ajax->activate('items_table'); +} + $id = find_submit('Delete'); if ($id != -1) handle_delete_item($id); @@ -479,24 +471,42 @@ echo "
"; display_po_items($_SESSION['PO']); start_table(TABLESTYLE2); + + +if ($_SESSION['PO']->trans_type == ST_SUPPINVOICE) { + cash_accounts_list_row(_("Payment:"), 'cash_account', null, false, _('Delayed')); +} + textarea_row(_("Memo:"), 'Comments', null, 70, 4); end_table(1); div_start('controls', 'items_table'); +$process_txt = _("Place Order"); +$update_txt = _("Update Order"); +$cancel_txt = _("Cancel Order"); +if ($_SESSION['PO']->trans_type == ST_SUPPRECEIVE) { + $process_txt = _("Process GRN"); + $update_txt = _("Update GRN"); + $cancel_txt = _("Cancel GRN"); +} +elseif ($_SESSION['PO']->trans_type == ST_SUPPINVOICE) { + $process_txt = _("Process Invoice"); + $update_txt = _("Update Invoice"); + $cancel_txt = _("Cancel Invoice"); +} if ($_SESSION['PO']->order_has_items()) { if ($_SESSION['PO']->order_no) - submit_center_first('Commit', _("Update Order"), '', 'default'); + submit_center_first('Commit', $update_txt, '', 'default'); else - submit_center_first('Commit', _("Place Order"), '', 'default'); - submit_center_last('CancelOrder', _("Cancel Order")); + submit_center_first('Commit', $process_txt, '', 'default'); + submit_center_last('CancelOrder', $cancel_txt); } else - submit_center('CancelOrder', _("Cancel Order"), true, false, 'cancel'); + submit_center('CancelOrder', $cancel_txt, true, false, 'cancel'); div_end(); //--------------------------------------------------------------------------------------------------- end_form(); end_page(); -?>