Пример #1
0
 public function createStore()
 {
     $this->load->dbforge();
     $this->load->helper('file_helper');
     $this->load->helper('Mobile_Detect_helper');
     $this->load->helper('create_db_helper');
     $detect = new Mobile_Detect();
     $deviceName = "";
     if ($detect->isMobile()) {
         $deviceName = "mobile";
     } else {
         if ($detect->isTablet()) {
             $deviceName = "tablet";
         } else {
             $deviceName = "pc";
         }
     }
     $post = $this->input->post();
     $clientInfo = $post["clientInfo"];
     $userId = $this->session->userdata("userid");
     $databaseObj = $this->template->getTemplateName($post["key"]);
     $resultObj = $databaseObj->result()[0];
     $projectName = $resultObj->TemplateProjectName;
     $projectImage = $resultObj->TemplateImage;
     recursive_copy("assets/template/" . $projectName, "../" . $post["domainName"]);
     copy("assets/images/screen-shot/" . $projectImage, "assets/images/screen-shot/" . $post["domainName"] . ".jpg");
     $databaseObj->next_result();
     $databaseObj = $this->template->createStore($post["storeName"], $post["domainName"], $userId, $post["key"], $clientInfo["appCodeName"], $clientInfo["appVersion"], $this->input->ip_address(), $deviceName, $clientInfo["platform"]);
     $newStore = $databaseObj->result()[0];
     $databaseObj->next_result();
     execSql($newStore->TemplateType, $post["domainName"], get_instance());
 }
Пример #2
0
function dummyAgents($db, $count = 10)
{
    for ($i = 1; $i <= $count; $i++) {
        execSql($db, "INSERT INTO agent (id) VALUES ({$i})", "add dummy agent {$i}");
    }
}
Пример #3
0
loadSchema('acl');
include_once dirname(__FILE__) . '/../lib/org/freemedsoftware/module/ACL.class.php';
$a = new ACL();
$q = "SELECT username, id FROM user WHERE id > 0";
$r = $GLOBALS['sql']->queryAll($q);
foreach ($r as $user) {
    print " - Adding ACL record for user " . $user['username'] . " (" . $user['id'] . ") \n";
    $a->UserAdd($r['id']);
}
printHeader("Create 'healthy system' status");
`touch ./data/cache/healthy`;
printHeader("Rebuild differently organized tables");
//	-- Allergies
execSql("INSERT INTO allergies ( patient ) SELECT DISTINCT patient FROM allergies_old;");
execSql("CREATE TEMPORARY TABLE allergies_atomic_temp SELECT * FROM allergies_atomic;");
execSql("INSERT INTO allergies_atomic_temp ( aid, allergy, severity, patient ) SELECT a.id, o.allergy, o.severity, a.patient FROM allergies_old o LEFT OUTER JOIN allergies a ON o.patient = a.patient;");
execSql("INSERT INTO allergies_atomic SELECT * FROM allergies_atomic_temp;");
execSql("DROP TEMPORARY TABLE allergies_atomic_temp;");
//	-- Medications
execSql("INSERT INTO medications ( mpatient, mdate ) SELECT DISTINCT mpatient, mdate FROM medications_old;");
execSql("CREATE TEMPORARY TABLE medications_atomic_temp SELECT * FROM medications_atomic;");
execSql("INSERT INTO medications_atomic_temp ( mid, mdrug, mdosage, mroute, mdate, mpatient ) SELECT m.id, o.mdrug, o.mdosage, o.mroute, m.mdate, m.mpatient FROM medications_old o LEFT OUTER JOIN medications m ON o.mpatient = m.mpatient;");
execSql("INSERT INTO medications_atomic SELECT * FROM medications_atomic_temp;");
execSql("DROP TEMPORARY TABLE medications_atomic_temp;");
//	-- Practice records
execSql("INSERT INTO practice ( pracname, ein, addr1a, addr2a, citya, statea, zipa, phonea, faxa, addr1b, addr2b, cityb, stateb, zipb, phoneb, faxb, email, cellular, pager, id ) SELECT phypracname, phypracein, phyaddr1a, phyaddr2a, phycitya, phystatea, phyzipa, phyphonea, phyfaxa, phyaddr1b, phyaddr2b, phycityb, phystateb, phyzipb, phyphoneb, phyfaxb, phyemail, phycellular, phypager, id FROM physician;");
execSql("ALTER IGNORE TABLE physician ADD COLUMN phypractice INT UNSIGNED NOT NULL DEFAULT 0 AFTER phytitle;");
execSql("UPDATE physician SET phypractice = id;");
//	-- Templates, if they exist
execSql("INSERT INTO pnotes_templates SELECT pntname, pntphy, pntS, pntO, pntA, pntP, pntI, pntE, pntR, NOW(), NULL FROM pntemplate;");