</p><p style="font-weight: bold;">Still logged in after a password change?</p><p><?php
if (!$employer->isLoggedIn($hash)) {
echo "failed";
exit;
} else {
echo "Yup!";
}
?>
</p><p style="font-weight: bold;">Display the fees I agreed...</p><p><?php
echo "<pre>";
print_r($employer->getFees());
echo "</pre><br><br>";
?>
</p><p style="font-weight: bold;">Get all employers...</p><p><?php
$criteria = array('columns' => 'id');
$result = $employer->find($criteria);
$employers = array();
foreach ($result as $row) {
$employers[] = new Employer($row['id']);
}
$employers_list = array();
$i = 0;
foreach ($employers as $emp) {
$employers_list[$i]['id'] = $emp->getId();
$employers_list[$i]['name'] = $emp->getName();
$branch = $emp->getAssociatedBranch();
$employers_list[$i]['branch'] = $branch[0]['country_name'];
$i++;
}
echo "<pre>";
print_r($employers_list);
public function get_employers()
{
$criteria = array('columns' => 'DISTINCT employers.id, employers.name', 'joins' => 'jobs ON employers.id = jobs.employer', 'order' => 'employers.name ASC');
$employer = new Employer();
return $employer->find($criteria);
}
// fwrite($handle, $message);
// fclose($handle);
}
echo 'ok';
exit;
}
if ($_POST['action'] == 'copy_fees') {
$from_employer = new Employer($_POST['employer']);
$to_employer = new Employer($_POST['id']);
$fees = $from_employer->getFees();
if ($to_employer->createFees($fees) === false) {
echo 'ko';
exit;
}
$criteria = array('columns' => "working_months, payment_terms_days", 'match' => "id = '" . $from_employer->getId() . "'", 'limit' => "1");
$result = $from_employer->find($criteria);
$data = array();
$data['working_months'] = $result[0]['working_months'];
$data['payment_terms_days'] = $result[0]['payment_terms_days'];
$to_employer->update($data);
echo 'ok';
exit;
}
if ($_POST['action'] == 'delete_fee') {
$employer = new Employer();
if ($employer->deleteFee($_POST['id']) === false) {
echo 'ko';
exit;
}
echo 'ok';
exit;
private function get_employers($_employee_branch_id)
{
$criteria = array('columns' => "employers.id, employers.name AS employer, employers.phone_num, \n employers.email_addr, employers.fax_num, employers.contact_person, \n employers.active, \n DATE_FORMAT(employers.joined_on, '%e %b, %Y') AS formatted_joined_on, \n DATE_FORMAT(employer_sessions.first_login, '%e %b, %Y') AS formatted_first_login, \n CONCAT(employees.firstname, ', ', employees.lastname) AS employee", 'joins' => "employer_sessions ON employer_sessions.employer = employers.id, \n employees ON employees.id = employers.registered_by", 'match' => "employees.branch = " . $_employee_branch_id, 'order' => "employers.joined_on DESC");
$employer = new Employer();
return $employer->find($criteria);
}
/**
* Store a newly created job in storage.
*
* @return Response
*/
public function postStore()
{
$data = Input::all();
if ($data["job_category_id"] == "none" || intval($data["job_category_id"]) <= 0) {
$data["job_category_id"] = "";
}
//if($data["job_sub_category_id"]=="none"||intval($data["job_sub_category_id"])<=0)
// $data["job_sub_category_id"]=null;
$newAddressRequiredIf = "address_id,==,0";
$rules = array('job_title' => 'required|min:5|max:150', 'job_description' => 'required|min:10', 'start_date' => 'required|date', 'address_id' => 'required', 'favorites' => 'requiredIfAttribute:private,==,1', 'latitude' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'address1' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'city' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'state' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'zipcode' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'company_or_label' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'compensation' => 'required', 'job_category_id' => 'required');
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$data["start_date"] = date("Y-m-d", strtotime($data["start_date"]));
$user = Sentry::getUser();
$employer = Employer::find($user->getId());
$data["user_id"] = $user->id;
$data['job_status_id'] = $employer->subscription != null && $employer->subscription->activeSubscription() ? JobStatus::$OPEN : JobStatus::$DRAFT;
if ($data["address_id"] <= 0) {
$data["is_primary"] = false;
$data["address_type_id"] = AddressType::$OTHER;
$address = Address::Create($data);
$data["address_id"] = $address->id;
} else {
$address = Address::find($data["address_id"]);
$data['company_or_label'] = $address->company_or_label;
$data['address1'] = $address->address1;
$data['address2'] = $address->address2;
$data['state'] = $address->state;
$data['city'] = $address->city;
$data['zipcode'] = $address->zipcode;
$data['latitude'] = $address->latitude;
$data['longitude'] = $address->longitude;
/* $data=array_merge($data,$address);
if(trim($address['company_or_label'])=='')
$data['company_or_label']='';*/
}
//var_dump($data);
$data['job_description'] = strip_tags($data['job_description']);
if ($data['private']) {
if ($data['job_status_id'] != JobStatus::$DRAFT) {
$data['job_status_id'] = JobStatus::$PRIVATE;
}
}
$job = Job::create($data);
if ($data['private']) {
foreach ($data['favorites'] as $fav) {
JobFavorite::create(array('user_id' => $fav, 'job_id' => $job->id));
if ($data['job_status_id'] != JobStatus::$DRAFT) {
$user = User::find($fav);
$this->NotifyFavorite($user, $job);
}
}
}
if (isset($data['job_certification'])) {
foreach ($data['job_certification'] as $cert) {
JobCertification::create(array('job_id' => $job->id, 'certification_id' => $cert));
}
}
/*$studentAddresses=Address::join('users_groups','users_groups.user_id','=','addresses.user_id')
->join('user_notifications','user_notifications.user_id','=','addresses.user_id')
->where('user_notifications.notification_type','=',NotificationType::$EDUEMAIL)
->where('users_groups.group_id','=',Group::$STUDENT)
->select('addresses.user_id',Address::distanceSelectStatement($data['latitude'],$data['longitude'],'distance','addresses'))
->groupBy('student_job_preferences.user_id')
->having("distance","<=",50)
->get();
$studentProfiles=StudentProfile::join('student_job_preferences', 'student_job_preferences.user_id','=','student_profile.user_id')
->where('student_job_preferences.job_category_id','=',$data["job_category_id"])
->whereIn('student_job_preferences.user_id',$studentAddresses->lists('user_id'))
->groupBy('student_job_preferences.user_id')
->get();
$studentProfiles->load('user');
var_dump($studentProfiles);
*/
if ($data['job_status_id'] == JobStatus::$OPEN) {
//return Redirect::action("JobsController@anyShow", array("id"=>$job->id));
return Redirect::action("JobsController@anyEmployerOpen");
} else {
return Redirect::action("EmployerController@anySubscription");
}
}
</p><p style="font-weight: bold;">Add an employer... </p><p><?php
$employer_id = 'ken123';
$data = array();
$data['password'] = md5('new_password');
$data['license_num'] = 'my license';
$data['name'] = 'Fatt Choy Shopping Center';
$data['phone_num'] = '888 888 888 888';
$data['email_addr'] = '*****@*****.**';
$data['contact_person'] = 'Kenny Lee';
$data['zip'] = '11399';
$data['country'] = 'MY';
$data['registerby'] = 'M';
$id = 0;
$employer = new Employer($employer_id);
if ($employer->create($data)) {
print_array(Employer::find(array('match' => 'id = \'' . $employer->id() . '\'')));
} else {
echo "failed";
exit;
}
?>
</p><p style="font-weight: bold;">Add a stack of employer fees for ken123... </p><p><?php
$fees = array();
$data = array();
$data['employer'] = $employer_id;
$data['service_fee'] = 1.5;
$data['premier_fee'] = 0.0;
$data['discount'] = 0.05;
$data['salary_start'] = 1.0;
$data['salary_end'] = 30000.0;
$fees[0] = $data;
