public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(SmsDraftPeer::ID, $pks, Criteria::IN); $objs = SmsDraftPeer::doSelect($criteria, $con); } return $objs; }
public function executeDraftGet() { $param = $this->getAllRequestParameter(); $this->userInit(); $user_id = $this->user->getAttribute('user_id', null, 'bo'); $limit = !empty($param['limit']) ? $param['limit'] : 20; $offset = !empty($param['offset']) ? $param['offset'] : 0; $draftCriteria = new Criteria(); $draftCriteria->add(SmsDraftPeer::CREATOR_USER_ID, $user_id, Criteria::EQUAL); $draftCriteria->add(SmsDraftPeer::CREATOR_TYPE, $this->userType, Criteria::EQUAL); $draftCount = SmsDraftPeer::doCount($draftCriteria); $draftCriteria->addDescendingOrderByColumn(SmsDraftPeer::CREATED); $draftCriteria->setLimit($limit); $draftCriteria->setOffset($offset); $drafts = SmsDraftPeer::doSelect($draftCriteria); $output = array(); foreach ($drafts as $draft) { $temp = $draft->toArray(); $temp['created'] = date('d F Y H:i:s', strtotime($temp['Created'])); $temp['send_at'] = $temp['Scheduled'] ? date('d F Y H:i:s', strtotime($temp['ScheduleTime'])) : 'now'; $output[] = $temp; } $this->jsonwrapper->print_json(array('success' => 1, 'data' => $output, 'all_data_count' => $draftCount)); }