Beispiel #1
0
 }
 // 2. Generate an Reference Invoice
 // 2.1 Check whether this job is a replacement for a previous failed referral.
 // 2.1.1 Get the job details.
 $query = "SELECT referrals.job, jobs.title \n              FROM referrals \n              LEFT JOIN jobs ON jobs.id = referrals.job \n              WHERE referrals.id = " . $_POST['id'];
 $job = $mysqli->query($query);
 // 2.1.2 Check for replacement.
 $query = "SELECT id \n              FROM referrals \n              WHERE job = " . $job[0]['job'] . " AND \n              (replacement_authorized_on IS NOT NULL AND replacement_authorized_on <> '0000-00-00 00:00:00') AND \n              (replaced_on IS NULL OR replaced_on = '0000-00-00 00:00:00') AND \n              replaced_referral IS NULL \n              LIMIT 1";
 $result = $mysqli->query($query);
 if (count($result) > 0 && !is_null($result)) {
     $is_replacement = true;
     $previous_referral = $result[0]['id'];
 }
 // 2.2 Get all the fees, discounts and extras and calculate accordingly.
 $employer = new Employer($_POST['employer']);
 $fees = $employer->get_fees();
 $extras = $employer->get_extras();
 $payment_terms_days = $employer->get_payment_terms_days();
 $subtotal = $discount = $extra_charges = 0.0;
 foreach ($fees as $fee) {
     if ($_POST['salary'] >= $fee['salary_start'] && ($_POST['salary'] <= $fee['salary_end'] || $fee['salary_end'] == 0)) {
         $discount = -($_POST['salary'] * ($fee['discount'] / 100.0));
         //$subtotal = ($_POST['salary'] * (($fee['service_fee'] + $fee['premier_fee']) / 100.00));
         $subtotal = $_POST['salary'] * ($fee['service_fee'] / 100.0);
         break;
     }
 }
 foreach ($extras as $extra) {
     $extra_charges = $extra_charges + $extra['charges'];
 }
 $new_total_fee = $subtotal + $discount + $extra_charges;
Beispiel #2
0
$fees = $employer->get_fees();
$id = $fees[5]['id'];
$data = array();
$data['id'] = $id;
$data['service_fee'] = 11.5;
$data['premier_fee'] = 0.5;
if ($employer->update_fee($data)) {
    print_array($employer->get_fees());
} else {
    echo "failed";
    exit;
}
?>
</p><p style="font-weight: bold;">Delete employer extras for ken123... </p><p><?php 
$employer = new Employer('ken123');
if ($employer->delete_extras()) {
    print_array($employer->get_extras());
} else {
    echo "failed";
    exit;
}
?>
</p><p style="font-weight: bold;">Delete employer fees for ken123... </p><p><?php 
if ($employer->delete_fees()) {
    print_array($employer->get_fees());
} else {
    echo "failed";
    exit;
}
?>
</p>