PHP Job::update方法代码示例

        echo "ko";
        exit;
    }
    $query = "SELECT expire_on \n              FROM jobs \n              WHERE id = " . $_POST['job'] . " LIMIT 1";
    $result = $mysqli->query($query);
    $is_expired = sql_date_diff($result[0]['expire_on'], now()) <= 0 ? true : false;
    $expire_on = $result[0]['expire_on'];
    if ($is_expired) {
        $expire_on = now();
    }
    $data = array();
    $data['created_on'] = $expire_on;
    $data['expire_on'] = sql_date_add($data['created_on'], 30, 'day');
    $data['closed'] = 'N';
    $job = new Job($_POST['job']);
    if ($job->update($data) == false) {
        echo "ko";
        exit;
    }
    echo "ok";
    exit;
}
if ($_POST['action'] == 'get_contact_person') {
    $query = "SELECT contact_person, email_addr FROM employers WHERE id = '" . $_POST['id'] . "' LIMIT 1";
    $mysqli = Database::connect();
    $result = $mysqli->query($query);
    $response = array('contact' => $result[0]);
    header('Content-type: text/xml');
    echo $xml_dom->get_xml_from_array($response);
    exit;
}

 /**
  * @group logbook
  */
 public function testJobReviewed()
 {
     $jobid = 3;
     print "\n" . __METHOD__ . ' ';
     $this->_rootLogin();
     $this->request->setPost(array('hiddenNew' => 1, 'reviewed' => 1, 'joberrors' => 1111, 'jobid' => $jobid, 'logDateCreate' => date("Y-m-d H:i:s", time()), 'logTxt' => __METHOD__ . "\nJob Reviewed", "test" => 1));
     $this->request->setMethod('POST');
     $this->dispatch('wblogbook/add');
     $this->logBody($this->response->outputBody());
     // debug log
     $this->assertController('wblogbook');
     $this->assertAction('add');
     //echo $this->response->outputBody();exit; // for debug !!!
     $this->assertRedirectTo('/wblogbook/index');
     $this->resetRequest()->resetResponse();
     // проверить есть ли запись в Job
     Zend_Loader::loadClass('Job');
     $table = new Job();
     $row = $table->fetchRow("JobId = {$jobid}");
     if ($row->reviewed == 0) {
         $this->assertTrue(FALSE, "\nJob Reviewed fail!\n");
     }
     if (!strpos($row->comment, 'Reviewed')) {
         $this->assertTrue(FALSE, "\nComment of Job Reviewed fail!\n");
     }
     // проверить, что запись теперь не показывается в job/problem
     $this->dispatch('job/problem');
     $this->logBody($this->response->outputBody(), 'a');
     // debug log
     $this->assertModule('default');
     $this->assertController('job');
     $this->assertAction('problem');
     $this->assertNotQueryContentRegex('table', self::ZF_pattern);
     // Zend Framework
     $this->assertResponseCode(200);
     $this->assertNotQueryContentContains('td', '/job/detail/jobid/3"');
     // возвращаем все назад
     $data = array('Reviewed' => 0, 'Comment' => '');
     $res = $table->update($data, "JobId = {$jobid}");
     if (!$res) {
         $this->assertTrue(FALSE, "\nBackwards of Job Reviewed fail!\n");
     }
 }

 function myJobReviewed($jobid, $msg = '')
 {
     if ($jobid <= 0) {
         return;
     }
     Zend_Loader::loadClass('Job');
     Zend_Loader::loadClass('Log');
     if (empty($msg)) {
         $msg = $this->view->translate->_("Bacula Job Reviewed. See Webacula LOGBOOK_ID=" . $this->id_insert) . '.';
     }
     // read Comment from Job table
     $table = new Job();
     $where = $table->getAdapter()->quoteInto('JobId = ?', $jobid);
     $row = $table->fetchRow($where);
     if ($row) {
         $msg_job = $msg . "\n" . $row->comment;
     } else {
         $msg_job = $msg;
     }
     // change Job table
     $data = array('Reviewed' => 1, 'Comment' => $msg_job);
     $where = $table->getAdapter()->quoteInto('JobId = ?', $jobid);
     $res = $table->update($data, $where);
     if ($res) {
         $email = new MyClass_SendEmail();
         // $from_email, $from_name, $to_email, $to_name, $subj, $body
         $email->mySendEmail($this->view->config->webacula->email->from, $this->view->translate->_('Webacula Logbook'), $this->view->config->webacula->email->to_admin, $this->view->translate->_('Webacula admin'), $this->view->translate->_('Bacula Job Reviewed'), $this->view->translate->_('Job Id') . " " . $jobid . "\n" . $msg_job);
     }
     unset($table);
     // add record in Log table
     $table = new Log();
     $data = array('JobId' => $jobid, 'Time' => date("Y-m-d H:i:s", time()), 'LogText' => $msg);
     $table->insert($data);
 }

 $data = array();
 $data['id'] = $_POST['id'];
 $data['replacement_authorized_on'] = $today;
 if (!Referral::update($data)) {
     echo 'ko';
     exit;
 }
 $query = "SELECT job FROM referrals WHERE id = " . $_POST['id'] . " LIMIT 1";
 $mysqli = Database::connect();
 $result = $mysqli->query($query);
 $data = array();
 $data['expire_on'] = sql_date_add($today, 30, 'day');
 $data['closed'] = 'N';
 $data['for_replacement'] = 'Y';
 $job = new Job($result[0]['job']);
 if (!$job->update($data)) {
     echo 'ko';
     exit;
 }
 $query = "SELECT employers.name AS employer, industries.industry, jobs.title, \n              referrals.member AS member_email_addr, referrals.referee AS referee_email_addr, \n              CONCAT(members.lastname, ', ', members.firstname) AS member, \n              CONCAT(referees.lastname, ', ', referees.firstname) AS referee, \n              DATE_FORMAT(referrals.referred_on, '%e %b, %Y') AS formatted_referred_on, \n              DATE_FORMAT(referrals.employed_on, '%e %b, %Y') AS formatted_employed_on, \n              DATE_FORMAT(referrals.replacement_authorized_on, '%e %b, %Y') AS formatted_replacement_authorized_on \n              FROM referrals \n              LEFT JOIN jobs ON jobs.id = referrals.job \n              LEFT JOIN employers ON employers.id = jobs.employer \n              LEFT JOIN industries ON industries.id = jobs.industry \n              LEFT JOIN members ON members.email_addr = referrals.member \n              LEFT JOIN members AS referees ON referees.email_addr = referrals.referee \n              WHERE referrals.id = " . $_POST['id'] . " LIMIT 1";
 $result = $mysqli->query($query);
 $lines = file(dirname(__FILE__) . '/../private/mail/member_replacement.txt');
 $message = '';
 foreach ($lines as $line) {
     $message .= $line;
 }
 $message = str_replace('%member%', htmlspecialchars_decode($result[0]['member']), $message);
 $message = str_replace('%job_title%', htmlspecialchars_decode($result[0]['title']), $message);
 $message = str_replace('%employer%', htmlspecialchars_decode($result[0]['employer']), $message);
 $message = str_replace('%industry%', $result[0]['industry'], $message);
 $message = str_replace('%candidate%', htmlspecialchars_decode($result[0]['referee']), $message);

$data['title'] = "Some lame job";
$data['description'] = "blahlelelll blah... some job descriptions goes here";
if ($job->create($data)) {
    echo "This job gets the ID of <b>" . $job->getId() . "</b><br><br>";
    print_array($job->get());
} else {
    echo "failed";
    exit;
}
?>
</p><p style="font-weight: bold;">Get all jobs... </p><p><?php 
$jobs = $job->find(array('columns' => 'id'));
echo "There are " . count($jobs) . " jobs in the database.<br><br>";
?>
</p><p style="font-weight: bold;">Update 1st job... </p><p><?php 
echo $first_job_id . '<br/>';
$job = new Job($first_job_id);
$data = array();
$data['country'] = 'HK';
$data['currency'] = 'HKD';
$data['salary'] = '5562';
$data['salary_negotiable'] = 'Y';
$data['description'] = "wllwh kwhhwf wpejf[w wopj blahlelelll blah... some job descriptions goes here";
if ($job->update($data)) {
    print_array($job->get());
} else {
    echo "failed";
    exit;
}
?>
</p>

<?php

require_once dirname(__FILE__) . "/../../private/lib/utilities.php";
$query = "SELECT id, employer, salary, salary_end \n          FROM jobs \n          WHERE closed = 'N'";
$mysqli = Database::connect();
$jobs = $mysqli->query($query);
foreach ($jobs as $job) {
    $salary_end = $job['salary_end'];
    if ($salary_end <= 0 || is_null($salary_end)) {
        $salary_end = $job['salary'];
    } elseif ($salary_end < $job['salary']) {
        $salary_end = $job['salary'];
    }
    $data = array();
    $data['potential_reward'] = Job::calculate_potential_reward_from($salary_end, $job['employer']);
    $a_job = new Job($job['id']);
    if ($a_job->update($data)) {
        echo "Updated job " . $job['id'] . "\n";
    } else {
        echo "Not updated job " . $job['id'] . "\n";
    }
}