public function cityAction()
{
$request = Daq_Request::getInstance();
$pattern = $request->get("q");
$country = $request->get("country", 0);
$state = $request->get("state", "");
$query = new Daq_Db_Query();
$query->select("*");
$query->from("Wpjb_Model_Job t");
if ($country > 0) {
$query->where("job_country = ?", $country);
}
if (!empty($state)) {
$query->where("job_state LIKE ?", "%{$state}%");
}
$query->where("job_location LIKE ?", "%{$pattern}%");
$query->group("job_location");
$query->limit(10);
$result = $query->execute();
$arr = array();
foreach ($result as $r) {
$arr[] = $r->job_location;
}
echo join("\r\n", $arr);
exit;
}
public static function render()
{
$list = new Daq_Db_Query();
$list->select("t.payment_currency as curr");
$list->from("Wpjb_Model_Payment t");
$list->where("payment_paid > 0");
$list->group("payment_currency");
$result = $list->fetchAll();
$curr = array();
foreach ($result as $r) {
$c = Wpjb_List_Currency::getCurrency($r->curr);
$curr[$r->curr] = $c["name"];
}
$view = Wpjb_Project::getInstance()->getAdmin()->getView();
/* @var $view Daq_View */
$view->currency = $curr;
$view->render("dashboard/stats.php");
}
