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));
}
