iNextrix / ASTPP

/**

 * @param integer $entity_id

 */

function update_balance($user_id, $amount, $entity_id, $logger, $db) {

    $math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+';

    $query = "UPDATE accounts SET balance=balance-" . $amount . " WHERE id=" . $user_id;

    $logger->log("Balance update : " . $query);

    $db->run($query);

}

//Normalize rate string which we are getting from dialplan

function normalize_rate($dataVariable)

/**

 * @param integer $entity_id

 */

function update_balance($user_id, $amount, $entity_id, $logger, $db) {

    if ($amount > 0) {

        $math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+';

        $query = "UPDATE tbl_users SET credit=credit$math_sign".$amount." WHERE id=".$user_id;

        $logger->log("Balance update : ".$query);

        $db->run($query);

    }

}

//Get user info

function get_user_info($parent_id, $db) {