/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = JobNotesPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setJobId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setRevision($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setCreatedAt($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setNotes($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setUserId($arr[$keys[5]]);
}
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @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(JobNotesPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(JobNotesPeer::DATABASE_NAME);
$criteria->add(JobNotesPeer::ID, $pks, Criteria::IN);
$objs = JobNotesPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeDiffNotes(sfWebRequest $request)
{
$jobNoteDiff = JobNotesPeer::retrieveByPK($request->getParameter("noteDiffId"));
$this->renderText($jobNoteDiff->getNotes());
return sfView::NONE;
}
/**
* Returns the number of related JobNotes objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related JobNotes objects.
* @throws PropelException
*/
public function countJobNotess(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(sfGuardUserProfilePeer::DATABASE_NAME);
} else {
$criteria = clone $criteria;
}
if ($distinct) {
$criteria->setDistinct();
}
$count = null;
if ($this->collJobNotess === null) {
if ($this->isNew()) {
$count = 0;
} else {
$criteria->add(JobNotesPeer::USER_ID, $this->id);
$count = JobNotesPeer::doCount($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 count of the collection.
$criteria->add(JobNotesPeer::USER_ID, $this->id);
if (!isset($this->lastJobNotesCriteria) || !$this->lastJobNotesCriteria->equals($criteria)) {
$count = JobNotesPeer::doCount($criteria, $con);
} else {
$count = count($this->collJobNotess);
}
} else {
$count = count($this->collJobNotess);
}
}
return $count;
}
public function save(PropelPDO $con = null)
{
$isNew = $this->isNew();
// see if we need to do revision control on the notes
$updateNotes = in_array(JobPeer::NOTES, $this->modifiedColumns) && strlen($this->getNotes() > 1);
if (is_null($con)) {
$con = Propel::getConnection(JobPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$ret = parent::save($con);
$con->commit();
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
$arr = $this->createCalendarArray();
if (!is_null(sfContext::getInstance()->getUser())) {
$uid = sfContext::getInstance()->getUser()->getUserId();
} else {
$uid = 1;
}
if ($isNew) {
$logEntry = new Log();
$logEntry->setWhen(time());
$logEntry->setPropelClass("Job");
$logEntry->setSfGuardUserProfileId($uid);
$logEntry->setMessage("Job created.");
$logEntry->setLogMessageTypeId(sfConfig::get("app_log_type_create"));
$logEntry->setPropelId($this->getId());
$logEntry->save();
if ($this->getDate("U") > 0) {
$event = sfGCalendar::createJobEvent($arr);
$this->setGCalId($event->id);
parent::save($con);
}
} else {
if ($this->getDate("U") > 0) {
if (is_null($this->getGCalId())) {
$event = sfGCalendar::createJobEvent($arr);
$this->setGCalId($event->id);
parent::save($con);
} else {
sfGCalendar::updateJobEventById($this->getGCalId(), $arr);
}
if (!is_null($this->getGCalIdCustomUrl())) {
if (!is_null($this->getGCalIdCustom())) {
$arr["calUrl"] = $this->getGCalIdCustomUrl();
sfGCalendar::updateJobEventById($this->getGCalIdCustom(), $arr);
} else {
$arr["calUrl"] = $url;
$event = sfGCalendar::createJobEvent($arr);
$this->setGCalIdCustom($event->id);
}
}
}
}
if ($updateNotes) {
$c = new Criteria();
$c->add(JobNotesPeer::JOB_ID, $this->getId());
$c->addDescendingOrderByColumn(JobNotesPeer::ID);
$old = JobNotesPeer::doSelectOne($c);
$rev = !is_null($old) ? $old->getRevision() + 1 : 1;
$jn = new JobNotes();
$jn->setJobId($this->getId());
$jn->setNotes($this->getNotes());
$jn->setRevision($rev);
$jn->setUserId(sfContext::getInstance()->getUser()->getUserId());
$jn->save();
}
}
