public static function retrieveById($pk, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$criteria = new Criteria(VisitorPeer::DATABASE_NAME);
$criteria->add(VisitorPeer::ID, $pk);
$v = VisitorPeer::doSelect($criteria, $con);
return !empty($v) > 0 ? $v[0] : null;
}
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = VisitorPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setMemberId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setTimeIn($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setTimeOut($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setDepartmentId($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setCode($arr[$keys[5]]);
}
}
public function executeUpdate()
{
$member_code = $this->getRequestParameter('code');
$member = MemberPeer::retrieveByCode($member_code);
$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo');
$now = date('dmY');
$time = date('Y/m/d h:i');
$i18n = new sfI18N();
$i18n->initialize($this->getContext());
$i18n->setCulture($this->getUser()->getCulture());
$action_i18n = $i18n->globalMessageFormat->format('save as new');
$action_type = $this->getRequestParameter('action_type');
if ($member->hasVisit()) {
//$pk = $member()->getVisitorId()->getId();
//$visitor = VisitorPeer::retrieveByPk($this->getRequestParameter('id'));
$member_id = $member->getId();
$visitor = VisitorPeer::retrieveByMember($member_id);
$this->forward404Unless($visitor);
//$c = new Criteria();
//$c->add(VisitorPeer::ID, $pk);
//$visitor = VisitorPeer::doSelectOne($c);
$visitor->setTimeOut($time);
$visitor->save();
return $this->redirect('default/index2');
} else {
$visitor = new Visitor();
$visitor->setId($this->getRequestParameter('id'));
$visitor->setMemberId($member->getId());
$visitor->setTimeIn($time);
$visitor->setDepartmentId($dept->getId());
$visitor->setCode($now);
$visitor->save();
return $this->redirect('default/index2');
}
}
public function executeDelete()
{
$visitor = VisitorPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($visitor);
$ref_error = 0;
foreach ($visitor->getRefCountMethods() as $ref) {
$method = "count" . $ref['affix'];
$count = $visitor->{$method}();
if ($count > 0) {
++$ref_error;
$this->getRequest()->setError('visitor_list/delete/' . sfInflector::camelize($ref['table']), $count);
}
}
if ($ref_error > 0) {
$this->getRequest()->setError('visitor_list/delete', '_ERR_DELETE_ (' . $visitor->toString() . ' - id:' . $visitor->getId() . ')');
} else {
$visitor->delete();
}
return $this->forward('visitor_list', 'list');
}
public function filterDetail($c, $filters)
{
$filters_key = array_keys($filters);
foreach ($filters_key as $key) {
$value = $filters[$key];
if ($value == '' || $value == null) {
continue;
}
if ($key == 'col_location_id') {
$c->addJoin(VisitorPeer::COL_LOCATION_ID, ColLocationPeer::ID);
$column = ColLocationPeer::getTableMap()->getColumn('ID');
} elseif ($key == 'DEPARTMENT_MEMBER_ID') {
$c->addJoin(DepartmentPeer::ID, MemberPeer::DEPARTMENT_ID);
$c->addJoin(VisitorPeer::MEMBER_ID, MemberPeer::ID);
$column = MemberPeer::getTableMap()->getColumn('DEPARTMENT_ID');
} elseif ($key == 'NO_REG') {
$c->addJoin(VisitorPeer::MEMBER_ID, MemberPeer::ID);
$column = MemberPeer::gettableMap()->getColumn('NO_REG');
} elseif ($key == 'CODE') {
$c->addJoin(VisitorPeer::MEMBER_ID, MemberPeer::ID);
$column = MemberPeer::gettableMap()->getColumn('CODE');
} elseif ($key == 'NAME') {
$c->addJoin(VisitorPeer::MEMBER_ID, MemberPeer::ID);
$column = MemberPeer::gettableMap()->getColumn('NAME');
} else {
$column = VisitorPeer::getTableMap()->getColumn($key);
}
$name = $column->getFullyQualifiedName();
$creoleType = $column->getCreoleType();
if ($creoleType == CreoleTypes::DATE) {
#$from = $value['from'];
#$to = $value['to'];
#if ($from != '' && $from != null) $c->add($name, $from, Criteria::GREATER_EQUAL );
#if ($to != '' && $to != null) $c->add($name, $to, Criteria::LESS_EQUAL );
$c->add($name, $value, Criteria::LIKE);
} else {
if ($creoleType == CreoleTypes::INTEGER) {
$c->add($name, $value, Criteria::EQUAL);
} else {
if ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) {
$c->add($name, "%{$value}%", Criteria::LIKE);
}
}
}
}
}
public function countVisitors($criteria = null, $distinct = false, $con = null)
{
include_once 'lib/model/om/BaseVisitorPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
$criteria->add(VisitorPeer::MEMBER_ID, $this->getId());
return VisitorPeer::doCount($criteria, $distinct, $con);
}
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(VisitorPeer::ID, $pks, Criteria::IN);
$objs = VisitorPeer::doSelect($criteria, $con);
}
return $objs;
}
public function getVisitorId($criteria = null, $con = null)
{
$c = new Criteria();
$c->add(VisitorPeer::MEMBER_ID, $this->getId());
return VisitorPeer::doSelectOne($c);
}
