public function default_select() { // pZ: parent::default_select(); $this->db->select('SQL_CALC_FOUND_ROWS *, (CASE WHEN DATEDIFF(NOW(), task_finish_date) > 0 THEN 1 ELSE 0 END) is_overdue ', FALSE); }
public function default_select() { // pZ: parent::default_select(); $this->db->select('SQL_CALC_FOUND_ROWS *', FALSE); }
public function default_select() { // pZ: parent::default_select(); $this->db->select("SQL_CALC_FOUND_ROWS\n ip_users.user_name,\n\t\t\tip_users.user_company,\n\t\t\tip_users.user_address_1,\n\t\t\tip_users.user_address_2,\n\t\t\tip_users.user_city,\n\t\t\tip_users.user_state,\n\t\t\tip_users.user_zip,\n\t\t\tip_users.user_country,\n\t\t\tip_users.user_phone,\n\t\t\tip_users.user_fax,\n\t\t\tip_users.user_mobile,\n\t\t\tip_users.user_email,\n\t\t\tip_users.user_web,\n\t\t\tip_users.user_vat_id,\n\t\t\tip_users.user_tax_code,\n\t\t\tip_clients.*,\n\t\t\tip_quote_amounts.quote_amount_id,\n\t\t\tIFNULL(ip_quote_amounts.quote_item_subtotal, '0.00') AS quote_item_subtotal,\n\t\t\tIFNULL(ip_quote_amounts.quote_item_tax_total, '0.00') AS quote_item_tax_total,\n\t\t\tIFNULL(ip_quote_amounts.quote_tax_total, '0.00') AS quote_tax_total,\n\t\t\tIFNULL(ip_quote_amounts.quote_total, '0.00') AS quote_total,\n ip_invoices.invoice_number,\n\t\t\tip_quotes.*", FALSE); }
public function default_select() { // pZ: parent::default_select(); $this->db->select("SQL_CALC_FOUND_ROWS\n ip_users.user_name,\n\t\t\tip_users.user_company,\n\t\t\tip_users.user_address_1,\n\t\t\tip_users.user_address_2,\n\t\t\tip_users.user_city,\n\t\t\tip_users.user_state,\n\t\t\tip_users.user_zip,\n\t\t\tip_users.user_country,\n\t\t\tip_users.user_phone,\n\t\t\tip_users.user_fax,\n\t\t\tip_users.user_mobile,\n\t\t\tip_users.user_email,\n\t\t\tip_users.user_web,\n\t\t\tip_users.user_vat_id,\n\t\t\tip_users.user_tax_code,\n\t\t\tip_clients.*,\n\t\t\tip_invoice_amounts.invoice_amount_id,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_item_subtotal, '0.00') AS invoice_item_subtotal,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_item_tax_total, '0.00') AS invoice_item_tax_total,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_tax_total, '0.00') AS invoice_tax_total,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_total, '0.00') AS invoice_total,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_paid, '0.00') AS invoice_paid,\n\t\t\tIFNULL(ip_invoice_amounts.invoice_balance, '0.00') AS invoice_balance,\n\t\t\tip_invoice_amounts.invoice_sign AS invoice_sign,\n (CASE WHEN ip_invoices.invoice_status_id NOT IN (1,4) AND DATEDIFF(NOW(), invoice_date_due) > 0 THEN 1 ELSE 0 END) is_overdue,\n\t\t\tDATEDIFF(NOW(), invoice_date_due) AS days_overdue,\n (CASE (SELECT COUNT(*) FROM ip_invoices_recurring WHERE ip_invoices_recurring.invoice_id = ip_invoices.invoice_id and ip_invoices_recurring.recur_next_date <> '0000-00-00') WHEN 0 THEN 0 ELSE 1 END) AS invoice_is_recurring,\n\t\t\tip_invoices.*", FALSE); }
public function default_select() { // pZ: parent::default_select(); $this->db->select("SQL_CALC_FOUND_ROWS\n ip_payment_methods.*,\n ip_invoice_amounts.*,\n ip_clients.client_name,\n \tip_clients.client_id,\n ip_invoices.invoice_number,\n ip_invoices.invoice_date_created,\n ip_payments.*", FALSE); }