Beispiel #1
0
function deleteRecord($idValue)
{
    $sql = "contactDelete";
    $sqlValues = $idValue;
    GlobalCrud::delete($sql, $sqlValues);
    header("Location:./?content=43");
}
Beispiel #2
0
function deleteRecord($idValue)
{
    $sql = "batchDelete";
    $sqlValues = $idValue;
    GlobalCrud::delete($sql, $sqlValues);
}
Beispiel #3
0
 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) {
Beispiel #4
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") {