public function logoutInactiveUsers()
{
$now = time();
$foo = $now - $_SESSION['inactive']['time'];
$users = array();
$this->db->setSQL("SELECT id, uid FROM users_sessions WHERE last_request < {$foo} AND logout IS NULL");
foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $user) {
$id = $user['id'];
$users[] = array('uid' => $user['uid']);
$this->db->setSQL("UPDATE users_sessions SET logout = '{$now}' WHERE id = '{$id}'");
$this->db->execOnly();
}
return $users;
}
public function getTemplatesTypes()
{
$this->db->setSQL("SELECT DISTINCT title, body\n \t FROM documents_templates\n \t WHERE template_type ='documenttemplate'");
$records = $this->db->fetchRecords(PDO::FETCH_ASSOC);
$records[] = array('title' => 'Empty');
return $records;
}
public function getPatientFutureEventsByPid($pid)
{
$date = Time::getLocalTime();
$tomorrow = date('Y-m-d 0000:00:00', strtotime($date . ' + 1 days'));
$this->db->setSQL("SELECT * FROM calendar_events WHERE patient_id = '{$pid}' AND start >= '{$tomorrow}'");
return $this->db->fetchRecords(PDO::FETCH_ASSOC);
}
/**
* Function: getPatientBalanceByPid
*/
public function getPatientBalanceByPid($pid)
{
// Declare all the variables that we are gone to use.
(array) ($balance_total = '');
$this->db->setSQL("SELECT SUM(amount) as balance FROM payment_transactions WHERE payer_id = '{$pid}'");
$balance_total = $this->db->fetchRecord();
return $balance_total['balance'];
}
public function getLabsLiveSearch(stdClass $params)
{
$this->db->setSQL("SELECT id,\n\t\t\t\t\t\t\t\t parent_loinc,\n\t\t\t\t\t\t\t\t loinc_number,\n\t\t\t\t\t\t\t\t loinc_name\n\t\t\t\t\t\t\tFROM labs_panels\n\t\t\t\t\t\t\tWHERE parent_loinc <> loinc_number\n\t\t\t\t\t\t\t AND loinc_name LIKE'{$params->query}%'");
$records = $this->db->fetchRecords(PDO::FETCH_ASSOC);
$total = count($records);
$records = array_slice($records, $params->start, $params->limit);
return array('totals' => $total, 'rows' => $records);
}
public function updatePatientDisclosure(stdClass $params)
{
$data = get_object_vars($params);
unset($data['id']);
$this->db->setSQL($this->db->sqlBind($data, 'patient_disclosures', 'U', array('id' => $params->id)));
$this->db->execLog();
return $params;
}
public function updatePreventiveCareDismissedAlertsByPid(stdClass $params)
{
$data = get_object_vars($params);
unset($data['id'], $data['description']);
$this->db->setSQL($this->db->sqlBind($data, 'preventive_care_inactive_patient', 'U', array('id' => $params->id)));
$this->db->execLog();
return $params;
}
public function updateDocumentsTitle(stdClass $params)
{
$data = get_object_vars($params);
$id = $data['id'];
unset($data['id'], $data['date']);
$this->db->setSQL($this->db->sqlBind($data, 'patient_documents', 'U', array('id' => $id)));
$this->db->execLog();
return $params;
}
public function getMedicationAttributesByCODE($CODE)
{
$this->db->setSQL("\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DST' AND `SAB` = 'MMSL'\n UNION\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DRT' AND `SAB` = 'MMSL'\n UNION\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DDF' AND `SAB` = 'MMSL'\n ");
$foo = array();
foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $fo) {
$foo[$fo['ATN']] = $fo['ATV'];
}
return $foo;
}
/**
* @static
* @return mixed
*/
public static function setGlobals()
{
$conn = new dbHelper();
$conn->setSQL("SELECT gl_name, gl_value FROM globals");
foreach ($conn->execStatement(PDO::FETCH_ASSOC) as $setting) {
$_SESSION['global_settings'][$setting['gl_name']] = $setting['gl_value'];
}
return;
}
public function logEmergency()
{
$data['pid'] = $this->pid;
$data['eid'] = $this->eid;
$data['uid'] = $_SESSION['user']['id'];
$data['date_created'] = Time::getLocalTime();
$this->db->setSQL($this->db->sqlBind($data, 'emergencies', 'I'));
$this->db->execLog();
$this->emergencyId = $this->db->lastInsertId;
}
/**
* @param stdClass $params
* @return stdClass
* NOTES: Update contact address to who?
* Naming: "updatePatientAddress"
*/
public function updateAddress(stdClass $params)
{
$data = get_object_vars($params);
unset($data['id'], $data['fullname'], $data['fulladdress']);
$sql = $this->db->sqlBind($data, "users", "U", "id='" . $params->id . "'");
$this->db->setSQL($sql);
$this->db->execLog();
$params->fullname = Person::fullname($params->fname, $params->mname, $params->lname);
$params->fulladdress = Person::fulladdress($params->street, $params->streetb, $params->city, $params->state, $params->zip);
return $params;
}
/**
* @static
* @return mixed
*/
public static function setGlobals()
{
$conn = new dbHelper();
$conn->setSQL("SELECT gl_name, gl_value FROM globals");
foreach ($conn->fetchRecords(PDO::FETCH_ASSOC) as $setting) {
$_SESSION['global_settings'][$setting['gl_name']] = $setting['gl_value'];
}
$_SESSION['global_settings']['timezone_offset'] = -14400;
$_SESSION['global_settings']['date_time_display_format'] = $_SESSION['global_settings']['date_display_format'] . ' ' . $_SESSION['global_settings']['time_display_format'];
return $_SESSION['site']['path'];
}
public function removeAllowBlank($table)
{
$this->db->setSQL("Select id, options FROM {$table}");
foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) {
$options = json_decode($row['options'], true);
if (isset($options['allowBlank'])) {
unset($options['allowBlank']);
$id = $row['id'];
$data['options'] = json_encode($options);
$this->db->setSQL($this->db->sqlBind($data, $table, 'U', "id='{$id}'"));
$this->db->execOnly();
}
}
}
function getItemsOptions($item_id)
{
$foo = array();
$this->db->setSQL("Select options FROM forms_field_options WHERE field_id = '{$item_id}'");
$options = $this->db->fetchRecord();
$options = json_decode($options['options'], true);
foreach ($options as $option => $value) {
$foo[$option] = $value;
if ($value == 'temp_f' || $value == 'temp_c' || $value == 'weight_lbs' || $value == 'weight_kg' || $value == 'height_cm' || $value == 'height_in' || $value == 'head_circumference_cm' || $value == 'head_circumference_in' || $value == 'waist_circumference_cm' || $value == 'waist_circumference_in') {
$foo['enableKeyEvents'] = true;
}
}
return $foo;
}
private function getGraphCurves($type, $sex)
{
$this->db->setSQL("SELECT * FROM vector_graphs WHERE type = '{$type}' AND sex = '{$sex}'");
$records = array();
foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) {
unset($row['type'], $row['sex'], $row['L'], $row['M'], $row['S']);
foreach ($row as $key => $val) {
if ($val == null) {
unset($row[$key]);
}
}
$records[] = $row;
}
return $records;
}
/**
* @internal param $user_id
* @return array
*/
public function getUserPerms()
{
$this->conn->setSQL("SELECT * FROM acl_user_perms WHERE user_id = '{$this->user_id}' ORDER BY add_date ASC");
$perms = array();
foreach ($this->conn->fetchRecords(PDO::FETCH_ASSOC) as $row) {
$pK = strtolower($row['perm_key']);
if ($pK == '') {
continue;
}
if ($row['value'] == '1') {
$hP = true;
} else {
$hP = false;
}
$perms[$pK] = array('perm' => $pK, 'inheritted' => false, 'value' => $hP, 'Name' => $this->getPermNameByPermKey($row['perm_key']), 'id' => $row['id']);
}
return $perms;
}
/**
* @param $user_id
* @return array
*/
private function getUserPerms($user_id)
{
$strSQL = "SELECT * FROM acl_user_perms WHERE user_id = " . floatval($user_id) . " ORDER BY add_date ASC";
$this->conn->setSQL($strSQL);
$perms = array();
foreach ($this->conn->execStatement(PDO::FETCH_ASSOC) as $row) {
$pK = strtolower($this->getperm_keyFromid($row['perm_id']));
if ($pK == '') {
continue;
}
if ($row['value'] == '1') {
$hP = true;
} else {
$hP = false;
}
$perms[$pK] = array('perm' => $pK, 'inheritted' => false, 'value' => $hP, 'Name' => $this->getperm_nameFromid($row['perm_id']), 'id' => $row['perm_id']);
}
return $perms;
}
$row['state'] = dataEncode($data['state']);
$row['zip'] = dataEncode($data['zip']);
// secondary address
$row['street2'] = dataEncode($data['street2']);
$row['streetb2'] = dataEncode($data['streetb2']);
$row['city2'] = dataEncode($data['city2']);
$row['state2'] = dataEncode($data['state2']);
$row['zip2'] = dataEncode($data['zip2']);
// phones
$row['phone'] = dataEncode($data['phone']);
$row['phonew1'] = dataEncode($data['phonew1']);
$row['phonew2'] = dataEncode($data['phonew2']);
$row['phonecell'] = dataEncode($data['phonecell']);
$row['fax'] = dataEncode($data['fax']);
//additional info
$row['email'] = dataEncode($data['email']);
$row['assistant'] = dataEncode($data['assistant']);
$row['url'] = dataEncode($data['url']);
$row['upin'] = dataEncode($data['upin']);
$row['npi'] = dataEncode($data['npi']);
$row['federaltaxid'] = dataEncode($data['federaltaxid']);
$row['taxonomy'] = dataEncode($data['taxonomy']);
$row['notes'] = dataEncode($data['notes']);
// *************************************************************************************
// Finally that validated POST variables is inserted to the database
// This one make the JOB of two, if it has an ID key run the UPDATE statement
// if not run the INSERT stament
// *************************************************************************************
$mitos_db->setSQL("INSERT INTO users \n \t\t\t SET username = '******', " . "\n\t\t\t\t password = '******', " . "\n\t\t\t\t abook_type = '" . $row['abook_type'] . "', " . "\n\t\t\t\t title = '" . $row['title'] . "', " . "\n\t\t\t\t fname = '" . $row['fname'] . "', " . "\n\t\t\t\t mname = '" . $row['mname'] . "', " . "\n\t\t\t\t lname = '" . $row['lname'] . "', " . "\n\t\t\t\t specialty = '" . $row['specialty'] . "', " . "\n\t\t\t\t organization = '" . $row['organization'] . "', " . "\n\t\t\t\t valedictory = '" . $row['valedictory'] . "', " . "\n\t\t\t\t street = '" . $row['street'] . "', " . "\n\t\t\t\t streetb = '" . $row['streetb'] . "', " . "\n\t\t\t\t city = '" . $row['city'] . "', " . "\n\t\t\t\t state = '" . $row['state'] . "', " . "\n\t\t\t\t zip = '" . $row['zip'] . "', " . "\n\t\t\t\t street2 = '" . $row['street2'] . "', " . "\n\t\t\t\t streetb2 = '" . $row['streetb2'] . "', " . "\n\t\t\t\t city2 = '" . $row['city2'] . "', " . "\n\t\t\t\t state2 = '" . $row['state2'] . "', " . "\n\t\t\t\t zip2 = '" . $row['zip2'] . "', " . "\n\t\t\t\t phone = '" . $row['phone'] . "', " . "\n\t\t\t\t phonew1 = '" . $row['phonew1'] . "', " . "\n\t\t\t\t phonew2 = '" . $row['phonew2'] . "', " . "\n\t\t\t\t phonecell = '" . $row['phonecell'] . "', " . "\n\t\t\t\t fax = '" . $row['fax'] . "', " . "\n\t\t\t\t email = '" . $row['email'] . "', " . "\n\t\t\t\t assistant = '" . $row['assistant'] . "', " . "\n\t\t\t\t url = '" . $row['url'] . "', " . "\n\t\t\t\t upin = '" . $row['upin'] . "', " . "\n\t\t\t\t npi = '" . $row['npi'] . "', " . "\n\t\t\t\t federaltaxid = '" . $row['federaltaxid'] . "', " . "\n\t\t\t\t taxonomy = '" . $row['taxonomy'] . "', " . "\n\t\t\t\t notes = '" . $row['notes'] . "'");
$mitos_db->execLog();
echo "{ success: true }";
//--------------------------------------------------------------------------------------------------------------------------
// listOrganization.json.php
//
// v0.0.1
// Under GPLv3 License
//
// Integrated by: Gi Technologies. in 2011
//
// Remember, this file is called via the Framework Store, this is the AJAX thing.
//--------------------------------------------------------------------------------------------------------------------------
session_name("MitosEHR");
session_start();
session_cache_limiter('private');
include_once $_SESSION['site']['root'] . "/classes/dbHelper.php";
// **************************************************************************************
// Reset session count 10 secs = 1 Flop
// **************************************************************************************
$_SESSION['site']['flops'] = 0;
// **************************************************************************************
// Database class instance
// **************************************************************************************
$mitos_db = new dbHelper();
$mitos_db->setSQL("SELECT \n\t\t\t\t\t\t*\n\t\t\t\t\tFROM\n \t\t\t\t\t\tusers\n\t\t\t\t\tHAVING\n \t\t\t\t\t\torganization <> ''");
$total = $mitos_db->rowCount();
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
$row['cName'] = $row['fname'] . " " . $row['mname'] . " " . $row['lname'];
array_push($rows, $row);
}
print json_encode(array('totals' => $total, 'row' => $rows));
/**
* @return array
*/
public function getCptUsedByClinic()
{
$this->db->setSQL("SELECT DISTINCT cpt.code, cpt.code_text, cpt.code_text_medium, cpt.code_text_short\n FROM encounter_codes_cpt AS ecc\n left JOIN cpt_codes AS cpt ON ecc.code = cpt.code\n ORDER BY cpt.code DESC");
$records = $this->db->fetchRecords(PDO::FETCH_ASSOC);
return array('totals' => count($records), 'rows' => $records);
}
} elseif ($option['ovalue'] == 'true') {
// if the sring is true let change the value to a bool
$option['ovalue'] = true;
} elseif ($option['ovalue'] == 'false') {
// if the sring is false let change the value to a bool
$option['ovalue'] = false;
}
$foo[$option['oname']] = $option['ovalue'];
}
return $foo;
}
$tree = getFileds($formPanel);
print json_encode(array('text' => '.', 'children' => $tree));
} elseif ($_REQUEST['task'] == 'optionsRequest') {
$currList = $_REQUEST["list_id"];
$mitos_db->setSQL("SELECT * FROM list_options WHERE list_id = '{$currList}' ORDER BY seq");
$total = $mitos_db->rowCount();
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
array_push($rows, $row);
}
print_r(json_encode(array('totals' => $total, 'row' => $rows)));
} elseif ($_REQUEST['task'] == 'formRequest') {
/**
* This will handle the New item Request where fiels id is not set
* to handle the update please go to the "else" statement after
*/
if ($_REQUEST['id'] == null) {
/**
* This will handle the new field
*/
include_once $_SESSION['site']['root'] . "/classes/dbHelper.php";
include_once $_SESSION['site']['root'] . "/repo/global_functions/global_functions.php";
$_SESSION['site']['flops'] = 0;
$mitos_db = new dbHelper();
$data = $_POST;
foreach ($data as $key => $val) {
if ($val == null) {
unset($data[$key]);
}
if ($val == 'off') {
$data[$key] = 0;
}
if ($val == 'on') {
$data[$key] = 1;
}
}
$sql = $mitos_db->sqlBind($data, "form_data_demographics", "I");
$mitos_db->setSQL($sql);
$ret = $mitos_db->execLog();
$pid = $mitos_db->lastInsertId;
$mitos_db->setSQL("SELECT pid, fname, mname, lname\n FROM form_data_demographics\n WHERE pid = '{$pid}'");
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
$row['fullname'] = fullname($row['fname'], $row['mname'], $row['lname']);
array_push($rows, $row);
}
if ($ret[2]) {
echo '{ success: false, errors: { reason: "' . $ret[2] . '" }}';
} else {
echo '{ "success": true, "patient": { "pid": "' . $row['pid'] . '", fullname:"' . $row['fullname'] . '" } }';
}
// }
// }
//}
$filename = 'cdt.txt';
$handle = fopen($filename, 'r');
$string = fread($handle, filesize($filename));
//preg_match("/(\w*?) (.*\n)/", $string, $matches, PREG_OFFSET_CAPTURE);
//
//print '<pre>';
//print_r($matches);
//
//$html = "<b>bold text</b><a href=howdy.html>click me</a>";
preg_match_all("/(.*?) (.*)\n/", $string, $matches, PREG_SET_ORDER);
foreach ($matches as $val) {
$data = array('code' => $val[1], 'text' => $val[2]);
$db->setSQL($db->sqlBind($data, 'cdt_codes', 'I'));
$db->execOnly();
}
// print_r($res);
//foreach($res as $num => $val){
// echo '<pre>';
// if(is_odd($num)){
// foreach($res[$num] as $item => $inside){
// //$surgeries=($inside);
// $data['surgeries'] = $inside;
//
// print $db->sqlBind($data, 'table_example', 'I');
// echo '<br>';
//// $sql= "INSERT INTO surgeries (type, surgery, type_num) VALUES('".$tittle."','".$surgeries."','".$type_num."')";
////
//// mysql_query($sql);
$file_handle = fopen("icds.txt", "r");
while (!feof($file_handle)) {
$line = fgets($file_handle);
$data = array();
$foo = explode("\t", $line);
$data['id'] = $foo[0];
$data['parent_id'] = $foo[1];
$data['code_text'] = $foo[2];
$data['code_text_short'] = $foo[3];
$data['code'] = $foo[4];
$data['digits'] = $foo[5];
$data['sequence'] = $foo[6];
$data['category_range'] = $foo[7];
$data['billing_status'] = $foo[8];
$data['status'] = $foo[9];
$data['is_custom_code'] = $foo[10];
// $data['doc_url3'] = $foo[11];
// $data['r'] = $foo[12];
// $data['s'] = $foo[13];
// $data['t'] = $foo[14];
// $data['u'] = $foo[15];
// $data['v'] = $foo[16];
// $data['w'] = $foo[17];
// $data['x'] = $foo[18];
$db->setSQL($db->sqlBind($data, 'codes_icds', 'I'));
$db->execOnly();
}
if (feof($file_handle)) {
print 'The End!';
}
fclose($file_handle);
//--------------------------------------------------------------------------------------------------------------------------
session_name("MitosEHR");
session_start();
session_cache_limiter('private');
include_once $_SESSION['site']['root'] . "/classes/dbHelper.php";
require_once $_SESSION['site']['root'] . "/classes/AES.php";
//******************************************************************************
// Reset session count 10 secs = 1 Flop
//******************************************************************************
$_SESSION['site']['flops'] = 0;
//------------------------------------------
// Database class instance
//------------------------------------------
$mitos_db = new dbHelper();
$WHERE = $_REQUEST["show"] == "active" ? "WHERE activity = 1" : "";
// Setting defults incase no request is sent by sencha
$start = $_REQUEST["start"] == null ? 0 : $_REQUEST["start"];
$limit = $_REQUEST["limit"] == null ? 10 : $_REQUEST["limit"];
$facillity = $_REQUEST["facillity"];
$mitos_db->setSQL("SELECT id FROM onotes " . $WHERE . " ORDER BY date DESC");
$total = $mitos_db->rowCount();
$mitos_db->setSQL("SELECT * FROM onotes " . $WHERE . " ORDER BY date DESC\n \t\t\tLIMIT " . $start . "," . $limit);
// WHERE onotes.facillity = '$facillity'
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
array_push($rows, $row);
}
//------------------------------------------------------------------------------
// here we are adding "totals" and the root "row" for sencha use
//------------------------------------------------------------------------------
print_r(json_encode(array('totals' => $total, 'row' => $rows)));
<?php
//--------------------------------------------------------------------------------------------------------------------------
// listAllergies.json.php
//
// v0.0.1
// Under GPLv3 License
//
// Integrated by: Gi Technologies. in 2011
//
// Remember, this file is called via the Framework Store, this is the AJAX thing.
//--------------------------------------------------------------------------------------------------------------------------
session_name("MitosEHR");
session_start();
session_cache_limiter('private');
include_once $_SESSION['site']['root'] . "/classes/dbHelper.php";
// **************************************************************************************
// Reset session count 10 secs = 1 Flop
// **************************************************************************************
$_SESSION['site']['flops'] = 0;
// **************************************************************************************
// Database class instance
// **************************************************************************************
$mitos_db = new dbHelper();
$mitos_db->setSQL("SELECT \n\t\t\t\t\t\t*\n\t\t\t\t\tFROM\n \t\t\t\t\t\tlists\n\t\t\t\t\tWHERE\n \t\t\t\t\t\ttype = 'allergy' AND enddate IS NULL\n\t\t\t\t\tORDER BY\n \t\t\t\t\t\tbegdate");
$total = $mitos_db->rowCount();
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
array_push($rows, $row);
}
print json_encode(array('totals' => $total, 'row' => $rows));
include_once $_SESSION['site']['root'] . "/classes/dbHelper.php";
$mitos_db = new dbHelper();
$rawData = file_get_contents("php://input");
$foo = json_decode($rawData, true);
$data = $foo['row'];
$start = !$_REQUEST["start"] ? 0 : $_REQUEST["start"];
$limit = !$_REQUEST["limit"] ? 10 : $_REQUEST["limit"];
$rows = array();
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
switch ($_GET['task']) {
case "pharmacy":
//******************************************************************
// Lets get the pharmacies and address and order by name
//******************************************************************
$mitos_db->setSQL("SELECT pharmacies.id AS id,\n pharmacies.name,\n pharmacies.transmit_method,\n pharmacies.email,\n addresses.id AS address_id,\n addresses.line1,\n addresses.line2,\n addresses.city,\n addresses.state,\n addresses.zip,\n addresses.plus_four,\n addresses.country,\n addresses.foreign_id AS address_foreign_id\n FROM pharmacies\n LEFT JOIN addresses ON pharmacies.id = addresses.foreign_id\n ORDER BY pharmacies.name DESC");
$total = $mitos_db->rowCount();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
$mitos_db->setSQL("SELECT * FROM phone_numbers WHERE phone_numbers.foreign_id =" . $row['id'] . "");
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $phoneRow) {
switch ($phoneRow['type']) {
case "2":
$row['phone_id'] = $phoneRow['id'];
$row['phone_country_code'] = $phoneRow['country_code'];
$row['phone_area_code'] = $phoneRow['area_code'];
$row['phone_prefix'] = $phoneRow['prefix'];
$row['phone_number'] = $phoneRow['number'];
$row['phone_full'] = $phoneRow['country_code'] . ' ' . $phoneRow['area_code'] . '-' . $phoneRow['prefix'] . '-' . $phoneRow['number'];
break;
case "5":
$row['fax_id'] = $phoneRow['id'];
//------------------------------------------
// Database class instance
//------------------------------------------
$mitos_db = new dbHelper();
// *************************************************************************************
// Validate and pass the POST variables to an array
// This is the moment to validate the entered values from the user
// although Sencha EXTJS make good validation, we could check again
// just in case
// *************************************************************************************
$row['list_id'] = dataEncode($data->list_id);
$row['option_id'] = dataEncode($data->option_id);
$row['title'] = dataEncode($data->title);
$row['seq'] = dataEncode($data->seq);
$row['is_default'] = trim($data->is_default) == 'true' ? 1 : 0;
$row['option_value'] = dataEncode($data->option_value);
$row['mapping'] = dataEncode($data->mapping);
$row['notes'] = dataEncode($data->notes);
// *************************************************************************************
// Finally that validated POST variables is inserted to the database
// This one make the JOB of two, if it has an ID key run the UPDATE statement
// if not run the INSERT stament
// *************************************************************************************
$sql = $mitos_db->sqlBind($row, "list_options", "u", "id='" . $data->id . "'");
$mitos_db->setSQL($sql);
$ret = $mitos_db->execLog();
if ($ret == "") {
echo '{ success: false, errors: { reason: "' . $ret[2] . '" }}';
} else {
echo "{ success: true }";
}
//******************************************************************************
// Reset session count 10 secs = 1 Flop
//******************************************************************************
$_SESSION['site']['flops'] = 0;
//-------------------------------------------
// password to AES and validate
//-------------------------------------------
$aes = new AES($_SESSION['site']['AESkey']);
//------------------------------------------
// Database class instance
//------------------------------------------
$mitos_db = new dbHelper();
// Setting defults incase no request is sent by sencha
$start = $_REQUEST["start"] == null ? 0 : $_REQUEST["start"];
$count = $_REQUEST["limit"] == null ? 10 : $_REQUEST["limit"];
$mitos_db->setSQL("SELECT users.*, \n \t\t\t\t list_options.option_id AS ab_name,\n \t\t\t\t list_options.title AS ab_title \n \t\t\t FROM users\n \t\tLEFT JOIN list_options ON list_id = 'abook_type' AND option_id = users.abook_type\n \t\t\tWHERE users.active = 1 AND ( users.authorized = 1 OR users.username = '' )\n \t\t\tLIMIT " . $start . "," . $count);
//---------------------------------------------------------------------------------------
// catch the total records
//---------------------------------------------------------------------------------------
$total = $mitos_db->rowCount();
//---------------------------------------------------------------------------------------
// start the array
//---------------------------------------------------------------------------------------
$rows = array();
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) {
$row['fullname'] = fullname($row['fname'], $row['mname'], $row['lname']);
if ($row['street'] != NULL || $row['street'] != "") {
$rec['street'] = $row['street'] . "<br>";
} else {
$rec['street'] = $row['street'];
}
