function get_table($paged = 0)
{
/* Execute a prepared statement by passing an array of values */
$dbh = new PDO('mysql:dbname=' . AppConfig::gacv("AC_db") . ';host=' . AppConfig::gacv("AC_server"), AppConfig::gacv("AC_user"), AppConfig::gacv("AC_pass"));
$sql = sprintf("select * from %s WHERE " . $this->lookup_tbl_id_col . " = :lookup_tbl_id_col OR 1 = :lookup_not_set order by %s", $this->tbl_name, $this->lookup_value_col);
if ($paged) {
$sql .= MyEDB_Pager::get_sql_limit_clause();
}
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));
//
//$sth->execute(array(':lookup_tbl_id_col' => ($_REQUEST[$this->lookup_tbl_id_col])? $_REQUEST[$this->lookup_tbl_id_col] : $this->lookup_tbl_id_col));
$sth->bindParam(':lookup_tbl_id_col', $lookup_tbl_id_col);
$sth->bindParam(':lookup_not_set', $lookup_not_set);
$lookup_tbl_id_col = $_REQUEST[$this->lookup_tbl_id_col];
$lookup_not_set = $_REQUEST[$this->lookup_tbl_id_col] ? 0 : 1;
$sth->execute();
$res = $sth->fetchAll(PDO::FETCH_BOTH);
//echo $sql.$this->lookup_tbl_id_col;//
$table_hash = array();
//print_r($res);
foreach ($res as $ar) {
//echo $sql."-".$lookup_tbl_id_col." ".$lookup_not_set;
$table_hash[$ar[0]] = array($ar[1], "lookup_table_id" => $ar[$this->lookup_tbl_id_col], "disabled" => $ar['disabled']);
}
return $table_hash;
}
function create_order_history_page_xml()
{
$myedbsess = new MyEDB_SESSION();
$obj_DS = "";
if ($_REQUEST['type_id'])
{
$table = "medb_order natural
join medb_order_eiddst
left join view_varchar_prop_to_e_p_to_e act on
(act.eid = medb_order_eiddst.eiddst and act.prop_id = 33)
left join view_varchar_prop_to_e_p_to_e ref on
(ref.eid = medb_order_eiddst.eiddst and ref.prop_id = 57) ";
if (!is_numeric($_REQUEST['type_id'])) die ("type_id must be int! Security alert!");
$where_clause = "WHERE submitted = 1 AND (medb_order_eiddst.type_id = {$_REQUEST['type_id']})";
$obj_DS = "travel_order_DS";
}
else
{
/* $table = "medb_order natural
left join medb_order_eiddst
left join view_varchar_prop_to_e_p_to_e act on
(act.eid = medb_order_eiddst.eiddst and act.prop_id = 33)
left join view_varchar_prop_to_e_p_to_e ref on
(ref.eid = medb_order_eiddst.eiddst and ref.prop_id = 57) ";
$where_clause = "WHERE submitted = 1 AND (medb_order_eiddst.type_id <> 4 or
medb_order_eiddst.type_id is null)";*/ //travel type = 4
$table = "order_history_cache";
$where_clause = "";
$obj_DS = "medb_order_DS";
}
if (isset($_REQUEST['eid']))
{
$where_clause .= " AND medb_order_eiddst.eiddst = ".sanitize($_REQUEST['eid']);
}
$limit_clause = MyEDB_Pager::get_sql_limit_clause();
//$table = "medb_order natural left join medb_order_eiddst";
$select_fields = "medb_order.*,act.varchar_val as acct_no, ref.varchar_val as ref_no, medb_order_eiddst.eiddst ";
$order_ds = new $obj_DS($table, $select_fields);
// $order_ds->select_clause = "SELECT DISTINCT";
$order_ds->distinct_field = "order_id";
$order_ds->where_clause = $where_clause;
$order_ds->limit_clause = $limit_clause;
$order_ds->limit_offset = MyEDB_Pager::get_sql_limit_offset();
$order_ds->limit_rows = MyEDB_Pager::get_sql_limit_rows();
$order_by = sanitize($_REQUEST["o"]);
$order_direction = sanitize($_REQUEST['od']);
$order_ds->order_by_field = $order_by;
$order_ds->order_by_direction = $order_direction;
$order_by_clause = "order by $order_by $order_direction";
$order_ds->order_by = $order_by_clause;
//$_SESSION['search_res_row_cnt'] = $order_ds->get_total_recs_count(); //echo "recs count".$order_ds->get_total_recs_count()."--";
$myedbsess->search_res_row_cnt = $order_ds->get_total_recs_count();
$encap_element = "medb_order_elem";
return $order_ds->get_order_history_xml_dataset($encap_element);
}
function apply_page_filter($eids)
{
//echo "<br>RecordSearcher: in apply_page_filter func";
$res = MyEDB_Pager::apply_page_filter($eids);
// echo "<br>RecordSearcher: after calling Myedb pager apply_page_filter, result:".$res;
return $res;
}
