PHP JobPeer::doSelect方法代码示例

 public static function retrieveByCode($code, $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(self::DATABASE_NAME);
     }
     $criteria = new Criteria(JobPeer::DATABASE_NAME);
     $criteria->add(JobPeer::CODE, $code);
     $v = JobPeer::doSelect($criteria, $con);
     return !empty($v) > 0 ? $v[0] : null;
 }

 public static function getJobsForAutocomplete($q)
 {
     sfContext::getInstance()->getConfiguration()->loadHelpers('Url');
     $c = new Criteria();
     $crit0 = $c->getNewCriterion(JobPeer::EVENT, $q . '%', Criteria::LIKE);
     $crit1 = $c->getNewCriterion(JobPeer::ID, $q . '%', Criteria::LIKE);
     $crit0->addOr($crit1);
     $c->add($crit0);
     $c->addDescendingOrderByColumn(JobPeer::EVENT);
     $c->setLimit(10);
     $jobs = JobPeer::doSelect($c);
     $arr = array();
     foreach ($jobs as $j) {
         $arr[] = array("name" => $j->getId() . " - " . $j->getEvent(), "url" => url_for('job_show', array("slug" => $j->getSlug())));
     }
     return $arr;
 }

 public function executeChartEmployees()
 {
     $data = array();
     foreach (JobPeer::doSelect(new Criteria()) as $job) {
         $c = new Criteria();
         $c->add(EmployeePeer::JOB_ID, $job->getId());
         $data[$job->getName()] = EmployeePeer::doCount($c);
     }
     //To create a bar chart we need to create a stBarOutline Object
     $bar = new stBarOutline(80, '#78B9EC', '#3495FE');
     $bar->key('', 10);
     //Passing the random data to bar chart
     $bar->data = $data;
     //Creating a stGraph object
     $g = new stGraph();
     $g->title('Employee Job Type Break-Down', '{font-size: 20px;}');
     $g->bg_colour = '#FFFFFF';
     $g->set_inner_background('#E3F0FD', '#CBD7E6', 90);
     $g->x_axis_colour('#8499A4', '#E4F5FC');
     $g->y_axis_colour('#8499A4', '#E4F5FC');
     //Pass stBarOutline object i.e. $bar to graph
     $g->data_sets[] = $bar;
     //Setting labels for X-Axis
     $g->set_x_labels(array_keys($data));
     // to set the format of labels on x-axis e.g. font, color, step
     $g->set_x_label_style(10, '#18A6FF', 0, 2);
     // To tick the values on x-axis
     // 2 means tick every 2nd value
     $g->set_x_axis_steps(2);
     //set maximum value for y-axis
     //we can fix the value as 20, 10 etc.
     //but its better to use max of data
     $g->set_y_max(max($data));
     $g->y_label_steps(4);
     $g->set_y_legend('# Employees', 12, '#18A6FF');
     echo $g->render();
     return sfView::NONE;
 }

 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @return Job[]
  * @throws PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(JobPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(JobPeer::DATABASE_NAME);
         $criteria->add(JobPeer::ID, $pks, Criteria::IN);
         $objs = JobPeer::doSelect($criteria, $con);
     }
     return $objs;
 }

 public function executeEdit()
 {
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $c = new Criteria();
     $c->add(JobPeer::CODE, $this->getModuleName());
     $job = JobPeer::doSelectOne($c);
     $acl = AclPeer::retrieveByPK($group_id, $job->getId());
     if (!$acl) {
         $this->forward('default', 'error404');
     }
     $this->can_add = $acl->getAddPriv() == 1;
     $this->can_edit = $acl->getEditPriv() == 1;
     $this->can_remove = $acl->getRemovePriv() == 1;
     $budget_status = BudgetStatusPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($budget_status);
     $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
     if ($acl->getRemovePriv()) {
         array_push($actions, array('name' => 'delete', 'url' => 'budget_status/delete?id=' . $budget_status->getId(), 'color' => 'red'));
     }
     array_push($actions, array('name' => 'cancel', 'url' => 'budget_status/list', 'color' => 'white'));
     $this->subtitle = $budget_status->toString() . ' - id:' . $budget_status->getId();
     $this->type = 'edit';
     $this->budget_status = $budget_status;
     $this->actions = $actions;
     $cw = new Criteria();
     $cw->add(JobPeer::PARENT, 240);
     $parent = JobPeer::doSelectOne($cw);
     $cr = new Criteria();
     $cton1 = $cr->getNewCriterion(JobPeer::PARENT, $parent->getParent(), Criteria::IN);
     $cton2 = $cr->getNewCriterion(JobPeer::ID, $job->getId(), Criteria::NOT_IN);
     $cton3 = $cr->getNewCriterion(JobPeer::CODE, 'academic_process', Criteria::NOT_IN);
     $cton4 = $cr->getNewCriterion(JobPeer::CODE, 'payer_type', Criteria::NOT_IN);
     $cton5 = $cr->getNewCriterion(JobPeer::CODE, 'payment_model', Criteria::NOT_IN);
     $cton6 = $cr->getNewCriterion(JobPeer::CODE, 'budget_category', Criteria::NOT_IN);
     $cton5->addAnd($cton6);
     $cton4->addAnd($cton5);
     $cton3->addAnd($cton4);
     $cton2->addAnd($cton3);
     $cton1->addAnd($cton2);
     $cr->add($cton1);
     $modules = JobPeer::doSelect($cr);
     $this->modules = $modules;
     $actions2 = array(array('name' => '<span>Komponen Biaya Sekolah</span>', 'url' => 'academic_cost_component/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Proses Akademik</span>', 'url' => 'academic_process/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Tipe Siswa</span>', 'url' => 'payer_type/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Model Pembayaran</span>', 'url' => 'payment_model/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Kategori Anggaran</span>', 'url' => 'budget_category/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>' . $job->getName() . '</span>', 'url' => $job->getCode(), 'color' => 'sun', 'type' => 'direct'));
     $this->actions2 = $actions2;
 }

 public function executeEdit()
 {
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $c = new Criteria();
     $c->add(JobPeer::CODE, $this->getModuleName());
     $job = JobPeer::doSelectOne($c);
     $acl = AclPeer::retrieveByPK($group_id, $job->getId());
     if (!$acl) {
         $this->forward('default', 'error404');
     }
     $this->can_add = $acl->getAddPriv() == 1;
     $this->can_edit = $acl->getEditPriv() == 1;
     $this->can_remove = $acl->getRemovePriv() == 1;
     $user_group = UserGroupPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($user_group);
     if ($user_group->getJobTemplateId() == 11) {
         $c = new Criteria();
         $cton1 = $c->getNewCriterion(JobPeer::ID, 132, Criteria::NOT_IN);
         $cton2 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, 1, Criteria::IN);
         $cton3 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, 3, Criteria::IN);
         $cton4 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, 11, Criteria::IN);
         $cton3->addOr($cton4);
         $cton2->addOr($cton3);
         $cton1->addAnd($cton2);
         $c->add($cton1);
         $c->addAscendingOrderByColumn(JobPeer::MENU_ORDER);
         $jobs = JobPeer::doSelect($c);
     } else {
         $c = new Criteria();
         $cton1 = $c->getNewCriterion(JobPeer::ID, 132, Criteria::NOT_IN);
         $cton2 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, $user_group->getJobTemplateId(), Criteria::IN);
         $cton3 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, $user_group->getJobTemplate()->getParent(), Criteria::IN);
         $cton4 = $c->getNewCriterion(JobPeer::JOB_TEMPLATE_ID, 11, Criteria::IN);
         $cton3->addOr($cton4);
         $cton2->addOr($cton3);
         $cton1->addAnd($cton2);
         $c->add($cton1);
         $c->addAscendingOrderByColumn(JobPeer::MENU_ORDER);
         $jobs = JobPeer::doSelect($c);
     }
     foreach ($jobs as $job) {
         $c = new Criteria();
         $c->add(JobPeer::PARENT, $job->getId());
         $c->add(JobPeer::DISPLAY_MENU, true);
         $job->child = JobPeer::doCount($c);
         $c = new Criteria();
         $c->add(AclPeer::USER_GROUP_ID, $user_group->getId(), Criteria::EQUAL);
         $c->add(AclPeer::JOB_ID, $job->getId(), Criteria::EQUAL);
         $job->acl = AclPeer::doSelectOne($c);
         $job->level = $job->getLevel();
         $job->order = $job->getMenuOrderRecursive();
     }
     $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
     if ($user_group->getCode() != 'admin' && $user_group->getCode() != 'student' && $user_group->getCode() != 'lector') {
         array_push($actions, array('name' => 'delete', 'url' => 'user_group/delete?id=' . $user_group->getId(), 'color' => 'red'));
     }
     array_push($actions, array('name' => 'cancel', 'url' => 'user_group/list', 'color' => 'white'));
     $this->subtitle = $user_group->toString() . ' - id:' . $user_group->getId();
     $this->type = 'edit';
     $this->user_group = $user_group;
     $this->icon = 'user_edit.png';
     $this->actions = $actions;
     $this->jobs = $jobs;
 }

 public function executeEdit()
 {
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $c = new Criteria();
     $c->add(JobPeer::CODE, $this->getModuleName());
     $jobs = JobPeer::doSelectOne($c);
     $acl = AclPeer::retrieveByPK($group_id, $jobs->getId());
     if (!$acl) {
         $this->forward('default', 'error404');
     }
     $this->can_add = $acl->getAddPriv() == 1;
     $this->can_edit = $acl->getEditPriv() == 1;
     $this->can_remove = $acl->getRemovePriv() == 1;
     $job = JobPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($job);
     $c = new Criteria();
     $c->add(JobInformationPeer::JOB_ID, $job->getId());
     $job_information = JobInformationPeer::doSelectOne($c);
     if ($job_information) {
         $this->job_information = $job_information;
     } else {
         $this->job_information = new JobInformation();
     }
     $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
     if ($acl->getRemovePriv()) {
         array_push($actions, array('name' => 'delete', 'url' => 'job_information/delete?id=' . $job->getId(), 'color' => 'red'));
     }
     array_push($actions, array('name' => 'cancel', 'url' => 'job_information/list', 'color' => 'white'));
     $this->subtitle = $job->toString() . ' - id:' . $job->getId();
     $this->type = 'edit';
     $this->job = $job;
     $this->actions = $actions;
     $cw = new Criteria();
     $cw->add(JobPeer::PARENT, 1078);
     $cw->addAscendingOrderByColumn('menu_order');
     $parent = JobPeer::doSelectOne($cw);
     $cr = new Criteria();
     $cton1 = $cr->getNewCriterion(JobPeer::PARENT, $parent->getParent(), Criteria::IN);
     $cton2 = $cr->getNewCriterion(JobPeer::ID, $jobs->getId(), Criteria::NOT_IN);
     $cton3 = $cr->getNewCriterion(JobPeer::CODE, 'public_information_category/list', Criteria::NOT_IN);
     $cton4 = $cr->getNewCriterion(JobPeer::CODE, 'public_information/listArticle', Criteria::NOT_IN);
     $cton5 = $cr->getNewCriterion(JobPeer::CODE, 'job_information/list', Criteria::NOT_IN);
     $cton6 = $cr->getNewCriterion(JobPeer::CODE, 'job_category', Criteria::NOT_IN);
     $cton5->addAnd($cton6);
     $cton4->addAnd($cton5);
     $cton3->addAnd($cton4);
     $cton2->addAnd($cton3);
     $cton1->addAnd($cton2);
     $cr->add($cton1);
     $modules = JobPeer::doSelect($cr);
     $this->modules = $modules;
     $actions2 = array(array('name' => '<span>Kategori Artikel</span>', 'url' => 'job_category/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Artikel Web</span>', 'url' => 'public_information/listArticle', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Kategori Menu</span>', 'url' => 'job_category/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>' . $jobs->getName() . '</span>', 'url' => $jobs->getCode(), 'color' => 'sun', 'type' => 'direct'));
     $this->actions2 = $actions2;
 }

 public function getJobs($criteria = null, $con = null)
 {
     include_once 'lib/model/om/BaseJobPeer.php';
     if ($criteria === null) {
         $criteria = new Criteria();
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     if ($this->collJobs === null) {
         if ($this->isNew()) {
             $this->collJobs = array();
         } else {
             $criteria->add(JobPeer::JOB_TEMPLATE_ID, $this->getId());
             JobPeer::addSelectColumns($criteria);
             $this->collJobs = JobPeer::doSelect($criteria, $con);
         }
     } else {
         if (!$this->isNew()) {
             $criteria->add(JobPeer::JOB_TEMPLATE_ID, $this->getId());
             JobPeer::addSelectColumns($criteria);
             if (!isset($this->lastJobCriteria) || !$this->lastJobCriteria->equals($criteria)) {
                 $this->collJobs = JobPeer::doSelect($criteria, $con);
             }
         }
     }
     $this->lastJobCriteria = $criteria;
     return $this->collJobs;
 }

 public function executeGetChild()
 {
     $group = $this->getContext()->getUser()->getAttribute('group', null, 'bo');
     if ($group != 'root') {
         $this->forward('default', 'index');
     }
     $id = $this->getRequestParameter('id');
     $this->forward404Unless($id);
     $level = $this->getRequestParameter('level');
     if ($level == null) {
         $level = 0;
     }
     $c = new Criteria();
     $c->add(JobPeer::PARENT, $id);
     $c->addAscendingOrderByColumn(JobPeer::MENU_ORDER);
     $this->rows = JobPeer::doSelect($c);
     $this->level = $level + 1;
     $this->parent_id = $id;
     $this->parent_class = $this->getRequestParameter('parent_class');
 }

 /**
  * Gets an array of Job objects which contain a foreign key that references this object.
  *
  * If this collection has already been initialized with an identical Criteria, it returns the collection.
  * Otherwise if this Project has previously been saved, it will retrieve
  * related Jobs from storage. If this Project is new, it will return
  * an empty collection or the current collection, the criteria is ignored on a new object.
  *
  * @param      PropelPDO $con
  * @param      Criteria $criteria
  * @return     array Job[]
  * @throws     PropelException
  */
 public function getJobs($criteria = null, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(ProjectPeer::DATABASE_NAME);
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     if ($this->collJobs === null) {
         if ($this->isNew()) {
             $this->collJobs = array();
         } else {
             $criteria->add(JobPeer::PROJECT_ID, $this->id);
             JobPeer::addSelectColumns($criteria);
             $this->collJobs = JobPeer::doSelect($criteria, $con);
         }
     } else {
         // criteria has no effect for a new object
         if (!$this->isNew()) {
             // the following code is to determine if a new query is
             // called for.  If the criteria is the same as the last
             // one, just return the collection.
             $criteria->add(JobPeer::PROJECT_ID, $this->id);
             JobPeer::addSelectColumns($criteria);
             if (!isset($this->lastJobCriteria) || !$this->lastJobCriteria->equals($criteria)) {
                 $this->collJobs = JobPeer::doSelect($criteria, $con);
             }
         }
     }
     $this->lastJobCriteria = $criteria;
     return $this->collJobs;
 }

 public function executeEdit()
 {
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $c = new Criteria();
     $c->add(JobPeer::CODE, $this->getModuleName());
     $job = JobPeer::doSelectOne($c);
     $acl = AclPeer::retrieveByPK($group_id, $job->getId());
     if (!$acl) {
         $this->forward('default', 'error404');
     }
     $this->can_add = $acl->getAddPriv() == 1;
     $this->can_edit = $acl->getEditPriv() == 1;
     $this->can_remove = $acl->getRemovePriv() == 1;
     $facility = FacilityPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($facility);
     $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
     if ($acl->getRemovePriv()) {
         array_push($actions, array('name' => 'delete', 'url' => 'facility/delete?id=' . $facility->getId(), 'color' => 'red'));
     }
     array_push($actions, array('name' => 'cancel', 'url' => 'facility/list', 'color' => 'black'));
     $this->subtitle = $facility->toString() . ' - id:' . $facility->getId();
     $this->type = 'edit';
     $this->facility = $facility;
     $this->actions = $actions;
     $cw = new Criteria();
     $cw->add(JobPeer::PARENT, 242);
     $parent = JobPeer::doSelectOne($cw);
     $cr = new Criteria();
     $cton1 = $cr->getNewCriterion(JobPeer::PARENT, $parent->getParent(), Criteria::IN);
     $cton2 = $cr->getNewCriterion(JobPeer::ID, $job->getId(), Criteria::NOT_IN);
     $cton3 = $cr->getNewCriterion(JobPeer::CODE, 'location_condition', Criteria::NOT_IN);
     $cton2->addAnd($cton3);
     $cton1->addAnd($cton2);
     $cr->add($cton1);
     $modules = JobPeer::doSelect($cr);
     $this->modules = $modules;
     $actions2 = array(array('name' => '<span>Kategori Ruangan</span>', 'url' => 'location_category/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>Kondisi Ruangan</span>', 'url' => 'location_condition/list', 'color' => 'sky'));
     array_push($actions2, array('name' => '<span>' . $job->getName() . '</span>', 'url' => $job->getCode(), 'color' => 'sun', 'type' => 'direct'));
     $this->actions2 = $actions2;
 }

<?php

$c = new Criteria();
$c->add(JobPeer::PARENT, 1071, Criteria::IN);
$c->add(JobPeer::DISPLAY_MENU, true);
$c->addAscendingOrderByColumn('menu_order');
$jobs = JobPeer::doSelect($c);
?>

<div style="margin:29px 0 0 104px;float:left;width:160px;text-align:left;color:#fff;">
	<ul id="menubanner" class="menubanner">
    	<li class="active item12" id="current"><a href="/"><span>Home</span></a></li>
    	<?php 
foreach ($jobs as $job) {
    ?>
        <li class="item">
			<?php 
    echo link_to_remote(__($job->getName()), array('update' => 'content', 'script' => 'true', 'url' => '/' . $job->getCode(), 'after' => 'document.getElementsByClassName(\'active_main_menu\').each(function(node){node.removeClassName(\'active_main_menu\');});$(this.parentNode).addClassName(\'active_main_menu\')', 'success' => visual_effect('fade', 'sub_menu') . visual_effect('fade', 'child_menu') . visual_effect('fade', 'grandchild_menu')));
    ?>
        </li>
    	<?php 
}
?>
    </ul>					
</div>

 public function executeEdit()
 {
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $c = new Criteria();
     $c->add(JobPeer::CODE, $this->getModuleName());
     $job = JobPeer::doSelectOne($c);
     $acl = AclPeer::retrieveByPK($group_id, $job->getId());
     if (!$acl) {
         $this->forward('default', 'error404');
     }
     $this->can_add = $acl->getAddPriv() == 1;
     $this->can_edit = $acl->getEditPriv() == 1;
     $this->can_remove = $acl->getRemovePriv() == 1;
     $academic_cost_component = AcademicCostComponentPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($academic_cost_component);
     $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
     if ($acl->getRemovePriv()) {
         array_push($actions, array('name' => 'delete', 'url' => 'academic_cost_component/delete?id=' . $academic_cost_component->getId(), 'color' => 'red'));
     }
     array_push($actions, array('name' => 'cancel', 'url' => 'academic_cost_component/list', 'color' => 'black'));
     $this->subtitle = $academic_cost_component->toString() . ' - id:' . $academic_cost_component->getId();
     $this->type = 'edit';
     $this->academic_cost_component = $academic_cost_component;
     $this->actions = $actions;
     $cw = new Criteria();
     $cw->add(JobPeer::PARENT, $job->getId());
     $modules = JobPeer::doSelect($cw);
     $this->modules = $modules;
     $actions2 = array(array('name' => '<span>Komponen Biaya Sekolah</span>', 'url' => $job->getCode(), 'color' => 'sun', 'type' => 'direct'));
     $this->actions2 = $actions2;
 }

 public function executeMenu()
 {
     $group = $this->getContext()->getUser()->getAttribute('group', null, 'bo');
     $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
     $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo');
     $employee = EmployeePeer::retrieveByPK($employee_id);
     var_dump($employee);
     die;
     $code = $this->getRequest()->getParameter('code');
     if ($code == 'acm') {
         #if ($group == 'admin' || $group == 'root') {
         if ($group == 'root') {
             $jobs = array();
             $job = new Job();
             $job->setName('Modul');
             $job->setCode('job');
             $job->child = 0;
             array_push($jobs, $job);
             $job = new Job();
             $job->setName('Parameters');
             $job->setCode('params');
             $job->child = 0;
             array_push($jobs, $job);
             $job = new Job();
             $job->setName('Template Koleksi');
             $job->setCode('cat_template');
             $job->child = 0;
             array_push($jobs, $job);
             $job = new Job();
             $job->setName('Template Menu');
             $job->setCode('menu_template');
             $job->child = 0;
             array_push($jobs, $job);
         } else {
             $this->forward('default', 'index');
         }
     } elseif ($code == 'user' || $code == 'user_group' || $code == 'job') {
         if ($group == 'admin' || $group == 'root') {
             $this->forward($code, 'index');
         } else {
             $this->forward('default', 'index');
         }
     } else {
         $c = new Criteria();
         $c->addAscendingOrderByColumn('menu_order');
         $c->add(JobPeer::CODE, $code);
         $parent = JobPeer::doSelectOne($c);
         $c = new Criteria();
         $c->add(JobPeer::PARENT, $parent->getId());
         $c->addJoin(JobPeer::ID, AclPeer::JOB_ID, Criteria::JOIN);
         $c->addJoin(AclPeer::USER_GROUP_ID, UserGroupPeer::ID, Criteria::JOIN);
         $c->add(UserGroupPeer::ID, $group_id, Criteria::EQUAL);
         $c->add(JobPeer::DISPLAY_MENU, true);
         $jobs = JobPeer::doSelect($c);
         // restrict some access to iglobal only
         $jobs0 = array();
         $user = $this->getUser()->getAttribute('username', null, 'bo');
         for ($i = 0; $i < count($jobs); ++$i) {
             if ($user == 'iglobal' || $user == 'syarif') {
                 $jobs0[count($jobs0)] = $jobs[$i];
             } else {
                 if ($jobs[$i]->getCode() != 'sm_check' && $jobs[$i]->getCode() != 'sm_template') {
                     $jobs0[count($jobs0)] = $jobs[$i];
                 }
             }
         }
         $jobs = $jobs0;
         foreach ($jobs as $job) {
             $c = new Criteria();
             $c->add(JobPeer::PARENT, $job->getId());
             $c->add(JobPeer::DISPLAY_MENU, true);
             $job->child = JobPeer::doCount($c);
         }
     }
     $this->jobs = $jobs;
     $this->type = $this->getRequest()->getParameter('get');
 }

<?php

error_reporting(E_ALL);
include_once "../../config/ProjectConfiguration.class.php";
$configuration = ProjectConfiguration::getApplicationConfiguration('frontend', 'prod', true);
$sfContext = sfContext::createInstance($configuration);
$c = new Criteria();
$c->add(JobPeer::DATE, null, Criteria::NOT_EQUAL);
$c->addDescendingOrderByColumn(JobPeer::ID);
foreach (JobPeer::doSelect($c) as $job) {
    try {
        $job->save();
    } catch (Exception $ex) {
        echo $ex->getMessage();
    }
    echo $job->getId() . "\n";
    sleep(60);
}
die;
/*
$u = new sfGuardUser();
$u->setPassword("asdfasdf");
$u->setUsername("adatta02");
$u->save();


$c = new Criteria();
// $c->add(JobPeer::G_CAL_ID, null);

foreach( JobPeer::doSelect( $c ) as $job ){