<tr>
<td data-title="Job Code"><?php
echo getJobDetails($conn, $row1['job_id'], 'job_code');
?>
</td>
<td data-title="Job Description"><?php
echo getJobDetails($conn, $row1['job_id'], 'job_desc');
?>
</td>
<td data-title="Designation"><?php
echo getJobDetails($conn, $row1['job_id'], 'designation');
?>
</td>
<td data-title="Location"><?php
echo getJobDetails($conn, $row1['job_id'], 'job_location');
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<div class="clear"></div>
</div>
<div class="content_head">Show Your Interest</div>
<div class="table_main_other" id="no-more-tables-other">
<div class="clear"></div>
<table class="table-bordered-other table-striped table-condensed-other cf" id="example1">
public function save($con = null)
{
sfContext::getInstance()->getConfiguration()->loadHelpers(array('Url', 'Object', 'Tag', 'Text', 'PMRender', 'Asset', 'Helper'));
$j = new Job();
$j->setEvent($this->getValue("event"));
$j->setStartTime($this->getValue("start_time"));
$j->setEndTime($this->getValue("end_time"));
$j->setDate($this->getValue("date"));
$j->setDueDate($this->getValue("due_date"));
$j->setAcctNum($this->getValue("acct_num"));
$j->setDeptId($this->getValue("dept_id"));
$j->setPublicationId($this->getValue("publication_id"));
$j->setStreet($this->getValue("street"));
$j->setCity($this->getValue("city"));
$j->setState($this->getValue("state"));
$j->setZip($this->getValue("zip"));
if (is_array($this->getValue("photo_type"))) {
$j->setPhotoType(implode(", ", $this->getValue("photo_type")));
} else {
$j->setPhotoType($this->getValue("photo_type"));
}
$j->setOther($this->getValue("other"));
$j->setQues1($this->getValue("ques1"));
$j->setQues2($this->getValue("ques2"));
$j->setQues3($this->getValue("ques3"));
$j->setContactName($this->getValue("contact_name"));
$j->setContactPhone($this->getValue("contact_phone"));
$j->setContactEmail($this->getValue("contact_email"));
$j->setStatusId(sfConfig::get("app_job_status_pending", 1));
$j->setProjectId($this->getValue("project_id"));
$j->save();
$body = "Dear {$this->getValue("name")},\r\n\r\nYour job, {$this->getValue("event")}, has been entered into our system. \r\nIf you wish to track the progress of your job, you may do so at http://jobs.tuftsphoto.com \r\n\r\nThanks for using University Photography; we look forward to working with you! \r\n\r\nThe Tufts Photo Team \r\nUniversity Photography\r\n80 George St., First Floor\r\nMedford, MA 02155\r\nTel: 617.627.4282\r\nFax: 617.627.3549\r\nphoto@tufts.edu\r\n\r\n\r\n" . getJobDetails($j);
mail($this->getValue("email") . ", photo@tufts.edu", "University Photography Job #" . $j->getId() . " - " . $j->getEvent(), $body, "From: photo@tufts.edu");
$user = sfContext::getInstance()->getUser();
if ($this->getValue("clientId") > 0 && ($user->hasCredential("client") || $user->hasCredential("admin"))) {
$client = ClientPeer::retrieveByPK($this->getValue("clientId"));
$j->addClient($client);
}
// if they are a user lets make them a client
if ($user->getProfile()->getUserType()->getId() == sfConfig::get("app_user_type_user")) {
$clientProfile = new Client();
$clientProfile->setUserId($user->getProfile()->getId());
$clientProfile->setName($this->getValue("name"));
$clientProfile->setDepartment($this->getValue("department"));
$clientProfile->setAddress($this->getValue("address"));
$clientProfile->setEmail($this->getValue("email"));
$clientProfile->setPhone($this->getValue("phone"));
$clientProfile->save();
$user->getProfile()->setUserTypeId(sfConfig::get("app_user_type_client"));
$user->getProfile()->save();
$user->clearCredentials();
$user->addCredential("client");
} else {
if ($user->getProfile()->getUserType()->getId() == sfConfig::get("app_user_type_client")) {
$c = new Criteria();
$c->add(ClientPeer::USER_ID, $user->getProfile()->getId());
$clientProfile = ClientPeer::doSelectOne($c);
if (is_null($clientProfile)) {
$clientProfile = new Client();
}
$clientProfile->setUserId($user->getProfile()->getId());
$clientProfile->setName($this->getValue("name"));
$clientProfile->setDepartment($this->getValue("department"));
$clientProfile->setAddress($this->getValue("address"));
$clientProfile->setEmail($this->getValue("email"));
$clientProfile->setPhone($this->getValue("phone"));
$clientProfile->save();
}
}
if (isset($clientProfile) && !is_null($clientProfile)) {
$j->addClient($clientProfile);
}
return $j->getId();
}
</thead>
<tbody>
<?php
$result = $conn->query("select * from job_student_job_interest where employer_registraion_id='{$registration_id}' and employer_acceptance='P'");
$num = $result->num_rows;
while ($row = $result->fetch_assoc()) {
$post_date = $row['post_date'];
$date = date('d-m-Y', strtotime($post_date));
?>
<tr>
<td data-title="Date"><?php
echo $date;
?>
</td>
<td data-title="Jobcode"><?php
echo getJobDetails($conn, $row['job_id'], 'job_code');
?>
</td>
<td data-title="Candidate Name">
<a href="candidate_trainer_profile.php?registration_id=<?php
echo $row['registration_id'];
?>
"><?php
echo getUserName($conn, $row['registration_id']);
?>
</a>
</td>
<td data-title="Contact"><?php
echo getUserMobile($conn, $row['registration_id']);
?>
</td>
<div class="summary">
<h1><?php
echo icl_t('Home', 'Job Opportunites with our clients', 'Job Opportunites with our clients');
?>
</h1>
<?php
global $wpdb;
$querystr = "SELECT * FROM feedlocations WHERE `language` = '" . ICL_LANGUAGE_CODE . "'";
$feedoutput = $wpdb->get_results($querystr, ARRAY_A);
?>
<section class="jobs-slider">
<div class="jobs-slider-container">
<ul class="jobs">
<?php
foreach ($feedoutput as $feedtype) {
$jobs = getJobDetails($feedtype['category'], $feedtype['locations']);
?>
<li class="job" style="overflow-y:hidden;">
<span class="sector"><?php
echo $feedtype['category'];
?>
</span>
<a href="<?php
echo $jobs[$feedtype['category']]['guid'];
?>
" class="title"><?php
echo $jobs[$feedtype['category']]['title'];
?>
</a>
<a href="<?php
echo $jobs[$feedtype['category']]['guid'];
?>
</td>
<td data-title="Job Code" align="center"><?php
echo getJobDetails($conn, $row['job_id'], 'job_code');
?>
</td>
<td data-title="Job Description" align="center"><?php
echo getJobDetails($conn, $row['job_id'], 'job_desc');
?>
</td>
<td data-title="Designation" align="center"><?php
echo getJobDetails($conn, $row['job_id'], 'designation');
?>
</td>
<td data-title="Location" align="center"><?php
echo getCityName($conn, getJobDetails($conn, $row['job_id'], 'job_location'));
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
<!-- -------------------------------- container ends ------------------------------ -->
<?php echo getJobDetails($job); ?> </div> <div id="email-template-details" style="display: none;">Dear %name%, Thank you for submitting your photo assignment request. Please review and confirm with us the details of your job by logging into http://jobs.tuftsphoto.com. Unless otherwise noted in your request, delivery time for photos is 10-14 business days. If you have any questions, please contact us at the email address or phone number below. Thanks again! The Tufts Photo Team University Photography 80 George St., First Floor Medford,MA 02155 Tel:617.627.4282 Fax: 617.627.3549 photo.tufts.edu <?php echo getJobDetails($job); ?> </div>
<a class="more" href="personal_trainings.php"></a> </div>
<div class="dashbox purple_bg">
<div class="title"><img src="images/icon_jobs_big.png" />jobs</div>
<p><strong>Company Showing Interest In Your Profile:</strong></p>
<div class="job">
<ul class="marquee_1">
<?php
$result1 = $conn->query("select * from job_student_job_interest where registration_id='{$registration_id}' and employer_acceptance='Y'");
$num1 = $result1->num_rows;
while ($row1 = $result1->fetch_assoc()) {
?>
<li><strong>Job Code:</strong> <?php
echo getJobDetails($conn, $row1['job_id'], 'job_code');
?>
, <strong>Designation:</strong> <?php
echo getJobDetails($conn, $row1['job_id'], 'designation');
?>
</li>
<?php
}
?>
</ul>
<div class="clear"></div>
</div>
<a class="more" href="jobs.php"></a> </div>
</div>
</div>
<div class="clear"></div>
</div>
<!-- -------------------------------- container ends ------------------------------ -->