if (addOwner($_SESSION['cardNo'], $i, $first, $last, $_POST['discount'][$i], $_POST['memType'][$i], $_POST['staff'][$i], isset($_POST['charge'][$i]) && $_POST['charge'][$i] == 'on' ? 1 : 0, isset($_POST['checks'][$i]) && $_POST['checks'][$i] == 'on' ? 1 : 0, $_SESSION['userID'])) { echo ' "message": "success ' . $i . ' added ", '; } else { echo ' "errorMsg": "error ' . $i . ' error ", '; } } elseif ($ownerNumRows1 == 1 && $ownerNumRows == 0 && empty($first) && empty($last)) { // Removing person from card if (deleteOwner($_SESSION['cardNo'], $i)) { echo ' "message": "success ' . $i . ' removed", '; } else { echo ' "errorMsg": "failure ' . $i . ' removed", '; } } elseif ($ownerNumRows1 == 1 && $ownerNumRows == 0 && !empty($first) && !empty($last)) { // Updating person on card // Update if (updateOwner($_SESSION['cardNo'], $i, $first, $last, $_POST['discount'][$i], isset($_POST['memType'][$i]) ? escapeData($DBS['comet'], $_POST['memType'][$i]) : 0, isset($_POST['staff'][$i]) ? escapeData($DBS['comet'], $_POST['staff'][$i]) : 0, isset($_POST['charge'][$i]) && $_POST['charge'][$i] == 'on' ? 1 : 0, isset($_POST['checks'][$i]) && $_POST['checks'][$i] == 'on' ? 1 : 0, $_SESSION['userID'])) { echo ' "message": "success ' . $i . ' inserted", '; } else { echo ' "message": "failure on ' . $i . ' inserted", '; } } } } else { // Partially filled in. Error. echo ' "errorMsg": "Partially Filled In" }'; exit; } } else { echo ' "message": "More than one record. Database error.", '; } }
} else { // If not fully paid, subscriber $newMemType = 2; } $selectQ = "SELECT personNum, memType, staff\n\t\t\t\t\tFROM owners\n\t\t\t\t\tWHERE cardNo = {$_SESSION['cardNo']}"; $selectR = mysqli_query($DBS['comet'], $selectQ); while (list($personNum, $memType, $staff) = mysqli_fetch_row($selectR)) { if ($staff == 0 || $staff == 2 || $staff == 3 || $staff == 6) { $newDisc = 2; } elseif ($staff == 1 || $staff == 4 || $staff == 5) { $newDisc = 15; } else { $newDisc = 0; } if ($memType != 6 && $memType != 7) { if (!updateOwner($_SESSION['cardNo'], $personNum, NULL, NULL, $newDisc, $newMemType, NULL, NULL, NULL, $_SESSION['userID'])) { echo '{ "errorMsg": "failure on ' . $personNum . ' inserted" }'; } } } // Then update the details. // Payment Plans Update $planQ = sprintf("SELECT planID FROM paymentPlans WHERE amount=%s LIMIT 1", $amount); $planR = mysqli_query($DBS['comet'], $planQ); if (mysqli_num_rows($planR) > 0) { list($plan) = mysqli_fetch_row($planR); } else { $plan = $_SESSION['defaultPlan']; } // Next Payment Logic if ($amount >= 30) {
// Move to memtype of 5. Update discount, check for staff of 1 or 5. $onHoldQ = sprintf("SELECT d.cardNo, o.personNum, o.staff\n\tFROM owners AS o \n\t\tINNER JOIN details AS d ON o.cardNo = d.cardNo \n\tWHERE TIMESTAMPDIFF(DAY, d.nextPayment, curdate()) BETWEEN 30 AND %u \n\t\tAND o.memType IN (1, 2)", $_SESSION['inactiveDays'] - 1); $onHoldR = mysqli_query($DBS['comet'], $onHoldQ); if (!$onHoldR) { printf('Error: %s, Query: %s', mysqli_error($DBS['comet']), $onHoldQ); } echo 'On Hold' . "\n"; while (list($cardNo, $personNum, $staff) = mysqli_fetch_row($onHoldR)) { $newDisc = $staff == 1 || $staff == 5 ? 15 : 0; if (updateOwner($cardNo, $personNum, NULL, NULL, $newDisc, 5, NULL, NULL, NULL, $_SESSION['userID'])) { echo "Success: {$cardNo} - {$personNum} - {$staff} - {$newDisc} Updated\n"; } else { printf("Error: %s\n", mysqli_error($DBS['comet'])); } } // Then inactives...owners who will be made inactive... // Move to memtype of 3. Update discount, check for staff of 1 or 5. $inactiveQ = sprintf("SELECT d.cardNo, o.personNum, o.staff\n\tFROM owners AS o \n\t\tINNER JOIN details AS d ON o.cardNo = d.cardNo\n\tWHERE TIMESTAMPDIFF(DAY, d.nextPayment, curdate()) >= %u\n\t\tAND o.memType IN (1, 2, 5)", $_SESSION['inactiveDays']); $inactiveR = mysqli_query($DBS['comet'], $inactiveQ); if (!$inactiveR) { printf('Error: %s, Query: %s', mysqli_error($DBS['comet']), $inactiveQ); } echo 'Inactive' . "\n"; while (list($cardNo, $personNum, $staff) = mysqli_fetch_row($inactiveR)) { $newDisc = $staff == 1 || $staff == 5 ? 15 : 0; if (updateOwner($cardNo, $personNum, NULL, NULL, $newDisc, 3, NULL, NULL, NULL, $_SESSION['userID'])) { echo "Success: {$cardNo} - {$personNum} - {$staff} - {$newDisc} Updated\n"; } else { printf("Error: %s\n", mysqli_error($DBS['comet'])); } }