/** * @internal param string $format * @return array */ public function getAllRoles() { $roles = array(); $this->conn->setSQL("SELECT * FROM acl_roles ORDER BY seq ASC"); foreach ($this->conn->fetchRecords(PDO::FETCH_ASSOC) as $row) { array_push($roles, $row); } $total = $this->conn->rowCount(); return array('totals' => $total, 'row' => $roles); }
public function verifyUserPass($pass) { $aes = new AES($_SESSION['site']['AESkey']); $pass = $aes->encrypt($pass); $uid = $_SESSION['user']['id']; $this->db->setSQL("SELECT username FROM users WHERE id = '{$uid}' AND password = '******' AND authorized = '1' LIMIT 1"); $count = $this->db->rowCount(); return $count != 0 ? 1 : 2; }
/** * @return bool */ private function fieldHasBrother() { $this->db->setSQL("SELECT id FROM forms_field_options WHERE options LIKE '%\"name\":\"{$this->col}%\"'"); $this->db->fetchRecords(PDO::FETCH_ASSOC); $count = $this->db->rowCount(); if ($count >= 2) { return true; } else { return false; } }
/** * @return array */ public function checkOpenEncounters() { $pid = $_SESSION['patient']['pid']; $this->db->setSQL("SELECT pid FROM encounters WHERE pid = '{$pid}' AND close_date IS NULL"); $total = $this->db->rowCount(); if ($total >= 1) { return array('encounter' => true); } else { return array('encounter' => false); } }
//-------------------------------------------------------------------------------------------------------------------------- // 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));
//****************************************************************************** $_SESSION['site']['flops'] = 0; //------------------------------------------ // Database class instance //------------------------------------------ $mitos_db = new dbHelper(); // ************************************************************************************* // Deside what to do with the $_GET['task'] // ************************************************************************************* switch ($_GET['task']) { // ************************************************************************************* // Data for Form List // ************************************************************************************* case "form_list": $mitos_db->setSQL("SELECT DISTINCT form_id FROM layout_options"); $totals = $mitos_db->rowCount(); //--------------------------------------------------------------------------------------- // start the array //--------------------------------------------------------------------------------------- $rows = array(); foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $row) { $row['id'] = $row['form_id']; array_push($rows, $row); } //--------------------------------------------------------------------------------------- // here we are adding "totals" and the root "row" for sencha use //--------------------------------------------------------------------------------------- print json_encode(array('totals' => $totals, 'row' => $rows)); break; // ************************************************************************************* // Available Data Types for the Form Editor