function deleteRecord($idValue) { $sql = "contactDelete"; $sqlValues = $idValue; GlobalCrud::delete($sql, $sqlValues); header("Location:./?content=43"); }
function deleteRecord($idValue) { $sql = "batchDelete"; $sqlValues = $idValue; GlobalCrud::delete($sql, $sqlValues); }
if (empty($address)) { $valid = false; } // update data if ($valid) { $sql = "clientUpdate"; $sqlValuesForUpdate = array($name, $address, $updatedDate, $description, $id); GlobalCrud::update($sql, $sqlValuesForUpdate); // deleteRecords $deleteRecords = $_POST['deleteRecords']; if ($deleteRecords != '') { $myArray = explode(',', $deleteRecords); for ($j = 0; $j < count($myArray); $j++) { $sqlContactDelete = "contactDelete"; $sqlContactDeleteValues = $myArray[$j]; GlobalCrud::delete($sqlContactDelete, $sqlContactDeleteValues); } } $sqlContactInsert = "contactInsert"; $sqlContactUpdate = "contactUpdate"; for ($i = 0; $i < count($_POST['poc']); $i++) { $contactId = $_POST['contactId'][$i]; $poc = $_POST['poc'][$i]; $email = $_POST['email'][$i]; $phone = $_POST['phone'][$i]; $designation = $_POST['designation'][$i]; $clientid = $id; if ($contactId == 0) { $sqlValues = array($clientid, $poc, $email, $phone, $createdDate, $description, $designation); GlobalCrud::setData($sqlContactInsert, $sqlValues); } elseif ($contactId != 0) {
<?php $path = $_SERVER['DOCUMENT_ROOT']; $path .= "/layout/connection/database.php"; include_once $path; $path = $_SERVER['DOCUMENT_ROOT']; $path .= "/layout/connection/SqlConstants.php"; include_once $path; $operation = $_POST['operation']; $sql = $_POST['sql']; $sqlValues = $_POST['sqlValues']; if ($operation == "delete") { GlobalCrud::delete($sql, $sqlValues); } if ($operation == "duplicate") { GlobalCrud::duplicate($sql); } if ($operation == "duplicateUser") { GlobalCrud::duplicateUser($sql); } if ($operation == "email") { GlobalCrud::getEmail($sql); } if ($operation == "supportTracking") { // console.log("sda"); GlobalCrud::setData($sql, $sqlValues); } if ($operation == "tracker") { GlobalCrud::OpportunityTracker($sql); } if ($operation == "oppurtunityTrackerInsert") {