Exemple #1
0
        echo '0';
        exit;
    }
    $response = array('bank_accounts' => array('bank_account' => $result));
    header('Content-type: text/xml');
    echo $xml_dom->get_xml_from_array($response);
    exit;
}
if ($_POST['action'] == 'award') {
    $data = array();
    $data['referral'] = $_POST['id'];
    $data['paid_on'] = now();
    if ($_POST['award_mode'] == 'gift') {
        $data['reward'] = '0.00';
        $data['bank'] = 'NULL';
        $data['paid_through'] = 'NULL';
        $data['gift'] = sanitize($_POST['gift']);
    } else {
        $data['reward'] = $_POST['amount'];
        $data['paid_through'] = $_POST['payment_mode'];
        $data['bank'] = $_POST['bank'] == '0' || empty($_POST['bank']) ? 'NULL' : $_POST['bank'];
        $data['receipt'] = $_POST['receipt'];
        $data['gift'] = 'NULL';
    }
    if (!ReferralReward::create($data)) {
        echo 'ko';
        exit;
    }
    echo 'ok';
    exit;
}
Exemple #2
0
$data = array();
$data['referral'] = $referral;
$data['reward'] = 1.5;
$data['paid_on'] = now();
$data['paid_through'] = 'CHQ';
$data['cheque'] = 'Q35HTXX9';
$reward = 0;
if ($reward = ReferralReward::create($data)) {
    echo "This reward has an ID of <b>" . $reward . "</b><br><br>";
} else {
    echo "failed";
    exit;
}
?>
</p><p style="font-weight: bold;">Show all rewards... </p><p><?php 
print_array(ReferralReward::get_all());
?>
</p><p style="font-weight: bold;">Get total rewards paid so far... </p><p><?php 
$rewards = array();
$total = 0;
if ($rewards = ReferralReward::get_all_of_referral($referral)) {
    foreach ($rewards as $row) {
        $total += $row['reward'];
    }
    echo "The total paid so far is <b>" . number_format($total, 2, ".", ",") . "</b><br><br>";
} else {
    echo "failed";
    exit;
}
?>
</p>
 }
 $query = "SELECT referrals.id AS referral, currencies.symbol AS currency, referrals.total_token_reward, \n              jobs.title, employers.name AS employer, \n              referrals.referee AS candidate_id, referrals.employed_on, \n              CONCAT(members.lastname, ', ', members.firstname) AS candidate, \n              DATE_FORMAT(referrals.employed_on, '%e %b, %Y') AS formatted_employed_on, \n              DATE_FORMAT(referrals.referee_confirmed_hired_on, '%e %b, %Y') AS formatted_referee_confirmed_on \n              FROM referrals \n              LEFT JOIN referral_token_rewards ON referral_token_rewards.referral = referrals.id \n              LEFT JOIN jobs ON jobs.id = referrals.job \n              LEFT JOIN members ON members.email_addr = referrals.member \n              LEFT JOIN employers ON employers.id = jobs.employer \n              LEFT JOIN currencies ON currencies.country_code = employers.country \n              LEFT JOIN employees ON employers.registered_by = employees.id \n              WHERE (referral_token_rewards.paid_on IS NULL OR referral_token_rewards.paid_on = '0000-00-00 00:00:00') AND \n              (referrals.employed_on IS NOT NULL AND referrals.employed_on <> '0000-00-00 00:00:00') AND \n              (referrals.member_confirmed_on IS NOT NULL AND referrals.member_confirmed_on <> '0000-00-00 00:00:00') AND \n              (referrals.total_token_reward IS NOT NULL AND referrals.total_token_reward > 0) AND \n              (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00 00:00:00') AND \n              (referrals.referee_rejected_on IS NULL OR referrals.referee_rejected_on = '0000-00-00 00:00:00') AND \n              (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') AND \n              (referrals.guarantee_expire_on <= CURDATE() OR referrals.guarantee_expire_on IS NULL) AND \n              employees.branch = " . $_SESSION['yel']['employee']['branch']['id'] . " AND \n              referrals.id NOT IN (SELECT referral FROM referral_token_rewards) \n              GROUP BY referrals.id \n              ORDER BY " . $order_by;
 $mysqli = Database::connect();
 $result = $mysqli->query($query);
 if (count($result) <= 0 || is_null($result)) {
     echo '0';
     exit;
 }
 if (!$result) {
     echo 'ko';
     exit;
 }
 $i = 0;
 $rewards = array();
 foreach ($result as $row) {
     $paid = ReferralReward::get_sum_paid_of_referral($row['referral']);
     if ($paid[0]['amount'] <= 0 || is_null($paid)) {
         //$row['member'] = htmlspecialchars_decode($row['member']);
         $row['padded_invoice'] = pad($row['invoice'], 11, '0');
         $row['total_token_reward'] = number_format($row['total_token_reward'], 2, '.', ', ');
         $rewards[$i] = $row;
         $i++;
     }
 }
 if (count($rewards) <= 0 || is_null($rewards)) {
     echo '0';
     exit;
 }
 $response = array('rewards' => array('reward' => $rewards));
 header('Content-type: text/xml');
 echo $xml_dom->get_xml_from_array($response);