public static function findByName($name) { global $mysqli; $query = 'SELECT * FROM site_permission WHERE name=' . DBObject::prepare_val_for_sql($name); $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new SitePermission(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
static function findByName($name) { global $mysqli; $query = 'SELECT * FROM block WHERE name=' . DBObject::prepare_val_for_sql($name) . ' LIMIT 1'; $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new Block(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
static function findByName($name) { global $mysqli; $query = 'SELECT * FROM vars WHERE name=' . DBObject::prepare_val_for_sql($name); $result = $mysqli->query($query); if ($result && ($v = $result->fetch_object())) { $var = new Vars(); DBObject::importQueryResultToDbObject($v, $var); return $var; } return null; }
public static function findByUId($uid) { global $mysqli; $query = 'SELECT * FROM site_profile WHERE user_id=' . $uid; $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new SiteProfile(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
static function findByCombo($bizid, $mid, $idx, $instance = "WechatArticle") { global $mysqli; $query = "SELECT * FROM wechat_article WHERE biz_id=" . DBObject::prepare_val_for_sql($bizid) . " AND mid=" . DBObject::prepare_val_for_sql($mid) . " AND idx=" . $idx . " LIMIT 1"; $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new $instance(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
static function findAllByCountryId($cid) { global $mysqli; $query = "SELECT * FROM course WHERE country_id={$cid} ORDER BY weight ASC"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Institution(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findByUid($uid) { global $mysqli; $query = 'SELECT * FROM site_user_role WHERE user_id=' . $uid; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new SiteUserRole(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findByAccountId($account_id) { global $mysqli; $query = "SELECT * FROM wechat_account_user WHERE account_id=" . $account_id; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new WechatAccountUser(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAll() { global $mysqli; $query = "SELECT * FROM carousel ORDER BY weight ASC"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Carousel(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllPublished() { global $mysqli; $query = "SELECT * FROM page WHERE published=1"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Page(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
public function getPermissions() { global $mysqli; $query = "SELECT P.* FROM site_permission_role AS PR, site_permission AS P WHERE P.id=PR.permission_id AND PR.role_id=" . $this->getid(); $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new SitePermission(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAll($limit = false) { global $mysqli; $query = "SELECT * FROM news ORDER BY date DESC" . ($limit ? " LIMIT {$limit}" : ""); $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new News(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllByCountryId($cid) { global $mysqli; $query = 'SELECT * FROM menu WHERE country_id=' . DBObject::prepare_val_for_sql($cid); $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Menu(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllByMenuId($menu_id) { global $mysqli; $query = "SELECT * FROM menu_item WHERE menu_id={$menu_id}"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new MenuItem(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllToCrawl($span = 3600) { global $mysqli; $query = "SELECT * FROM wechat_account WHERE active=1 AND (last_scheduled IS NULL OR last_scheduled < " . (time() - $span) . ")"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new WechatAccount(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllWithPage($page, $entries_per_page) { global $mysqli; $user = MySiteUser::getCurrentUser(); $query = "SELECT * FROM user_" . $user->getId() . "_category LIMIT " . ($page - 1) * $entries_per_page . ", " . $entries_per_page; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new UserWechatCategory(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllWithPage($page, $entries_per_page, $company = null) { global $mysqli; $query = "SELECT c.* FROM client AS c"; if ($company) { $query .= " INNER JOIN site_user AS su ON c.user_id=su.id WHERE su.company_id=" . MySiteUser::getCurrentUser()->getCompanyId(); } $query .= " LIMIT " . ($page - 1) * $entries_per_page . ", " . $entries_per_page; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Client(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
public function getRoles() { $urs = SiteUserRole::findByUid($this->getId()); $role_ids = array(); foreach ($urs as $ur) { $role_ids[] = $ur->getRoleId(); } global $mysqli; $query = "SELECT * FROM site_role WHERE id IN (" . implode(',', $role_ids) . ")"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new SiteRole(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllWithPage($page, $entries_per_page) { global $mysqli; $query = "SELECT * FROM course LIMIT " . ($page - 1) * $entries_per_page . ", " . $entries_per_page; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Course(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllWithPage($page, $entries_per_page, $orderby = 'created_at', $order = 'DESC') { global $mysqli; $query = "SELECT * FROM queue ORDER BY {$orderby} {$order} LIMIT " . ($page - 1) * $entries_per_page . ", " . $entries_per_page; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new Queue(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findById($id) { global $mysqli; $query = 'SELECT * FROM user WHERE id=' . $id; $result = $mysqli->query($query); if ($result && ($u = $result->fetch_object())) { $user = new User(); DBObject::importQueryResultToDbObject($u, $user); return $user; } return null; }
static function findAllByCompany($cid) { global $mysqli; $query = "SELECT * FROM site_user WHERE company_id=" . $cid; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new MySiteUser(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
static function findAllWithPage($page, $entries_per_page, $instance = 'SiteUser') { global $mysqli; $query = "SELECT * FROM site_user LIMIT " . ($page - 1) * $entries_per_page . ", " . $entries_per_page; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { if (class_exists('MySiteUser')) { $instance = 'MySiteUser'; } $obj = new $instance(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }
public function getArticles($page = 1, $category = null, $unread = null) { global $mysqli; $user_account_table = 'user_' . $this->getId() . '_account'; $user_category_table = 'user_' . $this->getId() . '_category'; $user_read_table = 'user_' . $this->getId() . '_read'; // where $where = array(); if ($category) { $where[] = " ua.category_id={$category} "; } if (sizeof($where)) { $where = " WHERE " . implode(' AND ', $where) . " "; if ($unread == 1) { $where .= " AND ur.article_id IS NULL "; } } else { $where = ''; if ($unread == 1) { $where = " WHERE ur.article_id IS NULL"; } } // join $join = ""; if ($unread == 1) { $join = " LEFT JOIN {$user_read_table} as ur ON ur.article_id=wa.id "; } // limit $limit = ""; if ($page) { $settings = Vars::getSettings(); $limit = " LIMIT " . ($page - 1) * $settings['articles_per_page'] . ", " . $settings['articles_per_page']; } // order by $order_by = ' ORDER BY wa.published_at DESC '; ///// final query $query = "SELECT wa.*, ua.id AS user_wechat_account_id FROM wechat_article as wa JOIN {$user_account_table} as ua ON ua.account_id=wa.account_id {$join} {$where} {$order_by} {$limit}"; //_debug($query); $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new WechatArticle(); DBObject::importQueryResultToDbObject($b, $obj); $obj->user_wechat_account_id = $b->user_wechat_account_id; $rtn[] = $obj; } return $rtn; }