public function getSpecial()
{
$c = new Criteria();
$cton1 = $c->getNewCriterion(EmployeePeer::STAFF_TYPE_ID, 13);
$cton2 = $c->getNewCriterion(EmployeePeer::STAFF_TYPE_ID, 14);
$cton1->addOr($cton2);
$c->add($cton1);
$special = EmployeePeer::doSelectOne($c);
return $special;
}
<?php
$tanggal = date('Y-m-d');
echo DateToIndo($tanggal);
?>
<br />Guru Mata Pelajaran
</td>
</tr>
<tr><td colspan="25" height="70px"></td></tr>
<tr>
<td></td>
<td style="text-align: left; font-size: 12px; font-weight: bold;">
<?php
$c = new Criteria();
$c->add(EmployeePeer::DEPARTMENT_ID, $course_schedule->getAcademicCalendar()->getDepartmentId());
$c->add(EmployeePeer::STAFF_TYPE_ID, 14);
$employee = EmployeePeer::doSelectOne($c);
echo $employee->getName() ? $employee->getName() : '-';
?>
</td><td colspan="26"></td>
<td style="text-align: left; font-size: 12px; font-weight: bold;" colspan="8">
<?php
$tutors = array();
foreach ($course_schedule->getCourseScheduleTutors() as $cr) {
$tutors[] = $cr->getEmployee() ? $cr->getEmployee()->getName() : '-';
}
echo join(" dan ", $tutors);
?>
</td>
</tr>
</table>
</center>
/**
* Get the associated Employee object
*
* @param PropelPDO Optional Connection object.
* @return Employee The associated Employee object.
* @throws PropelException
*/
public function getEmployee(PropelPDO $con = null)
{
if ($this->aEmployee === null && $this->employee_id !== null) {
$c = new Criteria(EmployeePeer::DATABASE_NAME);
$c->add(EmployeePeer::ID, $this->employee_id);
$this->aEmployee = EmployeePeer::doSelectOne($c, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aEmployee->addUsers($this);
*/
}
return $this->aEmployee;
}
?>
</label><br />
<input type="password" name="password" id="password" value=""/><br />
<input type=submit name=update value=<?php
echo __('Simpan');
?>
style='cursor:pointer; width: 50px; background-color: #FFCC00; color:#000; font-weight: bold; margin-top:5px;' >
</form>
<?php
} elseif ($this->getContext()->getUser()->getAttribute('usertype', '', 'bo') == 'lector') {
?>
<?php
$username = $this->getContext()->getUser()->getAttribute('username', '', 'bo');
$c = new Criteria();
$c->add(EmployeePeer::EMP_NO, $this->getContext()->getUser()->getAttribute('username_long', '', 'bo'));
$user = EmployeePeer::doSelectOne($c);
?>
<?php
#echo form_tag('user/updateLector')
?>
<!--input type="hidden" value="<?php
#echo $user->getId()
?>
" name="id" id="id" />
<label style="color:#000; font-weight: bold; text-align:left;"><?php
echo __('Username');
?>
</label><br />
<input type="text" name="login" id="login" value="<?php
#echo $username
?>
public function executeDoLogin()
{
if ($this->hasRequestParameter('login_user') && $this->hasRequestParameter('login_password')) {
// check if the user exists
$c = new Criteria();
$c->add(UserPeer::LOGIN, $this->getRequestParameter('login_user'));
$user = UserPeer::doSelectOne($c);
if ($user) {
// check if the password is correct
$password = $this->getRequestParameter('login_password');
$crypted = sha1(sfConfig::get('app_salt') . $password);
if ($crypted == $user->getPassword()) {
// sign in
$this->getContext()->getUser()->signIn($user);
// proceed to home page
$this->setTemplate('index');
return;
}
} else {
$c = new Criteria();
$c->add(EmployeePeer::EMP_NO, $this->getRequestParameter('login_user'));
$user = EmployeePeer::doSelectOne($c);
if ($user) {
// check if the password is correct
$password = $this->getRequestParameter('login_password');
$crypted = sha1(sfConfig::get('app_salt') . $password);
if ($crypted == $user->getPassword()) {
// sign in
$this->getContext()->getUser()->signInLector($user);
// proceed to home page
$this->setTemplate('index');
return;
}
} else {
$username = $this->getRequestParameter('login_user');
$dept_name = substr($username, 4, 3);
$c = new Criteria();
#$c->add(VStudentLoginPeer::DEPARTMENT_NAME, $dept_name);
$c->add(VStudentLoginPeer::LOGIN, $username);
$user = VStudentLoginPeer::doSelectOne($c);
if ($user) {
// check if the password is correct
$password = $this->getRequestParameter('login_password');
$crypted = sha1(sfConfig::get('app_salt') . $password);
if ($crypted == $user->getPassword()) {
// sign in
$this->getContext()->getUser()->signInStudent($user);
// proceed to home page
$this->setTemplate('index');
return;
}
}
}
}
// an error was found
$this->getRequest()->setError('login_error_title', 'Login failed');
$this->getRequest()->setError('login_error_msg', 'Your username or password are not correct. Please try again.');
$this->getRequest()->setParameter('login_submit', null);
return $this->forward('default', 'login');
} else {
$this->forward('default', 'login');
}
}
public function getServiceCoord(PropelPDO $con = null)
{
if ($this->aServiceCoord === null && $this->service_coord_id !== null) {
$c = new Criteria(EmployeePeer::DATABASE_NAME);
$c->add(EmployeePeer::ID, $this->service_coord_id);
$this->aServiceCoord = EmployeePeer::doSelectOne($c, $con);
}
return $this->aServiceCoord;
}
