static function checkDuplicatePo($key)
{
$purchase = new Purchase($key);
//Search Duplicate
$records = fRecordSet::build('Purchase', array('po_number=' => $purchase->getPoNumber()));
if ($records->count() > 1) {
//Generate New PO
echo 'Duplicate PO';
$exploded = explode('/', $purchase->getPoNumber());
echo (int) $exploded[2] + 1;
$exploded[2] = sprintf("%03d", (int) $exploded[2] + 1);
$newPONumber = implode('/', $exploded);
$purchase->setPoNumber($newPONumber);
$purchase->store();
}
}
/**
* Returns all active checks on the system
*
* @param string $sort_column The column to sort by
* @param string $sort_dir The direction to sort the column
* @return fRecordSet An object containing all meetups
*/
static function findActive()
{
return fRecordSet::buildFromSQL(
__CLASS__,
array("SELECT checks.* FROM checks JOIN subscriptions ON checks.check_id = subscriptions.check_id WHERE enabled = 1;")
);
}
public function addInterest($name, $category)
{
global $db;
$db->execute("INSERT INTO interests (category,name) VALUES (%s, %s)", $category, $name);
$record = fRecordSet::build('Interest', array('name=' => $name, 'category=' => $category));
return $record[0]->getInterestId();
}
public function show()
{
$this->editable = UserHelper::isEditor();
$cons = array();
$field = trim(fRequest::get('field'));
$start_year = trim(fRequest::get('start_year'));
$major = trim(fRequest::get('major'));
$location = trim(fRequest::get('location'));
$words = trim(fRequest::get('words'));
$cons['login_name|display_name~'] = $words;
if (!empty($field)) {
$cons['field='] = $field;
}
if (!empty($start_year)) {
$cons['start_year='] = $start_year;
}
if (!empty($major)) {
$cons['major='] = $major;
}
if (!empty($location)) {
$cons['location~'] = $location;
}
$this->users = fRecordSet::build('Profile', $cons, array('id' => 'asc'));
$this->field = $field;
$this->start_year = $start_year;
$this->major = $major;
$this->location = $location;
$this->words = $words;
$this->render('search/index');
}
public function index()
{
$this->articles = fRecordSet::build('Article', array('type=' => 'news', 'visible=' => 1), array('priority' => 'desc', 'created_at' => 'desc'), ACTIVITIES_LIMIT - 2);
$this->posts = fRecordSet::build('Article', array('type=' => 'post', 'visible=' => 1, 'priority<' => 999999), array('priority' => 'desc', 'created_at' => 'desc'), ACTIVITIES_LIMIT - 1);
$this->activities = fRecordSet::buildFromSQL('Activity', 'SELECT activities.* FROM activities GROUP BY realname,type,DATE(timestamp),HOUR(timestamp) ORDER BY timestamp DESC LIMIT ' . ACTIVITIES_LIMIT);
$this->render('home/index');
}
/**
* Returns all meetups on the system
*
* @param string $sort_column The column to sort by
* @param string $sort_dir The direction to sort the column
* @return fRecordSet An object containing all meetups
*/
static function findAll($dashboard_id=NULL)
{
return fRecordSet::build(
__CLASS__,
array('dashboard_id=' =>$dashboard_id),
array('weight' => 'asc')
);
}
public static function invalidate($username, $problem_id, $submit_time)
{
global $cache;
$affected_reports = fRecordSet::build('Report', array('problem_list~' => $problem_id, 'user_list~' => $username, 'start_datetime<=' => $submit_time, 'end_datetime>=' => $submit_time));
foreach ($affected_reports as $report) {
$cache->delete($report->getBoardCacheKey());
}
}
public function showKnown()
{
if (!UserHelper::isEditor()) {
throw new fValidationException('not allowed');
}
$this->users = fRecordSet::build('Name', array('registered=' => 0), array('student_number' => 'asc'));
$this->render('users/known');
}
public static function findByBranch($branch, $doctype)
{
//return fRecordSet::buildFromSQL('Production_issue',
// "SELECT production_issues.* FROM production_issues, (SELECT * FROM users WHERE branch_id = '$branch') AS tbl WHERE production_issues.issuer = tbl.username AND production_issues.doc_type = '$doctype' AND YEAR( production_issues.doc_date ) = YEAR( CURDATE( ) ) AND MONTH( production_issues.doc_date ) = MONTH( CURDATE( ))",
// "SELECT count(*) FROM production_issues"
// );
return fRecordSet::buildFromSQL('Production_issue', "SELECT production_issues.* FROM production_issues WHERE production_issues.doc_number LIKE '" . $doctype . "/" . $branch . "/" . "%" . "' AND YEAR( production_issues.doc_date ) = YEAR( CURDATE( ) ) AND MONTH( production_issues.doc_date ) = MONTH( CURDATE( ) )", "SELECT count(*) FROM production_issues");
}
/**
* Returns all meetups on the system
*
* @param string $sort_column The column to sort by
* @param string $sort_dir The direction to sort the column
* @return fRecordSet An object containing all meetups
*/
static function findAll($graph_id=NULL)
{
return fRecordSet::build(
__CLASS__,
array('graph_id=' =>$graph_id),
array()
);
}
/**
* @param array $where
* @return WpTesting_Model_AbstractTerm
* @throws fNotFoundException
*/
protected function findByParams(array $where = array())
{
$taxonomyTable = fORM::tablize('WpTesting_Model_Taxonomy');
try {
return fRecordSet::build($this->modelName, array($taxonomyTable . '.taxonomy=' => $this->getTaxonomy()) + $where)->getRecord(0);
} catch (fNoRemainingException $e) {
throw new fNotFoundException($this->modelName . ' not found by conditions: ' . var_export($where, true));
}
}
static function findActive($check_id = NULL)
{
if (!is_null($check_id) && is_numeric($check_id)) {
$filter = ' AND check_id=' . $check_id;
} else {
$filter = '';
}
return fRecordSet::buildFromSQL(__CLASS__, array('SELECT subscriptions.* FROM subscriptions WHERE user_id = ' . fSession::get('user_id') . $filter));
}
/**
* Returns all meetups on the system
*
* @return fRecordSet An object containing all meetups
*/
static function findAll($group_id = NULL)
{
if (!is_null($group_id) && is_numeric($group_id)) {
$filter = array('group_id=' => $group_id);
} else {
$filter = array();
}
return fRecordSet::build(__CLASS__, $filter, array());
}
static function findStatus($po)
{
$records = fRecordSet::build('Good_receipt_note', array('po_no=' => $po));
if ($records->count() > 1) {
return false;
} else {
return true;
}
}
/**
* Returns all meetups on the system
*
* @param string $sort_column The column to sort by
* @param string $sort_dir The direction to sort the column
* @return fRecordSet An object containing all meetups
*/
static function findAll()
{
return fRecordSet::build(
__CLASS__,
array(),
array()
);
}
/**
* Return entries by month and branch
*
* @param string $branch Branch ID to represent a branch
* @param int $month Specific month as the input
* @param string $item Item code to specify an individual item
* @return int The total movement by month
*/
static function findByMonth($branch, $month, $item)
{
$movements = fRecordSet::build('Inv_movement', array('branch_id=' => $branch, 'date>=' => '2010-' . $month . '-1', 'date<=' => '2010-' . $month . '-31', 'item_id=' => $item));
if ($movements->count()) {
return $movements->getRecord(0)->prepareQuantity();
} else {
return 0;
}
}
public function getContactOrEmpty($type)
{
try {
$records = fRecordSet::build('Contact', array('profile_id=' => $this->getId(), 'type=' => $type), array(), 1);
$records->tossIfEmpty();
return $records->getRecord(0)->getContent();
} catch (Exception $e) {
return '';
}
}
public static function hasParent($category_id, $region = 0)
{
$category = fRecordSet::build(__CLASS__, array('id_category=' => $category_id, 'id_region=' => $region));
$category = $category[0];
if ($category->getIdParent() > 0) {
return $category->getIdParent();
} else {
return $category->getIdCategory();
}
}
private static function fetchFromDB($user_name, $permission_name)
{
if (!array_key_exists($user_name, self::$permission_cache)) {
self::$permission_cache[$user_name] = array();
$permissions = fRecordSet::build('Permission', array('user_name=' => $user_name));
foreach ($permissions as $permission) {
self::$permission_cache[$user_name][] = $permission->getPermissionName();
}
}
return in_array($permission_name, self::$permission_cache[$user_name]);
}
protected function fillSteps()
{
$questions = $this->test->buildQuestions();
$total = $questions->count();
$answered = $this->answeredQuestions->count();
foreach ($questions as $q => $question) {
$records = fRecordSet::buildFromArray('WpTesting_Model_Question', array($q => $question));
$isCurrent = $answered == $q;
$this->addStep(new WpTesting_Model_Step('', $records), $isCurrent);
}
return $this->enableStepsCounter();
}
public function halloffames()
{
$this->editable = UserHelper::isEditor();
if ($this->editable) {
$this->articles = fRecordSet::build('Article', array('type=' => 'halloffame'), array('priority' => 'desc', 'created_at' => 'asc'));
} else {
$this->articles = fRecordSet::build('Article', array('type=' => 'halloffame', 'visible=' => 1), array('priority' => 'desc', 'created_at' => 'asc'));
}
$this->title = "校友风采";
$this->articleType = "halloffame";
$this->render('article/index');
}
/**
* Authors Ranklist
*/
public function ranklist()
{
$this->page = fRequest::get('page', 'integer', 1);
if ($this->page <= 0) {
$this->page = 1;
}
$this->user_stats = fRecordSet::build('UserStat', array(), array('solved' => 'desc', 'tried' => 'asc', 'submissions' => 'asc'), Variable::getInteger('users-per-page', 50), $this->page);
$this->page_url = SITE_BASE . '/ranklist?page=';
$this->page_records = $this->user_stats;
$this->nav_class = 'ranklist';
$this->render('user/ranklist');
}
public static function markRegistered($email, $invitecode)
{
try {
if (self::isGlobalInvitation($email, $invitecode)) {
return;
}
$invitation = fRecordSet::build('Invitation', array('email=' => $email, 'invitecode=' => $invitecode))->getRecord(0);
$invitation->setUserRegistered(1);
$invitation->store();
} catch (Exception $e) {
// do nothing
}
}
public static function fetch($username)
{
if (self::$profile_cache === NULL) {
self::$profile_cache = array();
$profiles = fRecordSet::build('Profile');
foreach ($profiles as $profile) {
self::$profile_cache[$profile->getUsername()] = array('realname' => $profile->getRealname(), 'class_name' => $profile->getClassName(), 'phone_number' => $profile->getPhoneNumber(), 'gender' => $profile->getGender(), 'school' => $profile->getSchool(), 'major' => $profile->getMajor(), 'grade' => $profile->getGrade(), 'qq' => $profile->getQq());
}
}
if (array_key_exists($username, self::$profile_cache)) {
return self::$profile_cache[$username];
}
return array('realname' => '', 'class_name' => '', 'phone_number' => '', 'gender' => '', 'school' => '', 'major' => '', 'grade' => '', 'qq' => '');
}
public static function markRegistered($realname, $stuid)
{
try {
/* $userid=fRecordSet::build('Name', array('student_number=' => $stuid,'realname'=>$realname))->getRecord(0)->getId();
$user = new Name($userid);
$user->delete();
*/
$user = fRecordSet::build('Name', array('student_number=' => $stuid, 'realname=' => $realname))->getRecord(0);
$user->setRegistered(1);
$user->store();
} catch (Exception $e) {
// do nothing
}
}
public function homework()
{
if (fAuthorization::checkLoggedIn()) {
$this->cache_control('private', 5);
} else {
$this->cache_control('private', 10);
}
$conditions = array('title~' => array('homework', '作业'));
if (!User::can('view-any-report')) {
$conditions['visible='] = TRUE;
}
$this->reports = fRecordSet::build('Report', $conditions, array('id' => 'desc'));
$this->nav_class = 'homework';
$this->render('report/homework');
}
public static function find($view_any, $page, $title, $author)
{
$conditions = array();
if (!$view_any) {
$conditions['secret_before<='] = Util::currentTime();
}
if (strlen($title)) {
$conditions['title~'] = $title;
}
if (strlen($author)) {
$conditions['author~'] = $author;
}
$limit = Variable::getInteger('problems-per-page', 10);
return fRecordSet::build('Problem', $conditions, array('id' => 'asc'), $limit, $page);
}
public function hasUnRead($id = 0)
{
$mails = fRecordSet::build('Mail', array('receiver=' => $id, 'parent=' => $this->getId(), 'read=' => 0), array('timestamp' => 'asc'));
foreach ($mails as $m) {
$m->setRead(1);
$m->store();
}
if ($this->getReceiver() == $id) {
$this->setRead(1);
$this->store();
}
if ($this->getRead()) {
return $mails->count() > 0;
} else {
return true;
}
}
public static function find($top, $owner, $problem_id, $language, $verdict, $page = 1)
{
$conditions = array();
if (!empty($top)) {
$conditions['id<='] = $top;
}
if (strlen($owner)) {
$conditions['owner='] = $owner;
}
if (strlen($problem_id)) {
$conditions['problem_id='] = $problem_id;
}
if (!empty($language)) {
$conditions['code_language='] = $language - 1;
}
if (!empty($verdict)) {
$conditions['verdict='] = $verdict;
}
$limit = Variable::getInteger('records-per-page', 50);
return fRecordSet::build('Record', $conditions, array('id' => 'desc'), $limit, $page);
}
public function create()
{
try {
$profileId = UserHelper::getProfileId();
$mail = new Mail();
$mail->setSender($profileId);
$mail->setContent(trim(fRequest::get('mail-content')));
$re = trim(fRequest::get('dest'));
if (empty($re)) {
$re = trim(fRequest::get('destre', 'integer'));
$pa = trim(fRequest::get('parent', 'integer', -1));
$x = new Profile($re);
$mail->setReceiver($re);
$mail->setParent($pa);
} else {
//$receiver=fRecordSet::build('Profile',array('login_name=' => $re ),array())->getRecord(0);
$receiver = fRecordSet::build('Profile', array('login_name=' => $re), array());
if ($receiver->count()) {
$receiver = $receiver->getRecord(0);
} else {
throw new fNotFoundException('user doesn\'t exist');
}
$mail->setReceiver($receiver->getId());
}
if (strlen($mail->getContent()) < 1) {
throw new fValidationException('信息长度不能少于1个字符');
}
if (strlen($mail->getContent()) > 140) {
throw new fValidationException('信息长度不能超过140个字符');
}
$mail->store();
//Activity::fireNewTweet();
fMessaging::create('success', 'create mail', '信息发送成功！');
} catch (fNotFoundException $e) {
fMessaging::create('failure', 'create mail', '该用户名不存在,或该用户没有创建个人资料！');
} catch (fException $e) {
fMessaging::create('failure', 'create mail', $e->getMessage());
}
fURL::redirect(SITE_BASE . '/inbox');
}
