PHP Application::getDb方法代码示例

 public function delete()
 {
     $db = Application::getDb();
     if ($this->get('id')) {
         return $db->query("DELETE FROM {$this->tableName} WHERE id=?", array($this->get('id')));
     } else {
         return false;
     }
 }

 public function __construct($id = 0)
 {
     $db = Application::getDb();
     if (!empty($id)) {
         $res = $db->fetchRow("select * from {$this->tableName} where id=?", array($id));
     } else {
         $res = '';
     }
     if (!empty($res)) {
         $this->data = $res;
     }
 }

 public function ordersAction()
 {
     $db = Application::getDb();
     $orders = $db->fetchAll('SELECT o.*, od.status, v.lpn, v.model, v.color, v.seats FROM orders_for_driver o LEFT JOIN vehicles v ON v.id=o.vehicle_id LEFT JOIN orders od ON od.sn=o.sn WHERE o.driver_code=? ORDER BY o.when DESC', array($this->code));
     foreach ($orders as &$order) {
         $order['via'] = json_decode($order['via']);
         $order['via_coordinates'] = json_decode($order['via_coordinates']);
     }
     unset($order);
     //$ofd = new Model_OrderForDriver();
     //$orders = $ofd->fetchPagedList(1, 999999, array('driver_code'=>$this->code), '`when` desc')['rows'];
     $this->sendResult($orders);
 }

 public function orderDetailAction()
 {
     $db = Application::getDb();
     $order = $db->fetchRow('SELECT o.*, od.vehicle_id, od.driver_code, od.pickup_coordinates, od.dropoff_coordinates, od.via_coordinates, od.when, v.lpn, v.model, v.color, v.seats FROM orders o LEFT JOIN orders_for_driver od ON od.sn=o.sn LEFT JOIN vehicles v ON v.id=od.vehicle_id WHERE o.sn=?', array($this->sn));
     $order['via'] = json_decode($order['via']);
     $order['via_coordinates'] = json_decode($order['via_coordinates']);
     $driver = new Model_Driver($order['driver_code']);
     $order['driver_name'] = $driver->get('name');
     $order['driver_phone'] = $driver->get('phone');
     //$ofd = new Model_OrderForDriver();
     //$orders = $ofd->fetchPagedList(1, 999999, array('driver_code'=>$this->code), '`when` desc')['rows'];
     $this->sendResult($order);
 }

 function set_params(&$params)
 {
     parent::set_params($params);
     $db = Application::getDb();
     $user = Application::getEntityInstance('user');
     $table = $user->getTableName();
     $keyword = trim($this->getValue('search_keyword'));
     if ($keyword) {
         $skeyword = addslashes($keyword);
         $params['where'][] = "({$table}.name LIKE '%{$keyword}%' OR {$table}.email LIKE '%{$keyword}%' OR {$table}.login LIKE '%{$keyword}%')";
     }
     $role_id = $this->getValue('search_role_id');
     if ($role_id) {
         foreach ($role_id as &$r) {
             $r = (int) $r;
         }
         $coupling_table = $user->getRolesCouplingTableName();
         $role_id = implode(',', $role_id);
         $params['from'][] = "\r\n            \t\tINNER JOIN {$coupling_table} ON {$coupling_table}.user_id={$table}.id AND {$coupling_table}.role_id IN({$role_id})\r\n            \t";
         $params['group_by'][] = "{$table}.id";
     }
 }

 public function run()
 {
     $sql_scripts = coreResourceLibrary::findAll('deploy_db_script', null, null, 'sql');
     ksort($sql_scripts);
     $db = Application::getDb();
     $show_errors_old = $db->getShowErrors();
     $db->setShowErrors(false);
     $db->execute("START TRANSACTION");
     $deploy_succeed = true;
     $executed_this_time = array();
     foreach ($sql_scripts as $script_name => $script_list) {
         if (!$deploy_succeed) {
             continue;
         }
         foreach ($script_list as $script) {
             $script_succeed = true;
             $path = $script->path;
             $sql_errors = array();
             echo "Executing {$path}... ";
             if ($this->wasExecutedBefore($path)) {
                 echo "[SKIPPED]\n";
                 continue;
             }
             $path_abs = coreResourceLibrary::getAbsolutePath($path);
             $script = file_get_contents($path_abs);
             $script = str_replace("\r\n", "\n", $script);
             $bom = pack('H*', 'EFBBBF');
             $script = preg_replace("/^{$bom}/", '', $script);
             $queries = explode(";\n", $script);
             foreach ($queries as $q) {
                 if (!$script_succeed) {
                     continue;
                 }
                 $q = trim($q);
                 if (!$q) {
                     continue;
                 }
                 $query_suceed = (bool) $db->execute($q);
                 if (!$query_suceed) {
                     $sql_errors[] = $db->getLastError();
                 }
                 $script_succeed = $script_succeed && $query_suceed;
             }
             if ($script_succeed) {
                 echo "[OK]\n";
                 $executed_this_time[] = $path;
             } else {
                 echo "[FAILED]\n";
                 echo "Errors:\n" . implode("\n", $sql_errors);
                 $deploy_succeed = false;
             }
         }
     }
     if ($deploy_succeed) {
         foreach ($executed_this_time as $ett) {
             $this->markScriptAsExecuted($ett);
         }
         $db->execute("COMMIT");
     } else {
         $db->execute("ROLLBACK");
     }
     $db->setShowErrors($show_errors_old);
 }

 public static function isEmailExists($email)
 {
     $db = Application::getDb();
     $res = $db->fetchOne("select count(*) from users where email=?", array($email));
     return $res != 0;
 }

 /**
  * Connects to Database
  */
 protected function connect()
 {
     $adapters = Application::getDb();
     $this->slaveAdapter = $adapters['reader'];
     $this->masterAdapter = $adapters['writer'];
 }

 public static function isSnExists($sn)
 {
     $db = Application::getDb();
     $res = $db->fetchOne("select count(*) from {$this->tableName} where sn=?", array($sn));
     return $res != 0;
 }

 public function fetchPagedList($page = 1, $itemsPerPage = 0, array $where = array(), $orderBy = '', array $fields = array(), $sqlNoCache = false)
 {
     $tableName = Db::quoteIdentifier($this->tableName);
     if (empty($fields)) {
         $field = '*';
     } else {
         $cols = array();
         foreach ($fields as $name) {
             $cols[] = Db::quoteIdentifier($name);
         }
         $field = implode(',', $cols);
     }
     if (empty($where)) {
         $where = '';
     } else {
         $where = 'WHERE ' . Db::buildWhere($where);
     }
     if (!empty($orderBy)) {
         $orderBy = 'ORDER BY ' . $orderBy;
     }
     if ($itemsPerPage > 0) {
         $page = intval($page);
         $page < 1 && ($page = 1);
         $offset = ($page - 1) * $itemsPerPage;
         $limit = "LIMIT {$offset},{$itemsPerPage}";
     } else {
         $limit = '';
     }
     if ($sqlNoCache) {
         $sqlNoCache = 'SQL_NO_CACHE';
     } else {
         $sqlNoCache = '';
     }
     $countSql = "SELECT {$sqlNoCache} count(*) FROM {$tableName} {$where}";
     $sql = "SELECT {$sqlNoCache} {$field} FROM {$tableName} {$where} {$orderBy} {$limit}";
     $db = Application::getDb();
     $total = $db->fetchOne($countSql);
     $rows = $db->fetchAll($sql);
     return array('total' => $total, 'rows' => $rows);
 }