function set_total_controls($sql) { /*ตรวจสอบสร้างคำสั่ง SQL เพื่อสร้างยอดรวม*/ debug_mode(__FILE__, __LINE__, $sql, 'set_total_controls : $sql'); $sql_cmd = new OrSql(); // สร้างใหม่เพื่อไม่ให้กระทบค่าเดิม $sql_cmd->set_cmd_sql($sql); if (is_array($this->total_function)) { $db = $this->db; $i = 0; foreach ($this->total_function as $id => $obj) { $field_name = $this->get_filter_name($obj->field_name); if (strpos($field_name, "`") === false and strpos($field_name, "(") === false) { $field_name = '`' . $field_name . '`'; } if ($i == 0) { $str_select = $obj->field_function . '(' . $field_name . ') AS `' . $id . '` '; } else { $str_select .= ' , ' . $obj->field_function . '(' . $field_name . ') AS `' . $id . '` '; } $i++; } } if ($str_select != '' and $this->OP_['tab_select_total']->get() != '') { $str_comma = ' , '; } if ($str_select != '' or $this->OP_['tab_select_total']->get() != '') { $sql_cmd->OP_[cmd_select]->set($str_select . $str_comma . $this->OP_['tab_select_total']->get()); $sql_cmd->OP_[cmd_group]->set(''); debug_mode(__FILE__, __LINE__, $sql_cmd->get_cmd_sql(), 'set_total_controls : $sql_cmd'); $db->get_query($sql_cmd->get_cmd_sql()); if ($this->db->is_error()) { die("gen_total_list_tag had error = " . $db->show_error()); } $db->get_record(); } /** * สร้าง Controls ค่าผลรวม **/ foreach ($this->total_controls as $control_id => $control) { $control->OP_[value]->set($db->record[$control_id]); debug_mode(__FILE__, __LINE__, $control->OP_[value]->get(), 'ผลของ' . $control_id); } return null; }
function get_total_row($sql_count_row) { $db_page = $this->db; $sql_cmd = new OrSql(); $sql_cmd->set_cmd_sql($sql_count_row); $sql_cmd->OP_[cmd_select]->set(' count(*) AS `total_row` '); $count_sql = $sql_cmd->get_cmd_sql(); $db_page->get_query($count_sql); if (!$db_page->is_error()) { $db_page->get_record(); $this->OP_[total_rec]->set($db_page->record[total_row]); } else { $db_page->show_error(); } return $this->OP_[total_rec]->get(); }