Exemple #1
0
 function get_body_tag()
 {
     $my_table = new OrTable('db_' . $this->OP_[id]->get());
     $my_table->OP_[align_table]->set('center');
     $my_table->OP_[class_name]->set('tbl_body');
     $my_col = 0;
     $control_count = 0;
     $form_col = $this->OP_[column]->get();
     /**
      * หาจำนวนช่องข้อมูลทั้งหมด เพื่อใช้กำหนด Column Row ให้ถูกต้อง
      */
     foreach ($this->controls as $id => $control) {
         if ($control->OP_[auto_visible]->get()) {
             $control_count++;
         }
     }
     $my_row = ceil($control_count / $form_col);
     foreach ($this->controls as $id => $control) {
         if ($control->OP_[auto_visible]->get()) {
             if ($control->OP_[type]->get() != 'hidden' and $control->OP_[id]->get() != 'sec_user') {
                 $my_col++;
                 $control_count--;
                 $my_table->set_col($control->OP_[caption]->get(), "td_caption");
                 $this->set_class_name($id);
                 if ($my_row == 1 && $control_count == 1) {
                     $colspan = $form_col * 2 - $my_col;
                     $my_table->set_join_cells($control->get_tag() . $control->OP_[description]->get(), $colspan, 0, "td_data");
                 } else {
                     $my_table->set_col($control->get_tag() . $control->OP_[description]->get(), "td_data");
                 }
                 if ($my_col >= $form_col) {
                     $my_table->set_row('tr_body');
                     $my_row--;
                     $my_col = 0;
                 }
             }
         }
     }
     /** ตรวจสอบจำนวน column ว่าครบหรือไม่ เพื่อแก้ไขปัญหา ไม่โชว์บรรทัดสุดท้าย* */
     if ($my_col > 0) {
         $my_table->set_row('tr_body');
         $my_col = 0;
     }
     return $my_table->get_tag();
 }
 function get_form_query()
 {
     $my_table = new OrTable('table_query');
     $my_table->OP_[align_table]->set('center');
     $my_table->OP_[class_name]->set('tbl_query_body');
     $my_table->set_col($this->get_button_filter());
     $my_table->set_col('เงื่อนไข ');
     $my_table->set_col(' ค่าที่ค้นหา ');
     $my_table->set_row();
     foreach ($this->caption_fields as $caption => $id) {
         if (!is_object($this->filter_controls[$id])) {
             $this->set_filter_controls(new OrTextbox($id));
         }
         $my_compare = new OrSelectbox('val_compare_' . $id . '_', 'val_compare[' . $id . ']');
         $my_compare->OP_[option]->set(array('=' => '=', '<>' => '<>', '>=' => '>=', '<=' => '<=', 'BETWEEN' => 'BETWEEN', 'LIKE' => 'LIKE', 'IN' => 'IN'));
         $my_compare->OP_[default_value]->set($this->get_filter_compare($id));
         //สร้าง Function เพื่อค้นหาค่า Default compare
         $my_compare->OP_[auto_post]->set(true);
         //$my_table->set_col($my_control->OP_[caption]->get() , "td_caption");
         debug_mode(__FILE__, __LINE__, $this->filter_controls[$id]->OP_[caption]->get(), 'Filter_controls');
         $my_table->set_col($this->filter_controls[$id]->OP_[caption]->get(), "td_query_caption");
         $my_table->set_col($my_compare->get_tag(), "td_query_compare");
         $my_table->set_col($this->filter_controls[$id]->get_tag(), "td_query_value");
         $my_table->set_row('tr_query_body');
     }
     $my_table->set_col('ค้นคำ เรียงลำดับ');
     $my_table->set_col($this->get_control_filter());
     $my_table->set_col($this->get_control_order());
     $my_table->set_row();
     return $my_table->get_tag();
 }