/**
* last_note : แสดงประกาศล่าสุด
* @param null
* @return null
*/
function last_note()
{
global $SCRIPT_FILENAME, $REMOTE_ADDR, $my_cfg_sec;
$my_db = new OrMysql($my_cfg_sec[db]);
//(กำหนด Object ฐานข้อมูลที่จะใช้)
//$sql = "SELECT `detail` FROM `my_note` WHERE `sec_time` = '" . $val_->message[content_key_value] . "'"; //(กำหนด SQL ตามเงื่อนไขที่ต้องการ)
$my_skin = new OrSkin('my_note.html');
//ตรวจสอบเวลาที่ได้อ่านประกาศล่าสุดจาก my_registration
$sql = "SELECT * FROM `my_registration` WHERE `sec_ip` = '" . $REMOTE_ADDR . "'";
$my_db->get_query($sql);
if ($my_db->get_record()) {
$my_accept_note = $my_db->record[accept_note];
} else {
$my_accept_note = 0;
}
//อ่านประกาศล่าสุด และที่คาดว่าไม่ได้อ่าน
$sql = "SELECT * FROM `my_note` WHERE `sec_time` >= '" . $my_accept_note . "' ORDER BY `sec_time` DESC LIMIT 10";
$my_db->get_query($sql);
$i = 0;
$my_skin->set_skin_tag('id', '');
$my_skin->set_skin_tag('detail', 'ประกาศใหม่ๆ ยังไม่มีนะคะ');
while ($my_db->get_record()) {
$my_detail = $my_db->record[detail];
$my_detail .= 'วันเวลาที่บันทึก : ' . $my_db->record[sec_time] . '<br>';
if ($i == 0) {
$my_skin->set_skin_tag('id', $my_db->record[id]);
$my_skin->set_skin_tag('detail', $my_detail);
} else {
$my_remain .= '<hr>' . $my_detail;
}
$i++;
}
$my_skin->set_skin_tag('remain', $my_remain);
unset($my_db);
$this->set_body($my_skin->get_tag());
return NULL;
}
function get_navigator_tag($skin_file = 'Or!Lib/db/list_navigator.html')
{
/*รับค่า Skin ของชุดปุ่่ม*/
$my_value = new OrSkin($skin_file);
$go_page = new OrTextbox('evt_form_db[go_page]');
$go_page->set_size(3, 5);
$go_page->OP_[value]->set($this->OP_[go_page]->get());
$chg_row = new OrTextbox('evt_form_db[chg_row]');
$chg_row->set_size(3);
$chg_row->OP_[default_value]->set($this->OP_[row_per_page]->get());
$cur_page = new OrFieldHidden('evt_form_db[cur_page]');
$cur_page->OP_[value]->set($this->OP_[go_page]->get());
$total_page = new OrFieldHidden("evt_form_db[total_page]");
$total_page->OP_[value]->set($this->OP_[total_page]->get());
$row_page = new OrFieldHidden("evt_form_db[row_page]");
$row_page->OP_[default_value]->set($this->OP_[row_per_page]->get());
$total_row = new OrFieldHidden("evt_form_db[total_row]");
$total_row->OP_[value]->set($this->OP_[total_row]->get());
$hidden_tag = $cur_page->get_tag() . $total_page->get_tag() . $total_row->get_tag() . $row_page->get_tag();
$my_value->set_skin_tag('go_page', $go_page->get_tag());
//$my_value->set_skin_tag('chg_row' , $chg_row->get_tag() . ' รายการ จาก ' . $total_row->get_tag() . ' รายการ');
$my_value->set_skin_tag('chg_row', ' Of ' . $this->OP_[total_page]->get() . ' Pages Show ' . $chg_row->get_tag() . ' Rows ');
$my_value->set_skin_tag('description', 'Total ' . $this->OP_[total_row]->get() . ' Rows');
//$my_value->set_skin_tag('description' , $total_page->get_tag() . " หน้า " );
/*
$txt_cmd_filter=new field_hidden("txt_cmd_filter","evt_list_navigator[cmd_filter]");
$txt_cmd_order=new field_hidden("txt_cmd_order","evt_list_navigator[cmd_order]");
$txt_cmd_msg=new field_hidden("txt_cmd_msg","evt_list_navigator[cmd_msg]");
*/
$my_value->set_skin_tag('field_hidden', $hidden_tag);
return $my_value->get_tag();
}
/**
* set_footer : กำหนด Footer
* @param string $tag ข้อความส่วน Footer
* @return null
*/
function set_footer($tag)
{
global $my_cfg;
$skin_footer = new OrSkin($my_cfg[skins_path] . "my_footer.html");
$skin_footer->set_skin_tag('my_footer', $tag);
$this->skin->set_skin_tag('my_footer', $skin_footer->get_tag());
return null;
}
function get_navigator_tag($skin_file = 'Or!Lib/db/form_navigator.html')
{
/* รับค่า Skin ของชุดปุ่่ม */
$my_value = new OrSkin($skin_file);
$cur_rec = new OrFieldHidden('evt_form_db[cur_rec]');
$cur_rec->OP_[value]->set($this->OP_[cur_rec]->get());
$total_rec = new OrFieldHidden("evt_form_db[total_rec]");
$total_rec->OP_[value]->set($this->OP_[total_rec]->get());
$btn_record = new OrButton("btn_record", "evt_form_db[navigator]");
if ($this->OP_[cur_rec]->get() == 0) {
$btn_record->OP_[value]->set('Add');
} else {
$btn_record->OP_[value]->set('Save');
}
$my_value->set_skin_tag('btn_record', $btn_record->get_tag());
$my_value->set_skin_tag('cur_rec', $cur_rec->get_tag());
$my_value->set_skin_tag('total_rec', $total_rec->get_tag());
$my_value->set_skin_tag('description', $this->OP_[cur_rec]->get() . ' of ' . $this->OP_[total_rec]->get());
return $my_value->get_tag();
}
