PHP sql_query::prepare_sql_addorderby方法代码示例

 function execute()
 {
     $this->obj_form = new form_input();
     $this->obj_form->formname = "bankstatementimport";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "accounts/import/bankstatement-process.php";
     $this->obj_form->method = "post";
     $structure = NULL;
     $structure["fieldname"] = "BANK_STATEMENT";
     $structure["type"] = "file";
     $this->obj_form->add_input($structure);
     $structure = charts_form_prepare_acccountdropdown("dest_account", "ar_payment");
     $structure["options"]["req"] = "yes";
     $structure["options"]["autoselect"] = "yes";
     $structure["options"]["search_filter"] = "enabled";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("staff");
     $sql_struct_obj->prepare_sql_addfield("id", "staff.id");
     $sql_struct_obj->prepare_sql_addfield("label", "staff.staff_code");
     $sql_struct_obj->prepare_sql_addfield("label1", "staff.name_staff");
     $sql_struct_obj->prepare_sql_addorderby("staff_code");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("employeeid", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["width"] = "600";
     $structure["options"]["search_filter"] = "enabled";
     $structure["defaultvalue"] = @$_SESSION["user"]["default_employeeid"];
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "submit";
     $structure["type"] = "submit";
     $structure["defaultvalue"] = "Import";
     $this->obj_form->add_input($structure);
     $this->obj_form->subforms["upload_bank_statement"] = array("BANK_STATEMENT", "dest_account", "employeeid");
     $this->obj_form->subforms["import"] = array("submit");
 }

 function execute()
 {
     log_debug("invoice_form_details", "Executing execute()");
     if ($this->invoiceid) {
         $this->mode = "edit";
     } else {
         $this->mode = "add";
     }
     /*
     	Make sure invoice does exist and fetch locked status
     */
     if ($this->mode == "edit") {
         $sql_invoice_obj = new sql_query();
         $sql_invoice_obj->string = "SELECT id, locked FROM account_" . $this->type . " WHERE id='" . $this->invoiceid . "' LIMIT 1";
         $sql_invoice_obj->execute();
         if (!$sql_invoice_obj->num_rows()) {
             print "<p><b>Error: The requested invoice does not exist. <a href=\"index.php?page=accounts/" . $this->type . "/" . $this->type . ".php\">Try looking on the invoice/invoice list page.</a></b></p>";
             return 0;
         } else {
             $sql_invoice_obj->fetch_array();
             $this->locked = $sql_invoice_obj->data[0]["locked"];
         }
     }
     /*
     	Start Form
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = $this->type . "_invoice_" . $this->mode;
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = $this->processpage;
     $this->obj_form->method = "POST";
     /*
     	Define form structure
     */
     // basic details
     if ($this->type == "ap") {
         $sql_struct_obj = new sql_query();
         $sql_struct_obj->prepare_sql_settable("vendors");
         $sql_struct_obj->prepare_sql_addfield("id", "vendors.id");
         $sql_struct_obj->prepare_sql_addfield("label", "vendors.code_vendor");
         $sql_struct_obj->prepare_sql_addfield("label1", "vendors.name_vendor");
         $sql_struct_obj->prepare_sql_addorderby("code_vendor");
         $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
         $structure = form_helper_prepare_dropdownfromobj("vendorid", $sql_struct_obj);
         $structure["options"]["req"] = "yes";
         $structure["options"]["width"] = "600";
         $structure["options"]["search_filter"] = "enabled";
         $structure["defaultvalue"] = $this->vendor_id;
         $this->obj_form->add_input($structure);
     } else {
         // load customer dropdown
         $sql_struct_obj = new sql_query();
         $sql_struct_obj->prepare_sql_settable("customers");
         $sql_struct_obj->prepare_sql_addfield("id", "customers.id");
         $sql_struct_obj->prepare_sql_addfield("label", "customers.code_customer");
         $sql_struct_obj->prepare_sql_addfield("label1", "customers.name_customer");
         $sql_struct_obj->prepare_sql_addorderby("code_customer");
         $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
         $structure = form_helper_prepare_dropdownfromobj("customerid", $sql_struct_obj);
         $structure["options"]["req"] = "yes";
         $structure["options"]["width"] = "600";
         $structure["options"]["search_filter"] = "enabled";
         $structure["defaultvalue"] = $this->customer_id;
         $this->obj_form->add_input($structure);
     }
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("staff");
     $sql_struct_obj->prepare_sql_addfield("id", "staff.id");
     $sql_struct_obj->prepare_sql_addfield("label", "staff.staff_code");
     $sql_struct_obj->prepare_sql_addfield("label1", "staff.name_staff");
     $sql_struct_obj->prepare_sql_addorderby("staff_code");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("employeeid", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["autoselect"] = "yes";
     $structure["options"]["width"] = "600";
     $structure["options"]["search_filter"] = "enabled";
     $structure["defaultvalue"] = @$_SESSION["user"]["default_employeeid"];
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "code_invoice";
     $structure["type"] = "input";
     if ($this->mode == "edit") {
         $structure["options"]["req"] = "yes";
     }
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "code_ordernumber";
     $structure["type"] = "input";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "code_ponumber";
     $structure["type"] = "input";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "notes";
     $structure["type"] = "textarea";
     $structure["options"]["height"] = "100";
     $structure["options"]["width"] = 500;
     $this->obj_form->add_input($structure);
//.........这里部分代码省略.........

 function execute()
 {
     /*
     	Define form structure
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "transaction_view";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "accounts/gl/edit-process.php";
     $this->obj_form->method = "post";
     // general
     $structure = NULL;
     $structure["fieldname"] = "code_gl";
     $structure["type"] = "input";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "date_trans";
     $structure["type"] = "date";
     $structure["defaultvalue"] = date("Y-m-d");
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("staff");
     $sql_struct_obj->prepare_sql_addfield("id", "staff.id");
     $sql_struct_obj->prepare_sql_addfield("label", "staff.staff_code");
     $sql_struct_obj->prepare_sql_addfield("label1", "staff.name_staff");
     $sql_struct_obj->prepare_sql_addorderby("staff_code");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("employeeid", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["autoselect"] = "yes";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "description";
     $structure["type"] = "input";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "description_useall";
     $structure["type"] = "checkbox";
     $structure["options"]["label"] = "Check this to use the description above as the description in all the rows below. Untick if you wish to have different messages for each transaction item.";
     $structure["defaultvalue"] = "on";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "notes";
     $structure["type"] = "textarea";
     $structure["options"]["width"] = "600";
     $structure["options"]["height"] = "50";
     $this->obj_form->add_input($structure);
     /*
     	Define transaction form structure
     */
     // unless there has been error data returned, fetch all the transactions
     // from the DB, and work out the number of rows
     if (!isset($_SESSION["error"]["form"][$this->obj_form->formname])) {
         $sql_trans_obj = new sql_query();
         $sql_trans_obj->string = "SELECT date_trans, amount_debit, amount_credit, chartid, source, memo FROM `account_trans` WHERE type='gl' AND customid='" . $this->id . "'";
         $sql_trans_obj->execute();
         if ($sql_trans_obj->num_rows()) {
             $sql_trans_obj->fetch_array();
             $this->num_trans = $sql_trans_obj->data_num_rows + 1;
         }
     } else {
         $this->num_trans = @security_script_input('/^[0-9]*$/', $_SESSION["error"]["num_trans"]) + 1;
     }
     // ensure there are always 2 rows at least, additional rows are added if required (ie viewing
     // an existing transaction) or on the fly when needed by javascript UI.
     if ($this->num_trans < 2) {
         $this->num_trans = 2;
     }
     // transaction rows
     for ($i = 0; $i < $this->num_trans; $i++) {
         // account
         $structure = form_helper_prepare_dropdownfromdb("trans_" . $i . "_account", "SELECT id, code_chart as label, description as label1 FROM account_charts WHERE chart_type!='1' ORDER BY code_chart");
         $structure["options"]["width"] = "200";
         $this->obj_form->add_input($structure);
         // debit field
         $structure = NULL;
         $structure["fieldname"] = "trans_" . $i . "_debit";
         $structure["type"] = "input";
         $structure["options"]["width"] = "80";
         $this->obj_form->add_input($structure);
         // credit field
         $structure = NULL;
         $structure["fieldname"] = "trans_" . $i . "_credit";
         $structure["type"] = "input";
         $structure["options"]["width"] = "80";
         $this->obj_form->add_input($structure);
         // source
         $structure = NULL;
         $structure["fieldname"] = "trans_" . $i . "_source";
         $structure["type"] = "input";
         $structure["options"]["width"] = "100";
         $this->obj_form->add_input($structure);
         // description
         $structure = NULL;
         $structure["fieldname"] = "trans_" . $i . "_description";
         $structure["type"] = "textarea";
         $this->obj_form->add_input($structure);
//.........这里部分代码省略.........

 function execute()
 {
     log_debug("quote_form_details", "Executing execute()");
     if ($this->quoteid) {
         $this->mode = "edit";
     } else {
         $this->mode = "add";
     }
     /*
     	Start Form
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "quote_" . $this->mode;
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = $this->processpage;
     $this->obj_form->method = "POST";
     /*
     	Define form structure
     */
     // basic details
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("customers");
     $sql_struct_obj->prepare_sql_addfield("id", "customers.id");
     $sql_struct_obj->prepare_sql_addfield("label", "customers.code_customer");
     $sql_struct_obj->prepare_sql_addfield("label1", "customers.name_customer");
     $sql_struct_obj->prepare_sql_addorderby("code_customer");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("customerid", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("staff");
     $sql_struct_obj->prepare_sql_addfield("id", "staff.id");
     $sql_struct_obj->prepare_sql_addfield("label", "staff.staff_code");
     $sql_struct_obj->prepare_sql_addfield("label1", "staff.name_staff");
     $sql_struct_obj->prepare_sql_addorderby("staff_code");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("employeeid", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["autoselect"] = "yes";
     $structure["options"]["width"] = "600";
     $structure["defaultvalue"] = $_SESSION["user"]["default_employeeid"];
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "code_quote";
     $structure["type"] = "input";
     if ($this->mode == "edit") {
         $structure["options"]["req"] = "yes";
     }
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "notes";
     $structure["type"] = "textarea";
     $structure["options"]["height"] = "100";
     $structure["options"]["width"] = 500;
     $this->obj_form->add_input($structure);
     // dates
     $structure = NULL;
     $structure["fieldname"] = "date_trans";
     $structure["type"] = "date";
     $structure["defaultvalue"] = date("Y-m-d");
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "date_validtill";
     $structure["type"] = "date";
     $structure["defaultvalue"] = quotes_calc_duedate(date("Y-m-d"));
     $this->obj_form->add_input($structure);
     // ID
     $structure = NULL;
     $structure["fieldname"] = "id_quote";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->quoteid;
     $this->obj_form->add_input($structure);
     // submit
     $structure = NULL;
     $structure["fieldname"] = "submit";
     $structure["type"] = "submit";
     $structure["defaultvalue"] = "Save Changes";
     $this->obj_form->add_input($structure);
     // load data
     $this->obj_form->sql_query = "SELECT customerid, employeeid, code_quote, notes, date_trans, date_validtill FROM account_quotes WHERE id='" . $this->quoteid . "'";
     $this->obj_form->load_data();
     // define subforms
     $this->obj_form->subforms["quote_details"] = array("customerid", "employeeid", "code_quote", "date_trans", "date_validtill");
     $this->obj_form->subforms["quote_other"] = array("notes");
     $this->obj_form->subforms["hidden"] = array("id_quote");
     $this->obj_form->subforms["submit"] = array("submit");
 }

//.........这里部分代码省略.........
         $structure["defaultvalue"] = "<p>Check all taxes that apply to this service below.</p>";
         $this->obj_form->add_input($structure);
         $this->obj_form->subforms["service_tax"][] = "tax_message";
         // run through all the taxes
         $sql_tax_obj->fetch_array();
         foreach ($sql_tax_obj->data as $data_tax) {
             // define tax checkbox
             $structure = NULL;
             $structure["fieldname"] = "tax_" . $data_tax["id"];
             $structure["type"] = "checkbox";
             $structure["options"]["label"] = $data_tax["name_tax"] . " -- " . $data_tax["description"];
             $structure["options"]["no_fieldname"] = "enable";
             if ($this->serviceid) {
                 // see if this tax is currently enabled for this service
                 $sql_obj = new sql_query();
                 $sql_obj->string = "SELECT id FROM services_taxes WHERE serviceid='" . $this->serviceid . "' AND taxid='" . $data_tax["id"] . "' LIMIT 1";
                 $sql_obj->execute();
                 if ($sql_obj->num_rows()) {
                     $structure["defaultvalue"] = "on";
                 }
             } else {
                 if ($data_tax["default_services"]) {
                     $structure["defaultvalue"] = "on";
                 }
             }
             // add to form
             $this->obj_form->add_input($structure);
             $this->obj_form->subforms["service_tax"][] = "tax_" . $data_tax["id"];
         }
     }
     /*
     	Upstream Vendor Information
     
     	These fields are purely for users notes/record keeping purposes.
     */
     $structure = NULL;
     $structure["fieldname"] = "upstream_help_message";
     $structure["type"] = "message";
     $structure["defaultvalue"] = "<p>" . lang_trans("upstream_help_message") . "</p>";
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("vendors");
     $sql_struct_obj->prepare_sql_addfield("id", "vendors.id");
     $sql_struct_obj->prepare_sql_addfield("label", "vendors.code_vendor");
     $sql_struct_obj->prepare_sql_addfield("label1", "vendors.name_vendor");
     $sql_struct_obj->prepare_sql_addorderby("code_vendor");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("upstream_id", $sql_struct_obj);
     $structure["options"]["search_filter"] = "yes";
     $structure["options"]["width"] = "400";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "upstream_notes";
     $structure["type"] = "textarea";
     $structure["options"]["width"] = "600";
     $structure["options"]["height"] = "100";
     $this->obj_form->add_input($structure);
     $this->obj_form->subforms["service_upstream"] = array("upstream_help_message", "upstream_id", "upstream_notes");
     // define subforms
     if (user_permissions_get("services_write")) {
         $this->obj_form->subforms["submit"] = array("submit");
     } else {
         $this->obj_form->subforms["submit"] = array("");
     }
     /*
     	Mode dependent options
     */
     if ($this->mode == "add") {
         // submit button
         $structure = NULL;
         $structure["fieldname"] = "submit";
         $structure["type"] = "submit";
         $structure["defaultvalue"] = "Create Service";
         $this->obj_form->add_input($structure);
     } else {
         // submit button
         $structure = NULL;
         $structure["fieldname"] = "submit";
         $structure["type"] = "submit";
         $structure["defaultvalue"] = "Save Changes";
         $this->obj_form->add_input($structure);
         // hidden data
         $structure = NULL;
         $structure["fieldname"] = "id_service";
         $structure["type"] = "hidden";
         $structure["defaultvalue"] = $this->serviceid;
         $this->obj_form->add_input($structure);
         $this->obj_form->subforms["hidden"] = array("id_service");
     }
     /*
     	Load Data
     */
     if ($this->mode == "add") {
         $this->obj_form->load_data_error();
     } else {
         // load details data
         $this->obj_form->sql_query = "SELECT \n\t\t\t\t\t\t\t\tservices.name_service, \n\t\t\t\t\t\t\t\tservices.chartid, \n\t\t\t\t\t\t\t\tservices.id_service_group,\n\t\t\t\t\t\t\t\tservices.id_service_group_usage,\n\t\t\t\t\t\t\t\tservices.description, \n\t\t\t\t\t\t\t\tservice_types.name as typeid,\n\t\t\t\t\t\t\t\tservices.upstream_id as upstream_id,\n\t\t\t\t\t\t\t\tservices.upstream_notes as upstream_notes\n\t\t\t\t\t\t\tFROM `services`\n\t\t\t\t\t\t\tLEFT JOIN service_types ON service_types.id = services.typeid\n\t\t\t\t\t\t\tWHERE services.id='" . $this->serviceid . "' LIMIT 1";
         $this->obj_form->load_data();
     }
 }

 function execute()
 {
     /*
     	Define form structure
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "orders_view";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "customers/orders-edit-process.php";
     $this->obj_form->method = "post";
     /*
     	Define Orders (products-style)
     */
     // basic details
     $structure = NULL;
     $structure["fieldname"] = "date_ordered";
     $structure["type"] = "date";
     $structure["defaultvalue"] = date("Y-m-d");
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "type";
     $structure["type"] = "text";
     $structure["defaultvalue"] = $this->obj_customer->data_orders["type"];
     $this->obj_form->add_input($structure);
     $this->obj_form->subforms["order_basic"] = array("date_ordered", "type");
     /*
     	Item Specifics
     */
     switch ($this->obj_customer->data_orders["type"]) {
         case "product":
             // price
             $structure = null;
             $structure["fieldname"] = "price";
             $structure["type"] = "money";
             $this->obj_form->add_input($structure);
             // quantity
             $structure = null;
             $structure["fieldname"] = "quantity";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $this->obj_form->add_input($structure);
             // units
             $structure = null;
             $structure["fieldname"] = "units";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $structure["options"]["max_length"] = 10;
             $this->obj_form->add_input($structure);
             // product id
             $sql_struct_obj = new sql_query();
             $sql_struct_obj->prepare_sql_settable("products");
             $sql_struct_obj->prepare_sql_addfield("id", "products.id");
             $sql_struct_obj->prepare_sql_addfield("label", "products.code_product");
             $sql_struct_obj->prepare_sql_addfield("label1", "products.name_product");
             $sql_struct_obj->prepare_sql_addorderby("code_product");
             $sql_struct_obj->prepare_sql_addwhere("id = 'currentid' or date_end = '0000-00-00'");
             $structure = form_helper_prepare_dropdownfromobj("productid", $sql_struct_obj);
             $structure["options"]["search_filter"] = "enabled";
             $structure["options"]["width"] = "600";
             $this->obj_form->add_input($structure);
             // description
             $structure = null;
             $structure["fieldname"] = "description";
             $structure["type"] = "textarea";
             $structure["options"]["height"] = "50";
             $structure["options"]["width"] = 500;
             $this->obj_form->add_input($structure);
             // discount
             $structure = null;
             $structure["fieldname"] = "discount";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $structure["options"]["label"] = " %";
             $structure["options"]["max_length"] = "2";
             $this->obj_form->add_input($structure);
             // subform
             $this->obj_form->subforms["order_product"] = array("productid", "price", "quantity", "units", "description", "discount");
             break;
         case "service":
             // price
             $structure = null;
             $structure["fieldname"] = "price";
             $structure["type"] = "money";
             $this->obj_form->add_input($structure);
             // discount
             $structure = null;
             $structure["fieldname"] = "discount";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $structure["options"]["label"] = " %";
             $structure["options"]["max_length"] = "2";
             $this->obj_form->add_input($structure);
             // service id
             $sql_struct_obj = new sql_query();
             $sql_struct_obj->prepare_sql_settable("services");
             $sql_struct_obj->prepare_sql_addfield("id", "services.id");
             $sql_struct_obj->prepare_sql_addfield("label", "services.name_service");
             $sql_struct_obj->prepare_sql_addorderby("name_service");
             $structure = form_helper_prepare_dropdownfromobj("serviceid", $sql_struct_obj);
             $structure["options"]["search_filter"] = "enabled";
//.........这里部分代码省略.........

//.........这里部分代码省略.........
             
             	Product item - selection of a product from the DB, and specify quantity, unit and amount.
             */
         /*
         	PRODUCT
         
         	Product item - selection of a product from the DB, and specify quantity, unit and amount.
         */
         case "product":
             // basic details
             $structure = NULL;
             $structure["fieldname"] = "price";
             $structure["type"] = "money";
             $this->obj_form->add_input($structure);
             // quantity
             $structure = NULL;
             $structure["fieldname"] = "quantity";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $this->obj_form->add_input($structure);
             // units
             $structure = NULL;
             $structure["fieldname"] = "units";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $structure["options"]["max_length"] = 10;
             $this->obj_form->add_input($structure);
             // product id
             $sql_struct_obj = new sql_query();
             $sql_struct_obj->prepare_sql_settable("products");
             $sql_struct_obj->prepare_sql_addfield("id", "products.id");
             $sql_struct_obj->prepare_sql_addfield("label", "products.code_product");
             $sql_struct_obj->prepare_sql_addfield("label1", "products.name_product");
             $sql_struct_obj->prepare_sql_addorderby("code_product");
             $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
             $structure = form_helper_prepare_dropdownfromobj("productid", $sql_struct_obj);
             $structure["options"]["search_filter"] = "enabled";
             $structure["options"]["width"] = "600";
             $this->obj_form->add_input($structure);
             // description
             $structure = NULL;
             $structure["fieldname"] = "description";
             $structure["type"] = "textarea";
             $structure["options"]["height"] = "50";
             $structure["options"]["width"] = 500;
             $this->obj_form->add_input($structure);
             // discount
             $structure = NULL;
             $structure["fieldname"] = "discount";
             $structure["type"] = "input";
             $structure["options"]["width"] = 50;
             $structure["options"]["label"] = " %";
             $structure["options"]["max_length"] = "2";
             $this->obj_form->add_input($structure);
             // define form layout
             $this->obj_form->subforms[$this->type . "_invoice_item"] = array("productid", "price", "quantity", "units", "description", "discount");
             // fetch data
             //
             // if the item is new, use the this->item field to fetch the default product details, otherwise
             // fetch the details for the existing item
             //
             if ($this->itemid) {
                 $this->obj_form->sql_query = "SELECT price, description, customid as productid, quantity, units FROM account_items WHERE id='" . $this->itemid . "'";
             } else {
                 if ($this->type == "ar" || $this->type == "quotes") {
                     $this->obj_form->sql_query = "SELECT id as productid, price_sale as price, units, details as description FROM products WHERE id='" . $this->productid . "'";

 function execute()
 {
     /*
     	Define form structure
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "credit_refund";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "customers/credit-refund-edit-process.php";
     $this->obj_form->method = "post";
     // basic details
     $structure = NULL;
     $structure["fieldname"] = "date_trans";
     $structure["type"] = "date";
     $structure["defaultvalue"] = date("Y-m-d");
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "type";
     $structure["type"] = "text";
     $structure["defaultvalue"] = "refund";
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("staff");
     $sql_struct_obj->prepare_sql_addfield("id", "staff.id");
     $sql_struct_obj->prepare_sql_addfield("label", "staff.staff_code");
     $sql_struct_obj->prepare_sql_addfield("label1", "staff.name_staff");
     $sql_struct_obj->prepare_sql_addorderby("staff_code");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("id_employee", $sql_struct_obj);
     $structure["options"]["req"] = "yes";
     $structure["options"]["autoselect"] = "yes";
     $structure["options"]["width"] = "600";
     $structure["options"]["search_filter"] = "enabled";
     $structure["defaultvalue"] = @$_SESSION["user"]["default_employeeid"];
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "description";
     $structure["type"] = "textarea";
     $structure["defaultvalue"] = "";
     $structure["options"]["req"] = "yes";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     // amount
     $structure = NULL;
     $structure["fieldname"] = "amount";
     $structure["type"] = "money";
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure = charts_form_prepare_acccountdropdown("account_asset", "ap_payment");
     $structure["options"]["search_filter"] = "enabled";
     $structure["options"]["autoselect"] = "enabled";
     $structure["options"]["width"] = "600";
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure = charts_form_prepare_acccountdropdown("account_dest", "ar_summary_account");
     $structure["options"]["search_filter"] = "enabled";
     $structure["options"]["autoselect"] = "enabled";
     $structure["options"]["width"] = "600";
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     // hidden values
     $structure = NULL;
     $structure["fieldname"] = "id_customer";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->obj_customer->id;
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "id_refund";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->obj_refund->id;
     $this->obj_form->add_input($structure);
     // submit button
     $structure = NULL;
     $structure["fieldname"] = "submit";
     $structure["type"] = "submit";
     $structure["defaultvalue"] = "Save Changes";
     $this->obj_form->add_input($structure);
     // define base subforms
     $this->obj_form->subforms["credit_refund_details"] = array("date_trans", "type", "id_employee", "description");
     $this->obj_form->subforms["credit_refund_amount"] = array("amount", "account_asset", "account_dest");
     $this->obj_form->subforms["hidden"] = array("id_customer", "id_refund");
     $this->obj_form->subforms["submit"] = array("submit");
     // fetch the form data if editing
     if ($this->obj_refund->id) {
         // load existing information
         $this->obj_refund->load_data();
         $this->obj_form->structure["date_trans"]["defaultvalue"] = $this->obj_refund->data["date_trans"];
         $this->obj_form->structure["amount"]["defaultvalue"] = $this->obj_refund->data["amount_total"];
         $this->obj_form->structure["id_employee"]["defaultvalue"] = $this->obj_refund->data["id_employee"];
         $this->obj_form->structure["description"]["defaultvalue"] = $this->obj_refund->data["description"];
     } else {
         // set defaults
         $this->obj_form->structure["date_trans"]["defaultvalue"] = date("Y-m-d");
         $this->obj_form->structure["amount"]["defaultvalue"] = sql_get_singlevalue("SELECT SUM(amount_total) as value FROM customers_credits WHERE id_customer='" . $this->obj_customer->id . "' AND id!='" . $this->obj_refund->id . "'");
     }
     if (error_check()) {
         // load any data returned due to errors
//.........这里部分代码省略.........

 function execute()
 {
     /*
     	Check if time entry can be adjusted
     */
     if ($this->id) {
         $sql_obj = new sql_query();
         $sql_obj->string = "SELECT locked, groupid FROM `timereg` WHERE id='" . $this->id . "' LIMIT 1";
         $sql_obj->execute();
         if ($sql_obj->num_rows()) {
             $sql_obj->fetch_array();
             $this->locked = $sql_obj->data[0]["locked"];
             // so we can tell if the time is locked
             $this->groupid = $sql_obj->data[0]["groupid"];
             // tells us what group id the time belongs to
         }
         unset($sql_obj);
     }
     /*
     	Input Form
     
     	Allows the creation of a new entry for the day, or the adjustment of an existing one.
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "timereg_day";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "timekeeping/timereg-day-edit-process.php";
     $this->obj_form->method = "post";
     // hidden stuff
     $structure = NULL;
     $structure["fieldname"] = "id_timereg";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->id;
     $this->obj_form->add_input($structure);
     // employee selection box
     $sql_obj = new sql_query();
     $sql_obj->prepare_sql_settable("staff");
     $sql_obj->prepare_sql_addfield("id", "id");
     $sql_obj->prepare_sql_addfield("label", "staff_code");
     $sql_obj->prepare_sql_addfield("label1", "name_staff");
     if ($this->access_staff_ids_write) {
         $sql_obj->prepare_sql_addwhere("id IN (" . format_arraytocommastring($this->access_staff_ids_write) . ")");
     }
     $sql_obj->generate_sql();
     $structure = form_helper_prepare_dropdownfromdb("employeeid", $sql_obj->string);
     // if there is currently no employee set, and there is only one
     // employee in the selection box, automatically select it and update
     // the session variables.
     if (!$this->employeeid && count($structure["values"]) == 1) {
         $this->employeeid = $structure["values"][0];
         $_SESSION["form"]["timereg"]["employeeid"] = $structure["values"][0];
     }
     $structure["options"]["autoselect"] = "on";
     $structure["options"]["width"] = "600";
     $structure["options"]["search_filter"] = "yes";
     $structure["defaultvalue"] = $this->employeeid;
     $this->obj_form->add_input($structure);
     // general
     $structure = NULL;
     $structure["fieldname"] = "date";
     $structure["type"] = "date";
     $structure["defaultvalue"] = $this->date;
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "time_booked";
     $structure["type"] = "hourmins";
     $structure["options"]["req"] = "yes";
     $this->obj_form->add_input($structure);
     $structure = NULL;
     $structure["fieldname"] = "description";
     $structure["type"] = "textarea";
     $structure["options"]["req"] = "yes";
     $structure["options"]["width"] = "600";
     $structure["options"]["height"] = "60";
     $this->obj_form->add_input($structure);
     //project dropdown
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("projects");
     $sql_struct_obj->prepare_sql_addfield("id", "projects.id");
     $sql_struct_obj->prepare_sql_addfield("label", "projects.code_project");
     $sql_struct_obj->prepare_sql_addfield("label1", "projects.name_project");
     $sql_struct_obj->prepare_sql_addorderby("code_project");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("projectid", $sql_struct_obj);
     $structure["options"]["autoselect"] = "on";
     $structure["options"]["width"] = "600";
     $structure["options"]["search_filter"] = "yes";
     if (count($structure["values"]) == 0) {
         $structure["defaultvalue"] = "You need to create a project and add a phase to it in order to be able to book time.";
         $_SESSION["error"]["phaseid-error"] = 1;
     }
     $this->obj_form->add_input($structure);
     //phase dropdown
     $structure = NULL;
     $structure["fieldname"] = "phaseid";
     $structure["type"] = "dropdown";
     $structure["values"] = array("");
     $structure["options"]["width"] = "600";
     $structure["options"]["disabled"] = "yes";
//.........这里部分代码省略.........

 function execute()
 {
     /*
     	Define form structure
     */
     $this->obj_form = new form_input();
     $this->obj_form->formname = "timebilled_view";
     $this->obj_form->language = $_SESSION["user"]["lang"];
     $this->obj_form->action = "projects/timebilled-edit-process.php";
     $this->obj_form->method = "post";
     // general
     $structure = NULL;
     $structure["fieldname"] = "name_group";
     $structure["type"] = "input";
     $structure["options"]["req"] = "yes";
     $structure["defaultvalue"] = date("Y-m");
     $this->obj_form->add_input($structure);
     $sql_struct_obj = new sql_query();
     $sql_struct_obj->prepare_sql_settable("customers");
     $sql_struct_obj->prepare_sql_addfield("id", "customers.id");
     $sql_struct_obj->prepare_sql_addfield("label", "customers.code_customer");
     $sql_struct_obj->prepare_sql_addfield("label1", "customers.name_customer");
     $sql_struct_obj->prepare_sql_addorderby("code_customer");
     $sql_struct_obj->prepare_sql_addwhere("id = 'CURRENTID' OR date_end = '0000-00-00'");
     $structure = form_helper_prepare_dropdownfromobj("customerid", $sql_struct_obj);
     //		$structure = form_helper_prepare_dropdownfromdb("customerid", "SELECT id, code_customer as label, name_customer as label1 FROM customers ORDER BY name_customer");
     $structure["options"]["req"] = "yes";
     $structure["options"]["width"] = "600";
     $this->obj_form->add_input($structure);
     if ($this->groupid) {
         $structure = NULL;
         $structure["fieldname"] = "code_invoice";
         $structure["type"] = "text";
         $this->obj_form->add_input($structure);
     }
     $structure = NULL;
     $structure["fieldname"] = "description";
     $structure["type"] = "textarea";
     $structure["options"]["width"] = "600";
     $structure["options"]["height"] = "60";
     $this->obj_form->add_input($structure);
     // hidden values
     $structure = NULL;
     $structure["fieldname"] = "projectid";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->id;
     $this->obj_form->add_input($structure);
     $structure = null;
     $structure["fieldname"] = "groupid";
     $structure["type"] = "hidden";
     $structure["defaultvalue"] = $this->groupid;
     $this->obj_form->add_input($structure);
     /*
     	Define checkboxes for all unassigned time entries
     */
     $this->obj_sql_entries = new sql_query();
     $this->obj_sql_entries->prepare_sql_settable("timereg");
     $this->obj_sql_entries->prepare_sql_addfield("id", "timereg.id");
     $this->obj_sql_entries->prepare_sql_addfield("date", "timereg.date");
     $this->obj_sql_entries->prepare_sql_addfield("name_phase", "project_phases.name_phase");
     $this->obj_sql_entries->prepare_sql_addfield("name_staff", "CONCAT_WS(' -- ', staff.staff_code, staff.name_staff)");
     $this->obj_sql_entries->prepare_sql_addfield("description", "timereg.description");
     $this->obj_sql_entries->prepare_sql_addfield("time_booked", "timereg.time_booked");
     $this->obj_sql_entries->prepare_sql_addfield("groupid", "timereg.groupid");
     $this->obj_sql_entries->prepare_sql_addfield("billable", "timereg.billable");
     $this->obj_sql_entries->prepare_sql_addjoin("LEFT JOIN staff ON timereg.employeeid = staff.id");
     $this->obj_sql_entries->prepare_sql_addjoin("LEFT JOIN project_phases ON timereg.phaseid = project_phases.id");
     $this->obj_sql_entries->prepare_sql_addwhere("project_phases.projectid='" . $this->id . "'");
     if ($this->groupid) {
         $this->obj_sql_entries->prepare_sql_addwhere("(groupid='" . $this->groupid . "' OR !groupid)");
     } else {
         $this->obj_sql_entries->prepare_sql_addwhere("!groupid");
     }
     if ($this->access_staff_ids) {
         $this->obj_sql_entries->prepare_sql_addwhere("timereg.employeeid IN (" . format_arraytocommastring($this->access_staff_ids) . ")");
     }
     $this->obj_sql_entries->generate_sql();
     $this->obj_sql_entries->execute();
     if ($this->obj_sql_entries->num_rows()) {
         $this->obj_sql_entries->fetch_array();
         foreach ($this->obj_sql_entries->data as $data) {
             // define the billable check box
             $structure = NULL;
             $structure["fieldname"] = "time_" . $data["id"] . "_bill";
             $structure["type"] = "checkbox";
             $structure["options"]["label"] = " ";
             if ($data["groupid"] == $this->groupid && $data["billable"] == "1") {
                 $structure["defaultvalue"] = "on";
             }
             $this->obj_form->add_input($structure);
             // define the nobill check box
             $structure = NULL;
             $structure["fieldname"] = "time_" . $data["id"] . "_nobill";
             $structure["type"] = "checkbox";
             $structure["options"]["label"] = " ";
             if ($data["groupid"] == $this->groupid && $data["billable"] == "0") {
                 $structure["defaultvalue"] = "on";
             }
             $this->obj_form->add_input($structure);
         }
//.........这里部分代码省略.........