function get_format($value) { $val = array(); switch ($this->OP_[type]->get()) { case "currency": $this->OP_[value]->set(number_format($value, $this->OP_[option]->get())); break; case "th_date": if ($value > 0) { if ($this->OP_[option]->get() == "as400") { $val["th_year"] = substr($value, 0, 4); $val["mon"] = substr($value, 4, 2); $val["mday"] = substr($value, 6, 2); $this->OP_[value]->set($val["mday"] . "/" . $val["mon"] . "/" . $val["th_year"]); } else { if ($this->OP_[option]->get() == "mysql") { $my_date = new OrMySqlThDate($value); $this->OP_[value]->set($my_date->get_th_str()); } else { if ($this->OP_[option]->get() == "mysql_t") { $my_date = new OrMySqlThDatetime($value); $this->OP_[value]->set($my_date->get_th_str()); } else { die('กรุณาระบุประเภท[ as400 | mysql | mysql_t ' . $this->OP_[type]->get() . ' กรุณาตรวจสอบคำสั่ง'); } } } } else { /*กรณีไม่มีข้อมูลให้แสดงเป็น "-" สุชาติ 8/9/2548*/ $this->OP_[value]->set("-"); } break; case "hn": if ($value > 100) { $hn = $value / 100; $hn = sprintf("%.2f", $hn); $value = str_replace('.', '-', $hn); $this->OP_[value]->set($value); } break; default: $this->OP_[value]->set(sprintf($this->OP_[type]->get(), $value)); } return $this->OP_[value]->get(); }
function get_tag($value = null) { $str_date = new OrMySqlThDate(); /** * Checking $vaule */ if ($value != null) { $this->OP_[value]->set($value); } /** * Checking auto_post property */ if ($this->OP_[auto_post]->get()) { $this->auto_post(); } $id = $this->get_id_tag(); $value = $str_date->get_th_str($this->OP_[value]->get()); //echo "<b>debug</b> ".__FILE__." | ".__LINE__." | value =".$value."<br>"; if ($value == null) { $value = $this->OP_[post_value]->get(); } if ($value == null) { $value = $str_date->get_th_str($this->OP_[default_value]->get()); } if ($this->OP_[class_name]->get() == null) { $class = null; } else { $class = 'class="' . $this->OP_[class_name]->get() . '"'; } $this->clip_value($str_date->get_mysql_str($value)); $type = 'type = "text"'; $value = 'value="' . $value . '"'; $title = 'title="' . $this->OP_[title]->get() . '"'; $this_id = $this->OP_[id]->get(); $this_format = 'dd/mm/bbbb'; //$my_value = '<input type="text" name="theDate" readonly="" value="2004/02/02"/>'; $my_value = "<input {$id} {$class} {$type} {$value} {$title} maxlength=\"10\" size=\"10\" >" . $this->get_properties_tag(); $my_value .= '<button title="ปฏิทิน" value="Cal" class="toolbar" type="button" onclick="displayCalendar(document.forms[0].' . $this_id . ',\'' . $this_format . '\',this)" ><img src="../../lib/calendar/image/calendar.png"/></button>'; //$my_value .= '<input type="button" onclick="displayCalendar(document.forms[0].' . $this_id . ',\'' . $this_format . '\',this)" value="Cal">'; return $my_value; }
function get_filter_value($value) { if (!is_numeric($value)) { /*ตรวจสอบการเป็นข้อมูลวันที่เวลาไทยหรือไม่*/ $mysql_th_datetime = new OrMySqlThDatetime($value); if ($mysql_th_datetime->is_datetime) { return $mysql_th_datetime->get_mysql_str(); } else { $mysql_th_date = new OrMySqlThDate($value); if ($mysql_th_date->is_date) { return $mysql_th_date->get_mysql_str(); } else { return AddSlashes($value); } } } else { return AddSlashes($value); // แก้ไขกรณีบันทึกเลข ทศนิยม สุชาติ บุญหชัยรัตน์ 14/10/2547 } }
function get_sql_value($id) { /* เช็คประเภทของข้อมูล */ if (!is_numeric($this->val_controls[db_field][$id])) { /* ตรวจสอบการเป็นข้อมูลวันที่เวลาไทยหรือไม่ */ $mysql_th_datetime = new OrMySqlThDatetime($this->val_controls[db_field][$id]); if ($mysql_th_datetime->is_datetime) { return "'" . $mysql_th_datetime->get_mysql_str() . "'"; } else { $mysql_th_date = new OrMySqlThDate($this->val_controls[db_field][$id]); if ($mysql_th_date->is_date) { return "'" . $mysql_th_date->get_mysql_str() . "'"; } else { return "'" . AddSlashes($this->val_controls[db_field][$id]) . "'"; } } } else { return "'" . AddSlashes($this->val_controls[db_field][$id]) . "'"; // แก้ไขกรณีบันทึกเลข ทศนิยม สุชาติ บุญหชัยรัตน์ 14/10/2547 } //return null; }