/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$jobs = Job::whereNull('texted_at')->where('job_status_id', '=', JobStatus::$OPEN)->where('start_date', '>=', date("Y-m-d"))->orderBy("start_date")->get();
$catJobs = array();
$users = array();
$userJobs = array();
$userCategories = array();
$user_ids = array();
$jobs->load("jobCategory", "user");
// echo '<pre>';
//print_r($jobs);
//echo '</pre>';
foreach ($jobs as $job) {
if (trim($job->latitude) != "" && trim($job->longitude) != "") {
$userAddresses = Address::select("addresses.*", "student_profile.preferred_job_radius", Address::distanceSelectStatement($job->latitude, $job->longitude, 'distance', 'addresses'))->join("student_profile", "addresses.user_id", "=", "student_profile.user_id")->get();
foreach ($userAddresses as $address) {
if ($address->distance > 0 && $address->distance <= $address->preferred_job_radius) {
//echo "here".$address->distance;
if (!isset($userCategories[$address->user_id])) {
$userCategories[$address->user_id] = StudentJobPreference::where('user_id', '=', $address->user_id)->lists('job_category_id');
}
if (in_array($job->job_category_id, $userCategories[$address->user_id]) == 1) {
if (!isset($userJobs[$address->user_id])) {
$user_ids[] = $address->user_id;
$userJobs[$address->user_id] = array();
$users[$address->user_id] = $address->user;
}
$userJobs[$address->user_id][] = $job;
}
}
}
}
//$job->notified_at=date('Y-m-d h:i:s');
$job->texted_at = date('Y-m-d h:i:s');
$job->save();
}
$c = 0;
if (count($user_ids) > 0) {
$notifications = UserNotification::whereIn('user_id', $user_ids)->where("notification_types_id", '=', NotificationType::$SMS)->get();
foreach ($notifications as $notification) {
$user = $users[$notification->user_id];
//$this->info($user->id);
$c++;
$this->info($notification->notification_value);
$message = View::make('sms.commands.job_notifications');
if (trim($notification->notification_value) != "" && !is_null($notification->notification_value)) {
try {
Twilio::message($notification->notification_value, substr($message, 0, 160));
} catch (Exception $e) {
\Log::info('Error: ' . $e->getMessage());
$this->info('Error: ' . $e->getMessage());
}
}
}
}
\Log::info('Cron Notification Text: ' . $c);
$this->info($c . 'text sent');
}
/**
* Show the form for editing the specified outlet.
*
* @param int $id
* @return Response
*/
public function edit($outlet)
{
$countries = Country::lists('country', 'id');
$cities = City::where('country_id', Country::DEFAULT_COUNTRY)->lists('city', 'id');
$retailers = Retailer::owner()->lists('name', 'id');
$addresses = Address::select(array('addresses.id', 'addresses.address'))->lists('address', 'id');
$images = Picture::getByRefId($outlet->id, 'outlet');
if ($outlet->status == 'active') {
$title = Lang::get('site/outlets/title.outlet_update');
} else {
$title = Lang::get('site/outlets/title.create_a_new_outlet');
}
return View::make('site.outlets.edit', compact('countries', 'cities', 'outlet', 'title', 'retailers', 'addresses'))->nest('imageForm', 'site.partials.image.create', ['refId' => $outlet->id, 'type' => 'outlet', 'images' => $images]);
}
public function index()
{
if (Input::get('q')) {
$id = 1;
$datums = Address::select('city AS value')->where('city', 'like', '%' . Input::get('q') . '%')->distinct()->take(50)->get();
foreach ($datums as $datum) {
//print_r($datum->toArray());
$datum->tokens = explode(' ', $datum->value);
$datum->id = $id;
$id++;
}
return Response::json($datums);
} else {
return Response::json(Address::select('city AS value')->distinct()->orderBy('updated_at', 'DESC')->take(50)->get());
}
}
/**
* Show a list of all the cities formatted for Datatables.
*
* @return Datatables JSON
*/
public function getAddresses($countryId = 0, $cityId = 0)
{
$fields = array('id', 'address', 'district', 'postal_code', 'addresses.created_at', 'addresses.updated_at');
$query = Address::select($fields);
if ($countryId) {
$query = $query->byCountry($countryId);
}
if ($cityId) {
$query = $query->byCity($cityId);
}
$addresses = array_merge(array('0' => 'All'), $query->orderBy('city_id')->lists('address', 'id'));
return $addresses;
}
/**
* 返回更新国家信息
* @access public
*/
function update()
{
$id = get_post_value('id');
$field = array('region_id', 'country_id', 'region', 'status', 'orders');
$m = new Address();
$m->clear();
$m->setField($field);
$m->setTable('vcb_address_region');
$m->setWhere('region_id', '=', $id);
$data = $m->select();
$this->assign('data', $data);
}
/**
* 返回更新国家信息
* @access public
*/
function update()
{
$id = get_post_value('id');
$field = array('country.country_id', 'country.country', 'region.region_id', 'region.region', 'province.province_id', 'province.province', 'city.city_id', 'city.city', 'city.status', 'city.orders');
$m = new Address();
$m->clear();
$m->setField($field);
$m->setWhere('country.status', '!=', '50000');
$m->setWhere('region.status', '!=', '50000');
$m->setWhere('province.status', '!=', '50000');
$m->setWhere('city.status', '!=', '50000');
$m->setWhere('city.city_id', '=', $id);
$m->setTable('vcb_address_country AS country');
$m->setJoin('vcb_address_region as region', 'country.country_id=region.country_id');
$m->setJoin('vcb_address_province as province', 'region.region_id=province.region_id');
$m->setJoin('vcb_address_city as city', 'province.province_id=city.province_id');
$data = $m->select();
$this->assign('data', $data);
$r = $m->getRegion($data[0]['country_id']);
$this->assign('region', $r);
//输出数据
$p = $m->getProvince($data[0]['region_id']);
$this->assign('province', $p);
}
}
});
//=============================================================================
//Address
//=============================================================================
Flight::route('GET /v1/main/address', function () {
try {
$array = Address::selectAll();
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('GET /v1/main/address/@id', function ($id) {
try {
$object = Address::select($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('POST /v1/main/address', function () {
try {
$object = Address::insert();
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/address/@id', function ($id) {
try {
/**
* Show a list of all the cities formatted for Datatables.
*
* @return Datatables JSON
*/
public function getAddresses($countryId = 0, $cityId = 0)
{
$fields = array('addresses.id', 'address', 'district', 'postal_code', 'addresses.created_at', 'addresses.updated_at');
$query = Address::select($fields);
if ($countryId) {
$query = $query->byCountry($countryId);
}
if ($cityId) {
$query = $query->byCity($cityId);
}
$addresses = $query->orderBy('city_id');
return Datatables::of($addresses)->add_column('actions', '<a href="{{{ URL::to(\'admin/addresses/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a>
<a href="{{{ URL::to(\'admin/addresses/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a>
')->remove_column('id')->make();
}
