public function isValid($value, $context = null)
{
if (!empty($value)) {
$this->vat = $value;
$countryid = intval($context['country_id']);
if ($countryid == 0) {
$this->_error(self::ISNOTCOUNTRYID);
return false;
}
$country = Countries::find($context['country_id']);
if (!empty($country->code)) {
$this->countryCode = $country->code;
} else {
return false;
}
if (Countries::isITbyId($countryid)) {
if (!is_numeric($value) || strlen($value) != 11) {
$this->_error(self::INVALIDVAT);
return false;
}
} elseif (Countries::isUEbyId($countryid)) {
return $this->eu_check();
}
}
return true;
}
public function indexAction()
{
// set page title
$this->view->pageTitle = 'Countries';
// process get
if ($this->request->isGet()) {
// Current page to show
$currentPage = $this->request->getQuery('page', 'int');
$currentPage = empty($currentPage) ? 1 : $currentPage;
// items per page
$itemsPerPage = $this->request->getQuery('limit', 'int');
$itemsPerPage = empty($itemsPerPage) ? $this->config->application['pagination']['itemsPerPage'] : $itemsPerPage;
// filter
$filter = $this->request->getQuery('filter', 'trim');
// sort
$sortBy = $this->request->getQuery('sort', 'string');
$sortBy = empty($sortBy) ? 'name' : $sortBy;
// direction
$sortDirection = $this->request->getQuery('direction', 'string');
$sortDirection = empty($sortDirection) ? 'asc' : $sortDirection;
} else {
// set defaults
$currentPage = 1;
$itemsPerPage = $this->config->application['pagination']['itemsPerPage'];
$filter = null;
$sortBy = 'name';
$sortDirection = 'desc';
}
// order by
if ($sortBy == 'date') {
$orderBy = 'created ' . strtoupper($sortDirection);
} elseif ($sortBy == 'name') {
$orderBy = 'name ' . strtoupper($sortDirection);
}
// get all user activity logs
if (!empty($filter)) {
// find countries using filter
$country = Countries::find(array('name LIKE :filter:', 'order' => $orderBy, 'bind' => array('filter' => '%' . $filter . '%')));
} else {
$country = Countries::find(array('order' => $orderBy));
}
// Create a Model paginator, show 10 rows by page starting from $currentPage
$paginator = new \Phalcon\Paginator\Adapter\Model(array("data" => $country, "limit" => $itemsPerPage, "page" => $currentPage));
// Get the paginated results
$this->view->page = $paginator->getPaginate();
$this->view->itemsPerPage = $itemsPerPage;
$this->view->filter = $filter;
$this->view->sort = $sortBy;
$this->view->direction = $sortDirection;
$this->view->dropdownLinks = array('edit' => '/country/edit', 'delete' => '/country/delete');
}
/**
* 返回所有国家
* @api /country/
* @return [type] [description]
*/
public function indexAction()
{
$countries = Countries::find();
$requestCnt = array_pick($this->request->getAcceptableContent(), 'accept', true);
if (in_array('application/json', $requestCnt)) {
$response = new Response();
$response->setHeader("Content-Type", "application/json");
echo json_encode($countries->toArray());
$this->view->disable();
} else {
$this->view->setVar('countries', $countries);
$this->view->setVar('title', '世界国家');
}
}
public function imageSearchAction($query = NULL)
{
$this->view->disable();
$this->response->setContentType('application/json', 'UTF-8');
$search = new SearchCategories();
if (isset($query) === false) {
$countries = Countries::find();
} else {
$countries = Countries::find("countryName like '%" . $query . "%'");
}
$search->fromDatabaseObjects($countries, function ($country) use($search) {
$code = $country->getCountryCode();
$description = "Population : " . number_format($country->getPopulation()) . "<br>Capital : " . $country->getCapital();
$image = "https://lipis.github.io/flag-icon-css/flags/4x3/" . strtolower($code) . ".svg";
$search->add(new SearchResult($code, $country->getCountryName(), $description, $image), $country->getContinentName());
});
echo $search->getResponse();
}
public function update_profileAction($id = null)
{
if ($this->request->isPost()) {
$member = Members::findFirstById($this->request->getPost('id'));
$member->modified = date('Y-m-d H:i:s');
$member->first_name = $this->request->getPost('first_name');
$member->last_name = $this->request->getPost('last_name');
$member->street = $this->request->getPost('street');
$member->city = $this->request->getPost('city');
$member->country_id = $this->request->getPost('country_id');
$member->email = $this->request->getPost('email');
$member->mobile = $this->request->getPost('mobile');
if ($member->update()) {
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>You profile has been updated.');
return $this->response->redirect('member/profile/' . $this->request->getPost('id'));
}
}
$member = Members::findFirstById($id);
$this->view->setVar('member', $member);
$countries = Countries::find();
$this->view->setVar('countries', $countries);
}
/**
* Makers list
*/
public function indexAction()
{
$request = $this->request;
$persistent = $this->persistent;
// Reset
$reset = $this->request->getQuery('reset', 'int');
if (isset($reset)) {
$persistent->makersParams = null;
}
// Persistent parameters
if (!is_array($persistent->makersParams)) {
$persistent->makersParams = ['qry' => ['conditions' => "id IS NOT NULL", 'order' => 'updated DESC'], 'sort' => ['page' => 1, 'perpage' => 50]];
}
$parameters = $persistent->makersParams;
$parameters['sort']['perpage'] = isset($parameters['sort']['perpage']) ? $parameters['sort']['perpage'] : 50;
$parameters['sort']['page'] = isset($parameters['sort']['page']) ? $parameters['sort']['page'] : 1;
if ($request->getQuery('page', 'int')) {
$parameters['sort']['page'] = $request->getQuery('page', 'int');
}
if ($request->getQuery('perpage', 'int')) {
$parameters['sort']['perpage'] = $request->getQuery('perpage', 'int');
}
// Search
if ($request->isPost()) {
$parameters['search_region'] = null;
$parameters['search_approved'] = null;
// Placer
if (!empty($_POST['search_region'])) {
$search_region_get = $request->getPost('search_region', 'int');
$parameters['search_region'] = $search_region_get;
$search_region = " AND geo_id = {$search_region_get}";
} else {
$search_region = null;
}
// Name or ID
if (!empty($_POST['search_name'])) {
$search_name_get = $request->getPost('search_name', 'string');
if (preg_match('/^[0-9,\\s]+$/', $request->getPost('search_name', 'string'))) {
$search_split = preg_split('/[,\\s]/', $search_name_get, 0, PREG_SPLIT_NO_EMPTY);
$search_name = implode(', ', $search_split);
$search_name = " AND id IN ({$search_name})";
} else {
$search_name = " AND name LIKE '%{$search_name_get}%'";
}
} else {
$search_name_get = null;
$search_name = null;
}
// Email
if (!empty($_POST['search_email'])) {
$search_email_get = $request->getPost('search_email', 'string');
$search_email = " AND email LIKE '%{$search_email_get}%'";
} else {
$search_email_get = null;
$search_email = null;
}
// Phone
if (!empty($_POST['search_phone'])) {
$search_phone_get = $request->getPost('search_phone', 'string');
$search_phone = " AND phone LIKE '%{$search_phone_get}%' OR phone2 LIKE '%{$search_phone_get}%'";
} else {
$search_phone_get = null;
$search_phone = null;
}
// Approved status
if (!empty($_POST['search_approved'])) {
$search_approved_get = $request->getPost('search_approved', 'int');
$parameters['search_approved'] = $search_approved_get;
$search_approved = " AND approved = {$search_approved_get}";
} else {
$search_approved = null;
}
// Search parameters
$parameters['qry'] = ['conditions' => "id IS NOT NULL\n {$search_region}\n {$search_name}\n {$search_email}\n {$search_phone}\n {$search_approved}"];
}
// Other parameters
$parameters['count'] = PMaker::count($parameters['qry']);
$parameters['qry']['order'] = "updated DESC";
$parameters['qry']['limit'] = 10000;
$persistent->makersParams = $parameters;
// var_dump($parameters);
$makers = PMaker::find($parameters['qry']);
// Paginator
$paginator = new Paginator(["data" => $makers, "limit" => $parameters['sort']['perpage'], "page" => $parameters['sort']['page']]);
$this->view->page = $paginator->getPaginate();
// Set selected search values
$this->view->selected_region = isset($parameters['search_region']) && !empty($parameters['search_region']) ? $parameters['search_region'] : null;
$this->view->selected_approved = isset($parameters['search_approved']) && !empty($parameters['search_approved']) ? $parameters['search_approved'] : null;
$this->view->makers_count = $parameters['count'];
// All regions
$this->view->regions_list = array_column(Geo::find(['order' => 'title ASC'])->toArray(), 'title', 'id');
// Currencies
$currencies_array = array_column(PCrosscurrency::find()->toArray(), 'title', 'title');
$this->view->currencies_list = ['UAH' => $currencies_array['UAH']] + $currencies_array;
// Countries
$countries_array = array_column(Countries::find("active=1")->toArray(), 'title', 'id');
$ukraine = array_search('Украина', $countries_array);
$this->view->countries_list = [$ukraine => $countries_array[$ukraine]] + $countries_array;
$this->view->users_list = Accounts::getUsersByRole(['researcher', 'mobilegroup'], false, 'name ASC');
$this->view->can_edit = AccRoles::findFirst("user_id={$this->auth->id} AND (role_id=991 OR role_id=5)");
}
public function update_businessAction($businessId = null)
{
$business = Business::findFirst($businessId);
if (!$business) {
return $this->response->redirect('biz/business_search');
}
if ($this->request->isPost()) {
$countryId = $this->request->getPost('country_id');
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'id LIKE :id:', 'bind' => array('id' => $countryId)));
$countryName = '';
if ($country) {
$countryName = $country->country;
}
$address = str_replace(' ', '+', $this->request->getPost('street') . '+' . $this->request->getPost('city') . '+' . $countryName);
$userSession = $this->session->get("userSession");
$content = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=AIzaSyAbpLPfBH8sNdVSzMULD_BZN9qrAqbL3V8');
$json = json_decode($content, true);
$lat = $json['results'][0]['geometry']['location']['lat'];
$lng = $json['results'][0]['geometry']['location']['lng'];
$business->modified = date('Y-m-d H:i:s');
$business->member_id = $userSession['id'];
$business->name = $this->request->getPost('name');
$business->website = $this->request->getPost('website');
$business->telephone = $this->request->getPost('telephone');
$business->street = $this->request->getPost('street');
$business->city = $this->request->getPost('city');
$business->country_id = $this->request->getPost('country_id');
$business->lat = $lat;
$business->lng = $lng;
$opened = '';
if (!empty($this->request->getPost('opened'))) {
$opened = 'Opened';
}
if (empty($this->request->getPost('opened'))) {
$opened = 'Opening Soon';
}
$business->opened = $opened;
if ($business->update()) {
if (!empty($this->request->getPost('business_category_ids'))) {
$bCtegories = $this->request->getPost('business_category_ids');
$bCtegoryIds = explode(',', $bCtegories);
BusinessCategoryLists::find('business_id="' . $businessId . '"')->delete();
foreach ($bCtegoryIds as $key => $bCtegoryId) {
$businessCategoryLists = new BusinessCategoryLists();
$businessCategoryLists->created = date('Y-m-d H:i:s');
$businessCategoryLists->business_id = $businessId;
$businessCategoryLists->business_category_id = $bCtegoryId;
$businessCategoryLists->create();
}
}
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>Business has been updated');
return $this->response->redirect('business/view/' . $businessId);
}
}
$this->view->setVar('business', $business);
$countries = Countries::find();
$this->view->setVar('countries', $countries);
$businessCategoryLists = BusinessCategoryLists::find('business_id="' . $businessId . '"');
$this->view->setVar('businessCategoryLists', $businessCategoryLists);
}
public function updateAction($id = null)
{
if ($this->request->isPost()) {
$id = $this->request->getPost('id');
$countryId = $this->request->getPost('country_id');
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'id LIKE :id:', 'bind' => array('id' => $countryId)));
$countryName = '';
if ($country) {
$countryName = $country->country;
}
$address = str_replace(' ', '+', $this->request->getPost('street') . '+' . $this->request->getPost('city') . '+' . $countryName);
$userSession = $this->session->get("userSession");
$content = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=AIzaSyAbpLPfBH8sNdVSzMULD_BZN9qrAqbL3V8');
$json = json_decode($content, true);
$lat = $json['results'][0]['geometry']['location']['lat'];
$lng = $json['results'][0]['geometry']['location']['lng'];
//error_log('LAT : '.$lat.' LONG : '.$lng);
$property = Realties::findFirst($id);
$property->modified = date('Y-m-d H:i:s');
$property->member_id = $userSession['id'];
$property->name = $this->request->getPost('name');
$property->details = $this->request->getPost('details');
$property->price = str_replace(',', '', $this->request->getPost('price'));
$property->street = $this->request->getPost('street');
$property->city = $this->request->getPost('city');
$property->country_id = $this->request->getPost('country_id');
$property->lat = $lat;
$property->lng = $lng;
$property->realty_condition_id = $this->request->getPost('realty_condition_id');
$property->realty_category_id = $this->request->getPost('realty_category_id');
$property->realty_type_id = $this->request->getPost('realty_type_id');
$property->house_area = $this->request->getPost('house_area');
$property->lot_area = $this->request->getPost('lot_area');
$property->bedrooms = $this->request->getPost('bedrooms');
$property->bathrooms = $this->request->getPost('bathrooms');
$property->parking = $this->request->getPost('parking');
$property->pets_allowed = $this->request->getPost('pets_allowed');
if ($property->update()) {
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New property has been updated');
for ($i = 1; $i <= 7; $i++) {
$fileId = $this->request->getPost('fileId' . $i);
if (!empty($fileId)) {
$realtyPhotos = RealtyPhotos::findFirst($fileId);
$realtyPhotos->created = date('Y-m-d H:i:s');
$realtyPhotos->modified = date('Y-m-d H:i:s');
$realtyPhotos->member_id = $userSession['id'];
$realtyPhotos->caption = $this->request->getPost('caption' . $i);
$realtyPhotos->update();
}
}
if ($this->request->hasFiles() == true) {
//ini_set('upload_max_filesize', '64M');
set_time_limit(1200);
$uploads = $this->request->getUploadedFiles();
$isUploaded = false;
#do a loop to handle each file individually
foreach ($uploads as $upload) {
$imageName = $upload->getKey();
//$this->request->getPost('image'.$ctr);
$inputRow = str_replace('image', '', $imageName);
$fileId = $this->request->getPost('fileId' . $inputRow);
#define a “unique” name and a path to where our file must go
$fileName = $upload->getName();
$fileInfo = new SplFileInfo($fileName);
$fileExt = $fileInfo->getExtension();
$fileExt = strtolower($fileExt);
$newFileName = substr(md5(uniqid(rand(), true)), 0, 10) . date('ymdhis') . '.' . $fileExt;
//$fileExt = $upload->getExtension();
$fileImageExt = array('jpeg', 'jpg', 'png');
$fileType = '';
$filePath = '';
$path = '';
if (in_array($fileExt, $fileImageExt)) {
$path = 'img/realty/' . $newFileName;
$filePath = 'img/realty/';
//$fileType = 'Image';
}
#move the file and simultaneously check if everything was ok
$upload->moveTo($path) ? $isUploaded = true : ($isUploaded = false);
if ($isUploaded) {
if (!empty($fileId)) {
$realtyPhotos = RealtyPhotos::findFirst($fileId);
$realtyPhotos->modified = date('Y-m-d H:i:s');
$realtyPhotos->member_id = $userSession['id'];
$realtyPhotos->file_path = $filePath;
$realtyPhotos->filename = $newFileName;
$realtyPhotos->update();
} else {
$realtyPhotos = new RealtyPhotos();
$realtyPhotos->created = date('Y-m-d H:i:s');
$realtyPhotos->modified = date('Y-m-d H:i:s');
$realtyPhotos->member_id = $userSession['id'];
$realtyPhotos->realty_id = $id;
$realtyPhotos->file_path = $filePath;
$realtyPhotos->filename = $newFileName;
$realtyPhotos->caption = $this->request->getPost('caption' . $inputRow);
$realtyPhotos->create();
}
}
}
#if any file couldn't be moved, then throw an message
}
return $this->response->redirect('real_estate/view/' . $id);
}
}
$property = Realties::findFirst($id);
if (!$property) {
return $this->response->redirect('real_estate/index');
}
$this->view->setVar('property', $property);
$realtyPhotos = RealtyPhotos::find('realty_id ="' . $id . '"');
$this->view->setVar('realtyPhotos', $realtyPhotos);
$countries = Countries::find();
$this->view->setVar('countries', $countries);
$realtyConditions = RealtyConditions::find();
$this->view->setVar('realtyConditions', $realtyConditions);
$realtyTypes = RealtyTypes::find();
$this->view->setVar('realtyTypes', $realtyTypes);
$realtyCategories = RealtyCategories::find();
$this->view->setVar('realtyCategories', $realtyCategories);
}
public function newAction()
{
if ($this->request->isPost()) {
$messages = $this->formValidate();
if (count($messages)) {
$this->view->disable();
$errorMsg = '';
foreach ($messages as $msg) {
$errorMsg .= $msg . "<br>";
}
$this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>' . $errorMsg);
return $this->response->redirect('event/new/');
} else {
$this->view->disable();
echo "validation is either failed or passed";
}
$userSession = $this->session->get("userSession");
$eventName = $this->request->getPost("name");
$website = $this->request->getPost("website");
$telephone = $this->request->getPost("telephone");
$street = $this->request->getPost("street");
$city = $this->request->getPost("city");
$info = $this->request->getPost("event_info");
$category = $this->request->getPost("category");
$country = $this->request->getPost("country");
$raw_address = $this->request->getPost("address");
$latitude = $this->request->getPost("lat");
$longitude = $this->request->getPost("lng");
$dates = $this->request->getPost("date");
$fromTimes = $this->request->getPost("fromTime");
$toTimes = $this->request->getPost("toTime");
$event = new Events();
$event->created = date('Y-m-d H:i:s');
$event->modified = date('Y-m-d H:i:s');
$event->member_id = $userSession['id'];
$event->name = $eventName;
$event->event_date = $this->request->getPost("date");
$event->website = $website;
$event->telephone = $telephone;
$event->street = $street;
$event->city = $city;
$event->country_id = $country;
$event->event_category_id = $category;
$event->lng = $longitude;
$event->lat = $latitude;
$event->eventinfo = $info;
if ($event->create()) {
$id = $event->id;
$i = 0;
foreach ($dates as $date) {
$eventDatetime = new EventDatetimes();
$eventDatetime->event_id = $id;
$eventDatetime->date = $date;
$eventDatetime->from_time = $fromTimes[$i];
$eventDatetime->to_time = $toTimes[$i];
$i++;
if (!$eventDatetime->create()) {
$this->view->disable();
echo "failed to insert event date and time in event_datetimes table. :(";
}
}
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New event has been posted');
if ($this->request->hasFiles() == true) {
$uploads = $this->request->getUploadedFiles();
$isUploaded = false;
$ctr = 1;
foreach ($uploads as $upload) {
# define a "unique" name and a path to where our file must go
$fileName = $upload->getname();
$fileInfo = new SplFileInfo($fileName);
$fileExt = $fileInfo->getExtension();
$fileExt = strtolower($fileExt);
$newFileName = substr(md5(uniqid(rand(), true)), 0, 10) . date('ymdhis') . '.' . $fileExt;
$fileImageExt = array('jpeg', 'jpg', 'png');
$fileType = '';
$filePath = '';
$path = '';
if (in_array($fileExt, $fileImageExt)) {
$path = 'img/event/' . $newFileName;
$filePath = 'img/event/';
//$fileType = 'Image';
}
# move the file and simultaneously check if everything was ok
$upload->moveTo($path) ? $isUploaded = true : ($isUploaded = false);
if ($isUploaded) {
$eventPhotos = new EventPhotos();
$eventPhotos->created = date('Y-m-d H:i:s');
$eventPhotos->modified = date('Y-m-d H:i:s');
$eventPhotos->member_id = $userSession['id'];
$eventPhotos->event_id = $id;
$eventPhotos->file_path = $filePath;
$eventPhotos->filename = $newFileName;
$eventPhotos->caption = $this->request->getPost('caption');
//$ctr++;
if ($eventPhotos->create()) {
echo "success";
} else {
$this->view->disable();
print_r($eventPhotos->getMessages());
}
}
}
}
} else {
$this->view->disable();
print_r($event->getMessages());
}
return $this->response->redirect('event/view/' . $id);
}
$events = Events::find();
$categories = EventsCategories::find();
$countries = Countries::find();
$this->view->setVar('events', $events);
$this->view->setVars(['events' => $events, 'categories' => $categories, 'countries' => $countries]);
}
public function updateAction($id = null)
{
if ($this->request->isPost()) {
$id = $this->request->getPost('id');
$userSession = $this->session->get("userSession");
$jobs = Jobs::findFirst($id);
$jobs->modified = date('Y-m-d H:i:s');
$jobs->member_id = $userSession['id'];
$jobs->position = $this->request->getPost('position');
$jobs->job_category_id = $this->request->getPost('job_category_id');
$jobs->job_description = $this->request->getPost('job_description');
$jobs->requirements = $this->request->getPost('requirements');
$jobs->benefits = $this->request->getPost('benefits');
$jobs->salary_from = $this->request->getPost('salary_from');
$jobs->salary_to = $this->request->getPost('salary_to');
$jobs->company = $this->request->getPost('company');
$jobs->website = $this->request->getPost('website');
$jobs->telephone = $this->request->getPost('telephone');
$jobs->email = $this->request->getPost('email');
$jobs->street = $this->request->getPost('street');
$jobs->city = $this->request->getPost('city');
$jobs->country_id = $this->request->getPost('country_id');
$jobs->how_to_apply = $this->request->getPost('how_to_apply');
if ($jobs->update()) {
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New job has been updated');
if ($this->request->hasFiles() == true) {
set_time_limit(1200);
$uploads = $this->request->getUploadedFiles();
$isUploaded = false;
#do a loop to handle each file individually
foreach ($uploads as $upload) {
#define a “unique” name and a path to where our file must go
$fileName = $upload->getname();
$fileInfo = new SplFileInfo($fileName);
$fileExt = $fileInfo->getExtension();
$fileExt = strtolower($fileExt);
$newFileName = substr(md5(uniqid(rand(), true)), 0, 10) . date('ymdhis') . '.' . $fileExt;
//$fileExt = $upload->getExtension();
$fileImageExt = array('jpeg', 'jpg', 'png');
//error_log("File Extension :".$fileExt, 0);
$fileType = '';
$filePath = '';
$path = '';
//$path = ''.$newFileName;
if (in_array($fileExt, $fileImageExt)) {
$path = 'img/job/' . $newFileName;
$filePath = 'img/job/';
//$fileType = 'Image';
}
#move the file and simultaneously check if everything was ok
$upload->moveTo($path) ? $isUploaded = true : ($isUploaded = false);
}
#if any file couldn't be moved, then throw an message
if ($isUploaded) {
$jobLogo = JobLogos::findFirst('job_id="' . $id . '"');
if ($jobLogo) {
//delete previous logo first
unlink($jobLogo->file_path . $jobLogo->filename);
$jobLogo->created = date('Y-m-d H:i:s');
$jobLogo->modified = date('Y-m-d H:i:s');
$jobLogo->member_id = $userSession['id'];
$jobLogo->job_id = $id;
$jobLogo->file_path = $filePath;
$jobLogo->filename = $newFileName;
if ($jobLogo->update()) {
}
//before saving the new one
} else {
$jobLogo = new JobLogos();
$jobLogo->created = date('Y-m-d H:i:s');
$jobLogo->modified = date('Y-m-d H:i:s');
$jobLogo->member_id = $userSession['id'];
$jobLogo->job_id = $id;
$jobLogo->file_path = $filePath;
$jobLogo->filename = $newFileName;
if ($jobLogo->create()) {
}
}
}
}
return $this->response->redirect('job/view/' . $id);
}
}
$this->view->setVar('job', Jobs::findFirst($id));
$countries = Countries::find();
$this->view->setVar('countries', $countries);
$jobCategories = JobCategories::find();
$this->view->setVar('jobCategories', $jobCategories);
$jobLogo = JobLogos::findFirst('job_id="' . $id . '"');
if ($jobLogo) {
$jobLogo = $jobLogo->file_path . $jobLogo->filename;
} else {
$jobLogo = 'http://placehold.it/200x200';
}
$this->view->setVar('jobLogo', $jobLogo);
}
public function admin_addAction()
{
if ($this->request->isPost()) {
$error = 0;
// if($this->security->checkToken() == false){
// $error = 1;
// $this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>Invalid CSRF Token');
// return $this->response->redirect('signup');
// }
$firstName = $this->request->getPost('first_name');
$middleName = $this->request->getPost('middle_name');
$lastName = $this->request->getPost('last_name');
$street = $this->request->getPost('street');
$city = $this->request->getPost('city');
$country_id = $this->request->getPost('country_id');
$mobile = $this->request->getPost('mobile');
$email = $this->request->getPost('email');
$password = $this->request->getPost('password');
if (empty($firstName) || empty($lastName) || empty($email) || empty($password)) {
$this->flash->warning('<button type="button" class="close" data-dismiss="alert">×</button>All fields required');
return $this->response->redirect();
}
if (!empty($email) && Users::findFirstByEmail($email)) {
$errorMsg = "Email is already in use. Please try again.";
$this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>' . $errorMsg);
return $this->response->redirect();
}
$user = new Users();
$user->created = date('Y-m-d H:i:s');
$user->modified = date('Y-m-d H:i:s');
$user->first_name = $firstName;
$user->middle_name = $middleName;
$user->last_name = $lastName;
$user->mobile = $mobile;
$user->street = $street;
$user->city = $city;
$user->country_id = $country_id;
$user->email = $email;
$user->password = $this->security->hash($password);
if ($user->create()) {
$activationToken = substr(str_shuffle('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 0, 50);
$emailConfimation = new EmailConfirmations();
$emailConfimation->created = date('Y-m-d H:i:s');
$emailConfimation->modified = date('Y-m-d H:i:s');
$emailConfimation->user_id = $user->id;
$emailConfimation->email = $email;
$emailConfimation->token = $activationToken;
$emailConfimation->confirmed = 'N';
if ($emailConfimation->save()) {
$this->getDI()->getMail()->send(array($email => $firstName . ' ' . $lastName), 'Please confirm your email', 'confirmation', array('confirmUrl' => 'admin/user/emailConfimation/' . $user->id . '/' . $email . '/' . $activationToken));
}
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>You\'ve successfully created a MyBarangay account. We sent a confirmation email to ' . $email . '.');
} else {
//print_r($user->getMessages());
$this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>Registration failed. Please try again.');
}
return $this->response->redirect();
}
$countries = Countries::find();
$this->view->setVar('countries', $countries);
}
public function new_eventAction()
{
if ($this->request->isPost()) {
$countryId = $this->request->getPost('country_id');
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'id LIKE :id:', 'bind' => array('id' => $countryId)));
$countryName = '';
if ($country) {
$countryName = $country->country;
}
$address = str_replace(' ', '+', $this->request->getPost('street') . '+' . $this->request->getPost('city') . '+' . $countryName);
$userSession = $this->session->get("userSession");
$content = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=AIzaSyAbpLPfBH8sNdVSzMULD_BZN9qrAqbL3V8');
$json = json_decode($content, true);
$lat = $json['results'][0]['geometry']['location']['lat'];
$lng = $json['results'][0]['geometry']['location']['lng'];
//error_log('LAT : '.$lat.' LONG : '.$lng);
$events = new Events();
$events->created = date('Y-m-d H:i:s');
$events->modified = date('Y-m-d H:i:s');
$events->member_id = $userSession['id'];
$events->name = $this->request->getPost('name');
$events->website = $this->request->getPost('website');
$events->telephone = $this->request->getPost('telephone');
$events->street = $this->request->getPost('street');
$events->city = $this->request->getPost('city');
$events->country_id = $this->request->getPost('country_id');
$events->lat = $lat;
$events->lng = $lng;
$events->event_date = $this->request->getPost('eventdate');
$events->event_category_id = $this->request->getPost('event_category_id');
$events->eventinfo = $this->request->getPost('eventinfo');
if ($events->create()) {
$id = $events->id;
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New event has been created');
if (!empty($this->request->getPost('review'))) {
$review = new Reviews();
$review->created = date('Y-m-d H:i:s');
$review->modified = date('Y-m-d H:i:s');
$review->member_id = $userSession['id'];
$review->event_id = $events->id;
$review->content = $this->request->getPost('review');
$review->rate = $this->request->getPost('rate');
if ($review->create()) {
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>You\'re review has been submitted.');
}
}
return $this->response->redirect('events/view/' . $id);
}
}
$countries = Countries::find();
$this->view->setVar('countries', $countries);
$eventsCategories = EventsCategories::find();
$this->view->setVar('eventsCategories', $eventsCategories);
}
public function updateAction($id = null)
{
$member = Members::findFirstById($id);
$userSession = $this->session->get('userSession');
if (!$member || $userSession['id'] != $member->id) {
$this->response->redirect('member/upload_photo/' . $userSession['id']);
}
$oldEmail = $member->email;
$this->view->setVar('member', $member);
if ($this->request->isPost()) {
$member = Members::findFirstById($this->request->getPost('id'));
$member->modified = date('Y-m-d H:i:s');
$member->first_name = $this->request->getPost('first_name');
$member->last_name = $this->request->getPost('last_name');
$member->street = $this->request->getPost('street');
$member->city = $this->request->getPost('city');
$member->country_id = $this->request->getPost('country_id');
$member->email = $this->request->getPost('email');
$member->mobile = $this->request->getPost('mobile');
//email cookie
if (!empty($this->request->getPost('email'))) {
$cookie_name = "e";
$cookie_value = $this->request->getPost('email');
setcookie($cookie_name, $this->encrypt($cookie_value), $date_of_expiry, "/");
}
if ($member->update()) {
if ($oldEmail != $this->request->getPost('email')) {
$activationToken = substr(str_shuffle('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 0, 50);
$emailConfimation = new EmailConfirmations();
$emailConfimation->created = date('Y-m-d H:i:s');
$emailConfimation->modified = date('Y-m-d H:i:s');
$emailConfimation->user_id = $member->id;
$emailConfimation->email = $this->request->getPost('email');
$emailConfimation->token = $activationToken;
$emailConfimation->confirmed = 'N';
if ($emailConfimation->save()) {
$this->getDI()->getMail()->send(array($this->request->getPost('email') => $member->first_name . ' ' . $member->last_name), 'Please confirm your email', 'email_update_confirmation', array('confirmUrl' => 'member/emailConfimation/' . $member->id . '/' . $this->request->getPost('email') . '/' . $activationToken));
}
}
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>You profile has been updated.');
return $this->response->redirect('member/page/' . $this->request->getPost('id'));
}
}
$countries = Countries::find();
$this->view->setVar('countries', $countries);
}
public function updateAction($id = null)
{
if ($this->request->isPost()) {
$id = $this->request->getPost('id');
$userSession = $this->session->get("userSession");
$jobs = Jobs::findFirst($id);
$jobs->modified = date('Y-m-d H:i:s');
$jobs->member_id = $userSession['id'];
$jobs->position = $this->request->getPost('position');
$jobs->job_category_id = $this->request->getPost('job_category_id');
$jobs->job_description = $this->request->getPost('job_description');
$jobs->requirements = $this->request->getPost('requirements');
$jobs->benefits = $this->request->getPost('benefits');
$jobs->salary_from = $this->request->getPost('salary_from');
$jobs->salary_to = $this->request->getPost('salary_to');
$jobs->company = $this->request->getPost('company');
$jobs->website = $this->request->getPost('website');
$jobs->telephone = $this->request->getPost('telephone');
$jobs->email = $this->request->getPost('email');
$jobs->street = $this->request->getPost('street');
$jobs->city = $this->request->getPost('city');
$jobs->country_id = $this->request->getPost('country_id');
$jobs->how_to_apply = $this->request->getPost('how_to_apply');
if ($jobs->update()) {
$id = $jobs->id;
$this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New job has been updated');
return $this->response->redirect('job/view/' . $id);
}
}
$this->view->setVar('job', Jobs::findFirst($id));
$countries = Countries::find();
$this->view->setVar('countries', $countries);
$jobCategories = JobCategories::find();
$this->view->setVar('jobCategories', $jobCategories);
}
/**
* View all orders
*/
public function indexAction()
{
$request = $this->request;
$response = $this->response;
$persistent = $this->persistent;
// Reset
$reset = $this->request->getQuery('reset', 'int');
if (isset($reset)) {
$persistent->searchOrderParams = null;
}
// Persistent parameters
if (!is_array($persistent->searchOrderParams)) {
$persistent->searchOrderParams = ['qry' => ['conditions' => "id IS NOT NULL", 'order' => 'created DESC'], 'sort' => ['page' => 1, 'perpage' => 50, 'sortField' => 'created', 'sortOrder' => 'DESC']];
}
$parameters = $persistent->searchOrderParams;
$parameters['sort']['perpage'] = isset($parameters['sort']['perpage']) ? $parameters['sort']['perpage'] : 50;
$parameters['sort']['page'] = isset($parameters['sort']['page']) ? $parameters['sort']['page'] : 1;
if ($request->getQuery('sort', 'string')) {
$parameters['sort']['sortField'] = $request->getQuery('sort', 'string');
$parameters['sort']['sortOrder'] = $request->getQuery('order', 'string');
}
if ($request->getQuery('page', 'int')) {
$parameters['sort']['page'] = $request->getQuery('page', 'int');
}
if ($request->getQuery('perpage', 'int')) {
$parameters['sort']['perpage'] = $request->getQuery('perpage', 'int');
}
$sortField = $parameters['sort']['sortField'];
$sortOrder = $parameters['sort']['sortOrder'];
// If this is a post request
if ($request->isPost()) {
$parameters['search_id'] = null;
$parameters['search_country'] = null;
$parameters['search_currency'] = null;
$parameters['search_status'] = null;
$parameters['search_date_from'] = null;
$parameters['search_date_to'] = null;
$parameters['search_active'] = null;
// ID
if (!empty($_POST['search_id'])) {
$search_id_get = $request->getPost('search_id');
if (preg_match('/^\\d+$/', $search_id_get)) {
$search_id = " AND id = {$search_id_get}";
} elseif (preg_match('/@/', $search_id_get)) {
$search_id = " AND email LIKE '%{$search_id_get}%'";
} else {
$search_id = null;
}
$parameters['search_id'] = $search_id_get;
} else {
$search_id = null;
}
// Country
if (!empty($_POST['search_country'])) {
$search_country_get = $request->getPost('search_country', 'int');
$parameters['search_country'] = $search_country_get;
$search_country = " AND countries_id = {$search_country_get}";
} else {
$search_country = null;
}
// Currency
if (!empty($_POST['search_currency'])) {
$search_currency_get = $request->getPost('search_currency', 'string');
$parameters['search_currency'] = $search_currency_get;
$search_currency = " AND currency = '{$search_currency_get}'";
} else {
$search_currency = null;
}
// Status
if (!empty($_POST['search_status'])) {
$search_status_get = $request->getPost('search_status', 'string');
$parameters['search_status'] = $search_status_get;
switch ($search_status_get) {
case 'y':
$search_status = " AND payed = 1";
break;
case 'n':
$search_status = " AND payed = 0";
break;
case 'c':
$search_status = " AND cancelled = 1";
break;
}
} else {
$search_status = null;
}
// Date from
if (!empty($_POST['search_date_from'])) {
$search_date_from_get = strtotime($request->getPost('search_date_from', 'string'));
$parameters['search_date_from'] = $search_date_from_get;
$search_date_from = " AND created > {$search_date_from_get}";
} else {
$search_date_from = null;
}
// Date to
if (!empty($_POST['search_date_to'])) {
$search_date_to_get = strtotime($request->getPost('search_date_to', 'string')) + 86399;
$parameters['search_date_to'] = $search_date_to_get;
$search_date_to = " AND created < {$search_date_to_get}";
} else {
$search_date_to = null;
}
// Active
if (!empty($_POST['search_active'])) {
$search_active_get = (int) $request->getPost('search_active', 'int');
$parameters['search_active'] = $search_active_get;
$search_active = " AND deactivated IS NULL OR deactivated = 0";
} else {
$search_active = null;
}
// Search parameters
$parameters['qry'] = ['conditions' => "id IS NOT NULL\n {$search_id}\n {$search_country}\n {$search_currency}\n {$search_status}\n {$search_date_from}\n {$search_date_to}\n {$search_active}"];
}
// Other parameters
$parameters['count'] = POrder::count($parameters['qry']);
$parameters['qry']['order'] = "{$sortField} {$sortOrder}";
$parameters['qry']['limit'] = 1000;
$persistent->searchOrderParams = $parameters;
// var_dump($parameters);
// Find all products according to set parameters
$orders = POrder::find($parameters['qry']);
// Paginator
$paginator = new Paginator(["data" => $orders, "limit" => $parameters['sort']['perpage'], "page" => $parameters['sort']['page']]);
// Sorting and table headers mapping
$headMapping = ['id' => 'Номер', 'created' => 'Дата', 'firstName' => 'Имя', 'lastName' => 'Фамилия', '__country' => 'Страна', 'price' => 'Сумма', 'currency' => 'Валюта', '__payed' => 'Статус', 'paySystem' => 'Способ оплаты'];
// Sorting header and order arrow
$headings = array();
foreach ($headMapping as $field => $name) {
$headings[$field] = ['field' => $field, 'name' => $name, 'sort' => $sortField == $field ? $sortOrder == 'desc' ? 'asc' : 'desc' : false, 'arrow' => $sortField == $field ? $sortOrder == 'desc' ? ' ↓' : ' ↑' : false];
}
$this->view->headings = $headings;
$this->view->page = $paginator->getPaginate();
// Show total count
$this->view->count = $parameters['count'];
// Set selected search values
$this->view->selected_id = isset($parameters['search_id']) && !empty($parameters['search_id']) ? $parameters['search_id'] : null;
$this->view->selected_country = isset($parameters['search_country']) && !empty($parameters['search_country']) ? $parameters['search_country'] : null;
$this->view->selected_currency = isset($parameters['search_currency']) && !empty($parameters['search_currency']) ? $parameters['search_currency'] : null;
$this->view->selected_status = isset($parameters['search_status']) && !empty($parameters['search_status']) ? $parameters['search_status'] : null;
$this->view->selected_date_from = isset($parameters['search_date_from']) && !empty($parameters['search_date_from']) ? $parameters['search_date_from'] : null;
$this->view->selected_date_to = isset($parameters['search_date_to']) && !empty($parameters['search_date_to']) ? $parameters['search_date_to'] : null;
$this->view->selected_active = isset($parameters['search_active']) && !empty($parameters['search_active']);
// List of countries
$this->view->countries = array_column(Countries::find(['order' => 'title'])->toArray(), 'title', 'id');
// List of currencies
$this->view->currencies = array_column(PCrosscurrency::find(['conditions' => 'siteswitcher != 0', 'order' => 'siteswitcher'])->toArray(), 'title', 'title');
}
/**
* Show the POTS form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function doSave()
{
$validator = Validator::make(Input::all(), Countries::$rules);
if ($validator->passes()) {
$id = Input::get('id');
if (isset($id) && $id > 0) {
$country = Countries::find($id);
} else {
$country = new Countries();
}
$country->name = Input::get('name');
$country->description = Input::get('description');
$country->user_id = Auth::user()->id;
$country->save();
return Redirect::route('country-list')->with('message', 'Country has been added/changed.');
} else {
return Redirect::route('country-edit')->with('message', 'The following errors occurred')->withErrors($validator)->withInput();
}
}
