1,
];
public $pageTitle = " Calendar "; //page Title
public $user_id;
public $period_type;
public $employee_name;
public $username;
public $first_name;
public $last_name;
public function _before_save() {
try {
$this->_do_before_save();
return 10;
} catch (Exception $e) {
echo "Exception
" . $e->getMessage();
return -90;
}
}
public static function convt_number_time($i, $is_pm = false) {
$td_time = '';
if ($i < 20) {
$td_time .= ($is_pm) ? '0' . 12 + (int) ($i / 2) : '0' . (int) ($i / 2);
$td_time .= ($i % 2 == 0 ) ? ':00' : ':30';
} else {
$td_time .= ($is_pm) ? 12 + (int) ($i / 2) : (int) ($i / 2) ;
$td_time .= ($i % 2 == 0 ) ? ':00' : ':30';
}
return $td_time;
}
private function _do_before_save() {
global $dbc;
// pa($_POST);
if (empty($_POST['reference_key_name'][0]) || empty($_POST['reference_key_value'][0])) {
throw new Exception("Reference details are not entered.
Error @ " . __FILE__ . ' @@ ' . __LINE__);
}
$this->reference_key_name = $_POST['reference_key_name'][0];
$this->reference_key_value = $_POST['reference_key_value'][0];
$this->reference_type = !empty($_POST['reference_type'][0]) ? $_POST['reference_type'][0] : 'table';
$this->reference_entity = !empty($_POST['reference_entity'][0]) ? $_POST['reference_entity'][0] : null;
foreach ($_POST as $field_name => $field_value_a) {
if (empty($field_value_a[0]) || in_array($field_name, sys_calendar::$common_fields_a)) {
continue;
} else {
$class = qa_ce_header::tableName_from_elementName($field_name);
$key_column = $class . '_id';
$value_column = $class . '_value';
// $$class = new stdClass();
$extra_fields = extn_view::find_columns_of_table($class);
// pa($extra_fields);
$checkSql = " SELECT * FROM $class WHERE reference_type = 'table' AND reference_key_name= :reference_key_name "
. " AND reference_key_value= :reference_key_value ";
$sql = ino_perPageSql_i($sql, 1);
global $db;
$value_a = ['reference_key_value' => $this->reference_key_value, 'reference_key_name' => $this->reference_key_name];
$checkResult = $db->findBySql($checkSql, $value_a);
//if $checkResult is not empty update the existing data else create record
if (!empty($checkResult)) {
$key_column_value = $checkResult[0]->$key_column;
if (empty($_POST['file_id_values'][0]) && ($checkResult[0]->$value_column == $_POST[$field_name][0])) {
continue;
} else if (!empty($_POST['file_id_values'][0]) && ($checkResult[0]->$value_column == $_POST['file_id_values'][0])) {
continue;
}
//Update the existing content
$field_stmt = '';
$field_stmt .= " $value_column = :$value_column ,";
$field_stmt .= ' last_update_date = :last_update_date ,';
$field_stmt .= ' last_update_by = :last_update_by ';
//write SQL
$sql = " UPDATE ";
$sql.= $class;
$sql .= " SET ";
$sql.= $field_stmt;
$sql.= " WHERE $key_column = '{$key_column_value}' ";
$stmt = $dbc->connection->prepare(" $sql ");
//Bind parameters
if (empty($_POST['file_id_values'][0])) {
$stmt->bindParam(":$value_column", $_POST[$field_name][0]);
} else {
$stmt->bindParam(":$value_column", $_POST['file_id_values'][0]);
}
$stmt->bindvalue(':last_update_date', current_time(), PDO::PARAM_INT);
$stmt->bindvalue(':last_update_by', $_SESSION['username'], PDO::PARAM_INT);
try {
$stmt->execute();
echo "
Record is Successfully Saved in $class";
} catch (PDOException $e) {
$dbc->rollback = 1;
echo "
$sql
";
echo "
Record couldnt be saved. Error @ " . __FILE__ . ' @@ ' . __LINE__ . $e->getMessage() . "
";
}
} else {
$field_columns = '';
foreach ($extra_fields as $key => $value) {
$field_columns .= $value . ', ';
}
$field_columns_2 = rtrim($field_columns, ', ');
$field_values = '';
foreach ($extra_fields as $key1 => $value1) {
$field_values .= ':' . $value1 . ', ';
}
$field_values_2 = rtrim($field_values, ', ');
//write SQL
$sql = " INSERT INTO ";
$sql.= $class;
$sql.= ' ( ';
$sql.= $field_columns_2;
$sql.= ' ) ';
$sql.= 'VALUES';
$sql.= ' ( ';
$sql.= $field_values_2;
$sql.= ' ) ';
// print_r($_POST);
$stmt = $dbc->connection->prepare(" $sql ");
//Bind parameters
foreach ($extra_fields as $key => $value) {
if (!empty($_POST[$value][0])) {
$stmt->bindParam(":$value", $_POST[$value][0]);
} else {
$stmt->bindvalue(":$value", null, PDO::PARAM_INT);
}
}
$stmt->bindvalue(':reference_type', 'table', PDO::PARAM_INT);
$stmt->bindvalue(':reference_key_name', $this->reference_key_name, PDO::PARAM_INT);
$stmt->bindParam(':reference_key_value', $this->reference_key_value);
$stmt->bindParam(':reference_entity', $this->reference_entity);
$stmt->bindParam(':reference_type', $this->reference_type);
if (empty($_POST['file_id_values'][0])) {
$stmt->bindParam(":$value_column", $_POST[$field_name][0]);
} else {
$stmt->bindParam(":$value_column", $_POST['file_id_values'][0]);
}
$stmt->bindvalue(':creation_date', current_time(), PDO::PARAM_INT);
$stmt->bindvalue(':created_by', $_SESSION['username'], PDO::PARAM_INT);
$stmt->bindvalue(':last_update_date', current_time(), PDO::PARAM_INT);
$stmt->bindvalue(':last_update_by', $_SESSION['username'], PDO::PARAM_INT);
try {
$stmt->execute();
// $$class->content_id = $dbc->connection->lastInsertId();
echo "
Record is Successfully Saved in $class";
} catch (PDOException $e) {
$dbc->rollback = 1;
echo "
Record couldnt be saved. Error @ " . __FILE__ . ' @@ ' . __LINE__ . $e->getMessage() . "
";
}
}
}
}
}
public static function find_by_fieldName_referenceDetails($field_name, $ref_key, $ref_value) {
$table_i = qa_ce_header::tableName_from_elementName($field_name);
$sql = " SELECT * FROM ";
$sql .= $table_i;
$sql .= " WHERE reference_key_name = :reference_key_name AND reference_key_value=:reference_key_value ";
$sql = ino_perPageSql_i($sql, 1);
global $db;
$value_a = ['reference_key_name' => $ref_key, 'reference_key_value' => $ref_value];
$result = $db->findBySql($sql, $value_a);
return !empty($result) ? array_pop($result) : false;
}
private $_search_sql;
private $_search_count;
public function search_records($parameters) {
$pageno = !empty($parameters['pageno']) ? $parameters['pageno'] : 1;
$per_page = !empty($parameters['per_page']) ? $parameters['per_page'] : 10;
$sql = $this->_search_sql($parameters);
if ((!empty($search_order_by)) && (!empty($search_asc_desc))) {
if (is_array($search_order_by)) {
$order_by = ' ORDER BY ';
foreach ($search_order_by as $key_oby => $value_oby) {
if (empty($search_asc_desc[$key_oby])) {
$search_asc_desc[$key_oby] = ' DESC ';
}
$order_by .= $value_oby . ' ' . $search_asc_desc[$key_oby] . ' ,';
}
$order_by_i = rtrim($order_by, ',');
} else {
$order_by_i = ' ORDER BY ' . $search_order_by . ' ' . $search_asc_desc;
}
}
global $db;
$s_result = $db->findBySql($this->_search_sql);
$this->_search_count = count($s_result);
return !empty($s_result) ? $s_result : false;
}
private function _search_sql($parameters) {
$reference_key_value = !(empty($_GET['reference_key_value'])) ? $_GET['reference_key_value'][0] : '';
$reference_key_name = !(empty($_GET['reference_key_name'])) ? $_GET['reference_key_name'][0] : '';
$table_sql = " SELECT TABLE_NAME from
information_schema.tables
where TABLE_TYPE ='BASE TABLE'
AND table_name LIKE 'qa_ce%' ";
global $db;
$all_tables = $db->findBySql($table_sql);
if (empty($all_tables)) {
return new stdClass();
}
$sql = "";
$all_tables_ai = new ArrayIterator($all_tables);
while ($all_tables_ai->valid()) {
$table_name = $all_tables_ai->current();
$sql .= " SELECT * FROM $table_name->table_name ";
if (!empty($reference_key_name)) {
$sql .= " WHERE reference_key_name = '{$reference_key_name}' ";
}
if (!empty($reference_key_name) && !empty($reference_key_value)) {
$sql .= " AND reference_key_value = '{$reference_key_value}' ";
} else if (!empty($reference_key_value)) {
$sql .= " WHERE reference_key_value = '{$reference_key_value}' ";
}
$all_tables_ai->next();
if ($all_tables_ai->valid()) {
$sql .= " UNION ";
}
}
$this->_search_sql = $sql;
return $sql;
}
public function search_counts() {
return !empty($this->_search_count) ? $this->_search_count : null;
}
public function search_downloads() {
global $db;
return !empty($this->_search_sql) ?$db->findBySql($this->_search_sql) : null;
}
}
?>