PHP DBManagerFactory类代码示例

 function display()
 {
     $db = DBManagerFactory::getInstance();
     /* <<<<<<< HEAD
     		$sql = "SELECT p.id,p.first_name,p.last_name,p.dob FROM reg_patient p WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.next_pmp_review_due_c is not null) ORDER By p.last_name, p.first_name";
     ======= */
     $sql = "SELECT p.id,p.first_name,p.last_name,p.dob, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null) ORDER By p.last_name, p.first_name";
     // >>>>>>> 3097a71433de82fec730df252659026274347e46
     $resultb = $db->query($sql, true);
     $final = array();
     while ($row = $db->fetchByAssoc($resultb)) {
         $final[] = $row;
     }
     $sql1 = "SELECT p.id, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null) GROUP BY provname ORDER By p.last_name, p.first_name";
     $resultb1 = $db->query($sql1, true);
     $final1 = array();
     while ($row1 = $db->fetchByAssoc($resultb1)) {
         $final1[] = $row1;
     }
     $sugarSmarty = new Sugar_Smarty();
     $sugarSmarty->assign("data", $final);
     $sugarSmarty->assign("data1", $final1);
     $sugarSmarty->assign("title", "Patients who do not have PMP");
     $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report1REG_Patient.tpl');
     //        parent::display();
 }

 /**
  * This methods schedules the Jobs
  *
  * @param int $perJob
  * @return array|mixed
  */
 public static function scheduleRevenueLineItemUpdateJobs($perJob = 100)
 {
     /* @var $db DBManager */
     $db = DBManagerFactory::getInstance();
     // get all the opps to break into groups of 100 and go newest to oldest
     $sql = "select id from revenue_line_items where deleted = 0 ORDER BY date_modified DESC;";
     $results = $db->query($sql);
     $jobs = array();
     $toProcess = array();
     while ($row = $db->fetchRow($results)) {
         $toProcess[] = $row['id'];
         if (count($toProcess) == $perJob) {
             $jobs[] = static::createJob($toProcess);
             $toProcess = array();
         }
     }
     if (!empty($toProcess)) {
         $jobs[] = static::createJob($toProcess);
     }
     // if only one job was created, just return that id
     if (count($jobs) == 1) {
         return array_shift($jobs);
     }
     return $jobs;
 }

 function display()
 {
     $focus = new AirlinesTicketsLists();
     $ss = new Sugar_Smarty();
     $db = DBManagerFactory::getInstance();
     // ONLY LOAD A RECORD IF A RECORD ID IS GIVEN;
     // A RECORD ID IS NOT GIVEN WHEN VIEWING IN LAYOUT EDITOR
     $record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
     $template = file_get_contents('modules/AirlinesTicketsLists/tpls/export.tpl');
     $sql = "Select * From AirlinesTicketsLists p Where p.id = '" . $record . "' And p.deleted = 0";
     $result = $db->query($sql);
     $row = $db->fetchByAssoc($result);
     $fromitinerary = "";
     $itinerary = "";
     $time = "";
     $itinerary2 = "";
     $time2 = "";
     $template = str_replace("{FIT_RECORE}", $focus->get_AirlinesTickets_list($record, $fromitinerary, $itinerary, $time, $itinerary2, $time2), $template);
     $template = str_replace("{TITLE}", $row['name'], $template);
     $template = str_replace("{FROM}", $fromitinerary, $template);
     $template = str_replace("{CHUYENBAY1}", $itinerary, $template);
     $template = str_replace("{TIME1}", $time, $template);
     $template = str_replace("{CHUYENBAY2}", $itinerary2, $template);
     $template = str_replace("{TIME2}", $time2, $template);
     $size = strlen($template);
     $filename = "DANH_SACH_DOAN_" . strtoupper($row['code']) . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
 }

 function start()
 {
     $this->db = DBManagerFactory::getInstance();
     $this->userDemoData = new UserDemoData($this->user, false);
     $this->trackerManager = TrackerManager::getInstance();
     foreach ($this->modules as $mod) {
         $query = "select id from {$mod}";
         $result = $this->db->limitQuery($query, 0, 50);
         $ids = array();
         while ($row = $this->db->fetchByAssoc($result)) {
             $ids[] = $row['id'];
         }
         //while
         $this->beanIdMap[$mod] = $ids;
     }
     while ($this->monitorIds-- > 0) {
         $this->monitorId = create_guid();
         $this->trackerManager->setMonitorId($this->monitorId);
         $this->user = $this->userDemoData->guids[array_rand($this->userDemoData->guids)];
         $this->module = $this->modules[array_rand($this->modules)];
         $this->action = $this->actions[array_rand($this->actions)];
         $this->date = $this->randomTimestamp();
         $this->populate_tracker();
         $this->populate_tracker_perf();
         $this->populate_tracker_sessions();
         $this->populate_tracker_queries();
         $this->trackerManager->save();
     }
 }

 /**
  * Commit a manager forecast from the draft records
  *
  * @param User $manager
  * @param string $timeperiod
  * @return bool
  */
 public function commitManagerForecast(User $manager, $timeperiod)
 {
     global $current_user;
     // make sure that the User passed in is actually a manager
     if (!User::isManager($manager->id)) {
         return false;
     }
     /* @var $db DBManager */
     $db = DBManagerFactory::getInstance();
     $sql = 'SELECT name, assigned_user_id, team_id, team_set_id, quota, best_case, best_case_adjusted,
             likely_case, likely_case_adjusted, worst_case, worst_case_adjusted, currency_id, base_rate,
             timeperiod_id, user_id, opp_count, pipeline_opp_count, pipeline_amount, closed_amount ' . 'FROM ' . $this->table_name . ' ' . 'WHERE assigned_user_id = ' . $db->quoted($manager->id) . ' AND user_id != ' . $db->quoted($manager->id) . ' ' . 'AND timeperiod_id = ' . $db->quoted($timeperiod) . ' AND draft = 1 AND deleted = 0 ' . 'UNION ALL ' . 'SELECT name, assigned_user_id, team_id, team_set_id, quota, best_case, best_case_adjusted,
                 likely_case, likely_case_adjusted, worst_case, worst_case_adjusted, currency_id, base_rate,
                 timeperiod_id, user_id, opp_count, pipeline_opp_count, pipeline_amount, closed_amount ' . 'FROM ' . $this->table_name . ' ' . 'WHERE assigned_user_id = ' . $db->quoted($manager->id) . ' AND user_id = ' . $db->quoted($manager->id) . ' ' . 'AND timeperiod_id = ' . $db->quoted($timeperiod) . ' AND draft = 1 AND deleted = 0';
     $results = $db->query($sql);
     $this->fixTopLevelManagerQuotaRollup($manager->id, $timeperiod);
     while ($row = $db->fetchByAssoc($results)) {
         /* @var $worksheet ForecastManagerWorksheet */
         $worksheet = BeanFactory::getBean('ForecastManagerWorksheets');
         $worksheet->retrieve_by_string_fields(array('user_id' => $row['user_id'], 'assigned_user_id' => $row['assigned_user_id'], 'timeperiod_id' => $row['timeperiod_id'], 'draft' => 0, 'deleted' => 0));
         foreach ($row as $key => $value) {
             $worksheet->{$key} = $value;
         }
         $worksheet->draft = 0;
         // make sure this is always 0!
         $worksheet->save();
         $type = $worksheet->user_id == $current_user->id ? 'Direct' : 'Rollup';
         $disableAS = $worksheet->user_id == $current_user->id;
         $this->_assignQuota($worksheet->quota, $type, $worksheet->user_id, $timeperiod, $disableAS);
     }
     return true;
 }

 /**
  * Add visibility clauses to the WHERE part of the query
  * @param string $query
  * @return string
  */
 public function addVisibilityWhere(&$query)
 {
     global $current_user;
     if (!empty($this->targetModuleField) && !$current_user->isAdmin()) {
         $table_alias = $this->getOption('table_alias');
         $db = DBManagerFactory::getInstance();
         if (empty($table_alias)) {
             $table_alias = $this->bean->table_name;
         }
         $modules = array_map(function ($value) use($db) {
             return $db->quoted($value);
         }, $current_user->getDeveloperModules());
         if (empty($modules)) {
             $devWhere = "{$table_alias}.{$this->targetModuleField} IS NULL";
         } else {
             $devWhere = "{$table_alias}.{$this->targetModuleField} IN (" . implode(',', $modules) . ")";
         }
         if (!empty($query)) {
             $query .= " AND {$devWhere}";
         } else {
             $query = $devWhere;
         }
     }
     return $query;
 }

 function display()
 {
     global $sugar_config, $timedate;
     $focus = new GroupLists();
     $ss = new Sugar_Smarty();
     $db = DBManagerFactory::getInstance();
     // ONLY LOAD A RECORD IF A RECORD ID IS GIVEN;
     // A RECORD ID IS NOT GIVEN WHEN VIEWING IN LAYOUT EDITOR
     $record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
     $template = file_get_contents('modules/GroupLists/tpls/Export.tpl');
     $sql = "SELECT\r\n                 g.groupprogram_code\r\n                ,g.tour_name\r\n                ,g.end_date_group\r\n                ,g.start_date_group\r\n                FROM\r\n                  groupprograms g INNER JOIN grouplists_roupprograms_c ggr ON g.id = ggr.grouplistsf242rograms_idb \r\n                  INNER JOIN grouplists gl ON gl.id = ggr.grouplists87eduplists_ida \r\n                WHERE gl.deleted = 0 AND ggr.deleted = 0 AND g.deleted = 0 AND ggr.grouplists87eduplists_ida = '" . $record . "'";
     $result = $db->query($sql);
     $row = $db->fetchByAssoc($result);
     $template = str_replace("{TOURNAME}", mb_strtoupper($row['tour_name'], 'utf-8'), $template);
     $template = str_replace("{SITE_URL}", $sugar_config['site_url'], $template);
     $template = str_replace("{CODE}", $row['groupprogram_code'], $template);
     $template = str_replace("{START_DATE}", $timedate->to_display_date($row['start_date_group'], true), $template);
     $template = str_replace("{END_DATE}", $timedate->to_display_date($row['end_date_group'], true), $template);
     $template = str_replace("{SOLUONG}", $focus->get_count($record), $template);
     $template = str_replace("{TEL}", '', $template);
     $template = str_replace("{FAX}", '', $template);
     //$template = str_replace("{LIST_GIT}", $focus->get_GIT_to_report("('".$record."')"),$template);
     $template = str_replace("{LIST_FIT}", $focus->get_customer_list("('" . $record . "')"), $template);
     $template = str_replace("{DATE}", date('d/m/Y'), $template);
     $size = strlen($template);
     $filename = "DS Doan " . mb_strtoupper($row['tour_name'], 'utf-8') . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
 }

 public function setUp()
 {
     $this->_db = DBManagerFactory::getInstance();
     if (get_class($this->_db) != 'FreeTDSManager') {
         $this->markTestSkipped("Skipping test if not mssql configuration");
     }
 }

function add_prospects_to_prospect_list($query, $parent_module, $parent_type, $parent_id, $child_id, $link_attribute, $link_type)
{
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $query);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $parent_module);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $parent_type);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $parent_id);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $child_id);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $link_attribute);
    $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:' . $link_type);
    if (!class_exists($parent_type)) {
        require_once 'modules/' . $parent_module . '/' . $parent_type . '.php';
    }
    $focus = new $parent_type();
    $focus->retrieve($parent_id);
    //if link_type is default then load relationship once and add all the child ids.
    $relationship_attribute = $link_attribute;
    //find all prospects based on the query
    $db = DBManagerFactory::getInstance();
    $result = $db->query($query);
    while (($row = $db->fetchByAssoc($result)) != null) {
        $GLOBALS['log']->debug('target_id' . $row[$child_id]);
        if ($link_type != 'default') {
            $relationship_attribute = strtolower($row[$link_attribute]);
        }
        $GLOBALS['log']->debug('add_prospects_to_prospect_list:relationship_attribute:' . $relationship_attribute);
        //load relationship for the first time or on change of relationship atribute.
        if (empty($focus->{$relationship_attribute})) {
            $focus->load_relationship($relationship_attribute);
        }
        //add
        $focus->{$relationship_attribute}->add($row[$child_id]);
    }
}

 function snippet()
 {
     /* get sort order from session */
     //session_start(); // Make a reference to the current session object,set order
     //$_SESSION['regnamesort']= 'test' ; Set a value in a session variable
     //$GLOBALS['log']->fatal('start display');
     //var_dump($this->bean);
     $smarty = new Sugar_Smarty();
     //parent::display();
     $db = DBManagerFactory::getInstance();
     $myquery = "SELECT tab4a.first_name fname, tab4a.last_name lname,  tab5a.mrn_c mrn, tab4a.gender gender FROM reg_patient  tab4a , reg_patient_cstm tab5a WHERE tab4a.id = tab5a.id_c AND tab4a.id = '" . $_REQUEST['patid'] . "'";
     $result = $db->query($myquery);
     $patdata = null;
     $row = $db->fetchRow($result);
     $smarty->assign("patdata", $row);
     $risk = new RiskEvaluation();
     //when week filter need to add week interval
     //get patient risk if exists
     //if ($_POST['mysort'] == 'week')
     if (!empty($_REQUEST['patid'])) {
         $risk->getRisk($_REQUEST['patid']);
         $smarty->assign("pid", $_REQUEST['patid']);
     }
     //echo 'request'.$_REQUEST['patid'];
     //else return false; //param not found
     //var_dump($risk);
     $smarty->assign("myrisk", $risk);
     global $current_user;
     $smarty->assign("myuser", $current_user);
     $smarty->assign("test", "test");
     return $smarty->fetch('custom/modules/REG_Patient/tpls/RiskEvaluationREG_Patient.tpl');
 }

 function zuckerreports_query($session, $sql)
 {
     global $current_user;
     $util = new SugarWebServiceUtilv4_1();
     if (!$util->validate_authenticated($session)) {
         return array('result' => 'error', 'message' => 'ZuckerReports Query invalid session');
     }
     $admin = new Administration();
     $admin->retrieveSettings();
     $sugaruser = $admin->settings['zuckerreports2_ondemandsugaruser'];
     if ($current_user->user_name != $sugaruser) {
         return array('result' => 'error', 'message' => 'ZuckerReports Query invalid user (' . $current_user->user_name . ')');
     }
     $db = DBManagerFactory::getInstance();
     $result = $db->query($sql);
     $row_list = array();
     $colnames_list = array();
     while (($row = $db->fetchByAssoc($result)) != null) {
         if (empty($colnames_list)) {
             foreach ($row as $colname => $colval) {
                 $colnames_list[] = $colname;
             }
         }
         $json_row = array();
         foreach ($row as $colname => $colval) {
             $json_row[] = $colval;
         }
         $row_list[] = $json_row;
     }
     return array('result' => 'ok', 'columnnames_list' => $colnames_list, 'rows_list' => $row_list);
 }

 function display()
 {
     $focus = new Insurances();
     $ss = new Sugar_Smarty();
     $db = DBManagerFactory::getInstance();
     // ONLY LOAD A RECORD IF A RECORD ID IS GIVEN;
     // A RECORD ID IS NOT GIVEN WHEN VIEWING IN LAYOUT EDITOR
     $record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
     $template = file_get_contents('modules/Insurances/tpls/export.tpl');
     $name = "";
     $start = "";
     $end = "";
     $canhan = "";
     $giadinh = "";
     $canhan = $focus->get_data_insurances_canhan($record, $name, $start, $end);
     $giadinh = $focus->get_data_insurances_giadinh($record, $name, $start, $end);
     $template = str_replace("{CANHAN}", $canhan, $template);
     $template = str_replace("{GIADINH}", $giadinh, $template);
     $template = str_replace("{TITLE}", $name, $template);
     $template = str_replace("{NGAYBATDAU}", $start, $template);
     $template = str_replace("{NGAYKETTHUC}", $end, $template);
     $size = strlen($template);
     $filename = strtoupper($name) . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
 }

 /**
  * Find custom address fields added to default modules (ones that show up in the field_meta_data table)
  * and upgrade them
  */
 public function upgradeFieldsMetaDataTable()
 {
     //Get unupgraded address_street fields (fields whose names follow the pattern %_street_c)
     $query = "SELECT id FROM fields_meta_data WHERE type <> 'text' AND deleted = 0 AND name LIKE '%_street_c'";
     $db = DBManagerFactory::getInstance();
     $result = $db->query($query);
     $updatedStreets = array();
     while ($street = $db->fetchByAssoc($result, false)) {
         //Search for a matching city row to add robustness (in case the user created a field named like %_street_c
         //that isn't actually a street address field)
         $uniqueNameIdx = strpos($street['id'], '_street_c');
         $uniqueName = substr($street['id'], 0, $uniqueNameIdx);
         $cityName = $db->quoted($uniqueName . '_city_c');
         $query = "SELECT id FROM fields_meta_data WHERE deleted = 0 AND id = {$cityName}";
         $result2 = $db->query($query);
         $city = $db->fetchByAssoc($result2, false);
         if ($city) {
             $updatedStreets[] = $db->quoted($street['id']);
         }
     }
     $updatedStreets = implode(',', $updatedStreets);
     if (!empty($updatedStreets)) {
         $query = "UPDATE fields_meta_data SET type = 'text', ext3 = 'varchar' WHERE id IN ({$updatedStreets})";
         $db->query($query);
     }
 }

 /**
  * sole constructor
  */
 function CurrencyService()
 {
     global $sugar_config;
     if (!class_exists('DBManagerFactory')) {
     }
     $this->db =& DBManagerFactory::getInstance();
 }

 function display()
 {
     $focus = new PassportList();
     $ss = new Sugar_Smarty();
     $db = DBManagerFactory::getInstance();
     // ONLY LOAD A RECORD IF A RECORD ID IS GIVEN;
     // A RECORD ID IS NOT GIVEN WHEN VIEWING IN LAYOUT EDITOR
     $record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
     $template = file_get_contents('modules/PassportList/tpls/export.tpl');
     $sql = "Select p.name,gp.start_date_group,gp.end_date_group,p.code From passportlist p, groupprograpassportlist_c gpc,groupprograms gp Where p.id = '" . $record . "' And p.id = gpc.groupprogrc66dortlist_idb And gp.id = groupprogr20c9rograms_ida And p.deleted = 0 And gpc.deleted = 0 And gp.deleted = 0";
     $result = $db->query($sql);
     $row = $db->fetchByAssoc($result);
     $template = str_replace("{FIT_RECORE}", $focus->get_passports_list($record), $template);
     $template = str_replace("{TITLE}", $row['name'], $template);
     $template = str_replace("{NGAYBATDAU}", $row['start_date_group'], $template);
     $template = str_replace("{NGAYKETTHUC}", $row['end_date_group'], $template);
     $size = strlen($template);
     $filename = "DANH_SACH_DOAN_" . strtoupper($row['code']) . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
 }