Access to system settings moved from global scope to SysPrefs.

[fa-stable.git] / sales / manage / recurrent_invoices.php

diff --git a/sales/manage/recurrent_invoices.php b/sales/manage/recurrent_invoices.php
index f646ff2af685d62bbdfcfabc8d4315b98dafbd57..8a08a6d1c63d652b209346124afe2d2e18e1489a 100644 (file)
--- a/sales/manage/recurrent_invoices.php
+++ b/sales/manage/recurrent_invoices.php
@@ -13,11 +13,12 @@ $page_security = 'SA_SRECURRENT';
 $path_to_root = "../..";
 include($path_to_root . "/includes/session.inc");
 include($path_to_root . "/includes/ui.inc");
+include_once($path_to_root . "/sales/includes/sales_db.inc");
 
 $js = "";
-if ($use_popup_windows)
+if ($SysPrefs->use_popup_windows)
        $js .= get_js_open_window(900, 600);
-if ($use_date_picker)
+if (user_use_date_picker())
        $js .= get_js_date_picker();
 
 page(_($help_context = "Recurrent Invoices"), false, false, "", $js);
@@ -29,40 +30,51 @@ if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
 
        $input_error = 0;
 
+       if (strlen($_POST['order_no']) == 0) 
+       {
+               $input_error = 1;
+               display_error(_("No order has been selected as a template for recurrent invoicing."));
+               set_focus('order_no');
+       }
        if (strlen($_POST['description']) == 0) 
        {
                $input_error = 1;
-               display_error(_("The area description cannot be empty."));
+               display_error(_("The invoice description cannot be empty."));
                set_focus('description');
        }
+       if (!is_date($_POST['begin'])) {
+               $input_error = 1;
+               display_error(_("The entered date is invalid."));
+               set_focus('begin');
+       }
+       if (!is_date($_POST['end'])) {
+               $input_error = 1;
+               display_error(_("The entered date is invalid."));
+               set_focus('end');
+       }
+       if (isset($_POST['last_sent']) && !is_date($_POST['last_sent'])) {
+               $input_error = 1;
+               display_error(_("The entered date is invalid."));
+               set_focus('last_sent');
+       }
 
        if ($input_error != 1)
        {
        if ($selected_id != -1) 
        {
-               $sql = "UPDATE ".TB_PREF."recurrent_invoices SET 
-                       description=".db_escape($_POST['description']).", 
-                       order_no=".db_escape($_POST['order_no']).", 
-                       debtor_no=".db_escape($_POST['debtor_no']).", 
-                       group_no=".db_escape($_POST['group_no']).", 
-                       days=".input_num('days', 0).", 
-                       monthly=".input_num('monthly', 0).", 
-                       begin='".date2sql($_POST['begin'])."', 
-                       end='".date2sql($_POST['end'])."' 
-                       WHERE id = ".db_escape($selected_id);
+               update_recurrent_invoice($selected_id, $_POST['description'], $_POST['order_no'], input_num('debtor_no'), 
+                       input_num('group_no'), input_num('days', 0), input_num('monthly', 0), $_POST['begin'], $_POST['end']);
+               if (isset($_POST['last_sent'])) 
+                               update_last_sent_recurrent_invoice($selected_id, $_POST['last_sent']);
                        $note = _('Selected recurrent invoice has been updated');
        } 
        else 
        {
-               $sql = "INSERT INTO ".TB_PREF."recurrent_invoices (description, order_no, debtor_no,
-                       group_no, days, monthly, begin, end, last_sent) VALUES (".db_escape($_POST['description']) . ", "
-                       .db_escape($_POST['order_no']).", ".db_escape($_POST['debtor_no']).", "
-                       .db_escape($_POST['group_no']).", ".input_num('days', 0).", ".input_num('monthly', 0).", '"
-                       .date2sql($_POST['begin'])."', '".date2sql($_POST['end'])."', '".date2sql(Add_Years($_POST['begin'], -5))."')";
+               add_recurrent_invoice($_POST['description'], $_POST['order_no'], input_num('debtor_no'), input_num('group_no'),
+                       input_num('days', 0), input_num('monthly', 0), $_POST['begin'], $_POST['end']);
                        $note = _('New recurrent invoice has been added');
        }
     
-       db_query($sql,"The recurrent invoice could not be updated or added");
                display_notification($note);            
                $Mode = 'RESET';
        }
@@ -75,8 +87,7 @@ if ($Mode == 'Delete')
 
        if ($cancel_delete == 0) 
        {
-               $sql="DELETE FROM ".TB_PREF."recurrent_invoices WHERE id=".db_escape($selected_id);
-               db_query($sql,"could not delete recurrent invoice");
+               delete_recurrent_invoice($selected_id);
 
                display_notification(_('Selected recurrent invoice has been deleted'));
        } //end if Delete area
@@ -89,19 +100,11 @@ if ($Mode == 'RESET')
        unset($_POST);
 }
 //-------------------------------------------------------------------------------------------------
-function get_sales_group_name($group_no)
-{
-       $sql = "SELECT description FROM ".TB_PREF."groups WHERE id = ".db_escape($group_no);
-       $result = db_query($sql, "could not get group");
-       $row = db_fetch($result);
-       return $row[0];
-}
 
-$sql = "SELECT * FROM ".TB_PREF."recurrent_invoices ORDER BY description, group_no, debtor_no";
-$result = db_query($sql,"could not get recurrent invoices");
+$result = get_recurrent_invoices();
 
 start_form();
-start_table("$table_style width=70%");
+start_table(TABLESTYLE, "width=70%");
 $th = array(_("Description"), _("Template No"),_("Customer"),_("Branch")."/"._("Group"),_("Days"),_("Monthly"),_("Begin"),_("End"),_("Last Created"),"", "");
 table_header($th);
 $k = 0;
@@ -109,7 +112,7 @@ while ($myrow = db_fetch($result))
 {
        $begin = sql2date($myrow["begin"]);
        $end = sql2date($myrow["end"]);
-       $last_sent = sql2date($myrow["last_sent"]);
+       $last_sent = $myrow["last_sent"] == '0000-00-00' ? '' : sql2date($myrow["last_sent"]);
        
        alt_table_row_color($k);
                
@@ -143,16 +146,13 @@ echo '<br>';
 
 start_form();
 
-start_table($table_style2);
+start_table(TABLESTYLE2);
 
 if ($selected_id != -1) 
 {
        if ($Mode == 'Edit') {
                //editing an existing area
-               $sql = "SELECT * FROM ".TB_PREF."recurrent_invoices WHERE id=".db_escape($selected_id);
-
-               $result = db_query($sql,"could not get recurrent invoice");
-               $myrow = db_fetch($result);
+               $myrow = get_recurrent_invoice($selected_id);
 
                $_POST['description']  = $myrow["description"];
                $_POST['order_no']  = $myrow["order_no"];
@@ -162,6 +162,7 @@ if ($selected_id != -1)
                $_POST['monthly']  = $myrow["monthly"];
                $_POST['begin']  = sql2date($myrow["begin"]);
                $_POST['end']  = sql2date($myrow["end"]);
+               $_POST['last_sent']  = ($myrow['last_sent']=="0000-00-00"?"":sql2date($myrow["last_sent"]));
        } 
        hidden("selected_id", $selected_id);
 }
@@ -186,6 +187,9 @@ date_row(_("Begin:"), 'begin');
 
 date_row(_("End:"), 'end', null, null, 0, 0, 5);
 
+if ($selected_id != -1 && $_POST['last_sent'] != "")
+       date_row(_("Last Created"), 'last_sent');
+
 end_table(1);
 
 submit_add_or_update_center($selected_id == -1, '', 'both');
@@ -193,4 +197,3 @@ submit_add_or_update_center($selected_id == -1, '', 'both');
 end_form();
 
 end_page();
-?>