/**
* @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;
}
/**
* @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;
}
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'] . '" } }';
}
session_start();
session_cache_limiter('private');
$_SESSION['site']['flops'] = 0;
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'];
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
$mitos_db->setSQL("SELECT gl_name, gl_index, gl_value FROM globals");
// ****************************************************************************************************
// $rows = $mitos_db->execStatement(PDO::FETCH_ASSOC) because we wwant to print all recods into one row
// ****************************************************************************************************
$rows = array();
foreach ($mitos_db->execStatement() as $row) {
$rows['data_id'] = '1';
$rows[$row[0]] = $row[2];
}
print_r(json_encode(array('totals' => '1', 'row' => $rows)));
exit;
case 'PUT':
foreach ($data as $key => $value) {
//--------------------------------------------------------------------------
// lets skip data_id, it doesn't exist in the database
// this id is for ExtJs use only
//--------------------------------------------------------------------------
if ($key != 'data_id') {
//---------------------------------------------------------------------
// check value is an int and trim it, else dateDecode it
//---------------------------------------------------------------------
echo ']}' . chr(13);
break;
// *************************************************************************************
// Create a new list
// This data creation is special, we don't nee a data_create.ejs.php to do this.
// *************************************************************************************
// *************************************************************************************
// Create a new list
// This data creation is special, we don't nee a data_create.ejs.php to do this.
// *************************************************************************************
case "c_list":
$mitos_db = new dbHelper();
// check if this already exists
$sql = "SELECT count(*) as howmany FROM list_options WHERE title= '" . $_POST['list_name'] . "' OR option_id = '" . strtolower($_POST['option_id']) . "'";
$mitos_db->setSQL($sql);
$ret = $mitos_db->execStatement(PDO::FETCH_ASSOC);
if ($ret[0]['howmany']) {
echo '{ success: false, errors: { reason: "' . i18n('This record already exists', 'r') . '" }}';
return;
}
// Get last sequence of the list option
$sql = "SELECT count(seq) as last_seq FROM list_options WHERE list_id = 'lists' ORDER BY title, seq";
$mitos_db->setSQL($sql);
$ret = $mitos_db->execStatement(PDO::FETCH_ASSOC);
$c = $ret[0]['last_seq'] + 1;
// Finally - Insert the list option
$sql = "INSERT INTO \n\t\t\t\t\tlist_options \n\t\t\t\tSET \n\t\t\t\t\tlist_id='lists',\n\t\t\t\t\toption_id='" . strtolower($_POST['option_id']) . "',\n\t\t\t\t\ttitle='" . $_POST['list_name'] . "',\n\t\t\t\t\tseq='" . $c . "',\n\t\t\t\t\tis_default='0',\n\t\t\t\t\toption_value='0',\n\t\t\t\t\tmapping='',\n\t\t\t\t\tnotes=''";
$mitos_db->setSQL($sql);
$ret = $mitos_db->execLog();
if ($ret == "") {
echo '{ success: false, errors: { reason: "' . $ret[2] . '" }}';
//--------------------------------------------------------------------------------
$mitos_db = new dbHelper();
//--------------------------------------------------------------------------------
// always echo the first display Field (Fees)
//--------------------------------------------------------------------------------
echo "{ width: 70, xtype: 'displayfield', value: '";
echo i18n('Fees');
echo ": '}";
//**********************************************************************************************************************
// look for pricelevel lists from list_options table
//**********************************************************************************************************************
$mitos_db->setSQL("SELECT option_id, title\n FROM list_options\n WHERE list_id = 'pricelevel'\n ORDER BY seq");
//--------------------------------------------------------------------------------
// echo the fields
//--------------------------------------------------------------------------------
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $fee) {
echo ",{ width: 100, xtype: 'textfield', name: 'fee_" . $fee['option_id'] . "', emptyText: '";
echo i18n($fee['title']);
echo "'}";
}
//**********************************************************************************************************************
// look for te taxes fields
//**********************************************************************************************************************
$mitos_db->setSQL("SELECT option_id, title\n FROM list_options\n WHERE list_id = 'taxrate'\n ORDER BY seq");
$total = $mitos_db->rowCount();
//--------------------------------------------------------------------------------
// if a tax field fond - echo the "Taxes" display field and the fields
//--------------------------------------------------------------------------------
if ($total > 0) {
echo ",{ width: 70, xtype: 'displayfield', value: '";
echo i18n('Taxes');
<?php
//--------------------------------------------------------------------------------------
// Database class instance
//--------------------------------------------------------------------------------------
$mitos_db = new dbHelper();
//--------------------------------------------------------------------------------------
// Lets pull the data from globals table and settings the $_SESSION['global_settings'] values
//--------------------------------------------------------------------------------------
$mitos_db->setSQL("SELECT gl_name, gl_value FROM globals");
foreach ($mitos_db->execStatement(PDO::FETCH_ASSOC) as $setting) {
$_SESSION['global_settings'][$setting['gl_name']] = $setting['gl_value'];
}
