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;
}
