PHP offers_filter::createSqlFilter Examples

Example #1

File: freelancer_offers.php Project: Nikitian/fl-ru-damp

 /**
  * Возвращает общее количество предложений
  *
  * @param unknown_type $filter
  * @return unknown
  */
 public function getCountFreelancerOffers($filter = false)
 {
     global $DB;
     $fSql = "";
     if ($filter) {
         $fSql = offers_filter::createSqlFilter($filter, "AND");
     }
     $is_block = $is_admin = "";
     if (!hasPermissions('projects')) {
         $is_block = "AND fo.is_blocked = 'f' AND fo.is_closed = 'f' ";
         $inner_block = "INNER JOIN freelancer f ON  f.uid = fo.user_id AND f.is_banned = B'0'";
     }
     return $DB->cache(300)->val("SELECT COUNT(fo.id) as all_cnt FROM freelance_offers as fo {$inner_block} WHERE 1=1 {$is_block} {$fSql};");
 }