php - Zend Framework Give 404 Error From Modal -
i have work on https://www.taskguru.co.ke/job/findproscat using zendframework , show 1 user job post, view page multiple job post @ 1 page, when try add foreach loop return 404 error.. see below code , me out of problem...!
controller :
class jobcontroller extends zend_controller_action { public function findproscataction(){ global $objsession ; $this->view->pageheading="hire task guru"; $this->_helper->layout()->setlayout('profilepage'); $sort_by =$this->_getparam('sort_by'); $this->view->sort_by=$sort_by; $jobdata = $this->generalmethod->getallrecordfromleftjoin('jobpost',"users","jobpost.job_postby=users.user_id","1","",""); $this->view->jobdata=$jobdata; if(!$sort_by) { $sort_by=0; } $data = $this->modeljob->getfulltimejoblistpro($jobdata[0],$sort_by); $this->view->data=$data; $this->view->setting = $this->getinviteapro(); } } modal:
public function getfulltimejob($data,$sortby) { $this->_name = 'users'; if($sortby=='1') { $sortval='distance'; } else if($sortby=='2') { $sortval="concat(u.user_first_name,' ',u.user_last_name) asc"; } else if($sortby=='3') { $sortval='q.qualification_passingyear'; } else if($sortby=='4') { $sortval='w.workexperience_position'; } else { $sortval='dt.sub_title'; } $whr=""; if($data['job_degree_more']!='') { $whr=" or q.qualification_oneline in (".$data['job_degree_more'].")"; } $result = $this->getadapter()->select()->from(array('u' => 'users'),array('distance'=>"(((acos(sin((".$data['user_latitude']."*pi()/180)) * sin((`user_latitude`*pi()/180))+cos((".$data['user_latitude']."*pi()/180)) * cos((`user_latitude`*pi()/180)) cos(((".$data['user_longitude']."- `user_longitude`) pi()/180))))*180/pi())*60)","u.user_first_name","u.user_last_name","u.vanity_username","u.user_image","u.user_id","u.company_name")) ->joinleft(array('q' => 'qualification'), 'u.user_id = q.qualification_uid') ->joinleft(array('dt' => 'subdegreetitle'), 'q.qualification_oneline = dt.subtitle_id') ->joinleft(array('d' => 'degree_title'), 'dt.title_id = d.title_id') ->joinleft(array('vq' => 'verified_qualification'), 'q.qualification_id= vq.qualification_id',array("(case when user_iscompany = '0' count(vq.qualification_id) else 4 end) totalvq")) ->joinleft(array('w' => 'workexperience'), 'u.user_id= w.workexperience_uid') ->where("(q.qualification_oneline = '".$data['job_degree']."' ".$whr.") , user_type='1' , go_full_time='1' , q.qualification_status='1'") //->where("user_type='1' , go_full_time='1' , q.qualification_status='1'") ->having("totalvq >= 4"); $result=$result->order($sortval); $result = $result->query()->fetchall(); return $result; } i want run foreach
foreach($jobdata $key =>$val){ $data = $this->modeljob->getfulltimejoblistpro($jobdata[$key],$sort_by); } but unfortunately give 404 error..
plz me...!
Comments
Post a Comment