print_r($stmt->errorInfo());
exit;
}
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
$_SADARI_EXISTING_POINT = $rs->point;
$_SADARI_NEW_POINT = $_SADARI_EXISTING_POINT + $Amt;
$_SADARI_RC_ROW_ID = $rs->rc_id;
$_SADARI_RC_USER_ID = $rs->user_id;
$_SADARI_RC_HOWMUCH = $rs->how_much;
$_ROW_COUNT++;
}
if ($_ROW_COUNT == 0) {
echo "SELECT o.point AS point \n\t\t\t\t\tFROM `sadari`.`operator` AS o\n\t\t\t\t\tINNER JOIN `sadari`.`request_charge` AS rc\n\t\t\t\t\tON (o.id = rc.user_id)\n\t\t\t\t\tWHERE rc.moid = '{$Moid}' LIMIT 1<br/>";
exit("something is wrong");
}
$con->beginTransaction();
$stmt = $con->prepare("UPDATE `sadari`.`request_charge` AS rc \n\t\t\t\t\tSET rc.state = 1, rc.processed_at = NOW()\n\t\t\t\t\tWHERE rc.moid = '{$Moid}'");
if (!$stmt->execute()) {
throw new PDOException("request_charge update fails");
}
$stmt = $con->prepare("UPDATE `sadari`.`operator` AS o\n\t\t\t\t\tINNER JOIN `sadari`.`request_charge` AS rc \n\t\t\t\t\tON (o.id = rc.user_id)\n\t\t\t\t\tSET o.point = {$_SADARI_NEW_POINT} \n\t\t\t\t\tWHERE rc.moid = '{$Moid}'");
if (!$stmt->execute()) {
throw new PDOException("request_charge update fails");
}
$stmt = $con->prepare("INSERT INTO `sadari`.`point`\n\t\t\t\t\t(user_id, type, reason, how_much, charge_id, created_at, updated_at)\n\t\t\t\t\tVALUES ({$_SADARI_RC_USER_ID}, 1, 2, {$_SADARI_RC_HOWMUCH}, {$_SADARI_RC_ROW_ID}, now(), now())");
if (!$stmt->execute()) {
throw new PDOException("insert into point fails");
}
$con->commit();
} catch (PDOException $e) {
$con->rollback();
