DEWATA [ login.easenup.in ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
forms	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
lib	[ DIR ]	drwxr-xr-x
OurTeam.php	13.51 KB	-rw-r--r--
Services.php	13.47 KB	-rw-r--r--
admin_dashboard.php	419 B	-rw-r--r--
authenticate.php	1.91 KB	-rw-r--r--
error_log	985 B	-rw-r--r--
fetchdatatable.php	2.77 KB	-rw-r--r--
index.php	1.87 KB	-rw-r--r--
login.php	2.63 KB	-rw-r--r--
logout.php	214 B	-rw-r--r--
manage_services.php	4.27 KB	-rw-r--r--
manage_team.php	4.4 KB	-rw-r--r--

Code Editor : manage_services.php

<?php
session_start();
require_once 'config/config.php';
require_once 'includes/auth_validate.php';
require_once 'includes/class.validdata.php';
$validate_ = new ValidData();

require('lib/excel_reader/excel_reader.php');

if ($_SERVER['REQUEST_METHOD'] === 'GET') 
{
// Sanitize if you want
$_id = filter_input(INPUT_GET, 's_id', FILTER_VALIDATE_INT);
$operation = filter_input(INPUT_GET, 'operation',FILTER_UNSAFE_RAW); 
$current = filter_input(INPUT_GET, 'current',FILTER_UNSAFE_RAW); 
($current == '1') ? $current = '0' : $current = '1';
$data_to_update['IsActive'] = $current;
    $db = getDbInstance();
    $db->where('ServiceId',$_id);
    $stat = $db->update('services', $data_to_update);

if($stat)
    {
         $data = array("type" => "success", "message" => "Status changed successfully","title" =>"");
         header("Content-Type: application/json");
         echo json_encode($data);
        //Important! Don't execute the rest put the exit/die. 
        exit();
    }
}
//serve POST method, After successful insert, redirect to main.php page.
if ($_SERVER['REQUEST_METHOD'] === 'POST') 
{
    if($_POST['operation'] == 'add')
        {
   $data_to_store = array_filter($_POST);
   $data_to_store['CreationDate'] = date('Y-m-d H:i:s');
   unset($data_to_store["operation"]);
   $db = getDbInstance();
   if($validate_ ->checkduplicate('services','ServiceName',$_POST['ServiceName'])){
 $data = array("type" => "danger", "message" => "already exists !","title" =>"");
    header("Content-Type: application/json");
     echo json_encode($data);
}else{
   $last_id = $db->insert('services', $data_to_store);
if($last_id)
{
    $data = array("type" => "success", "message" => "Added successfully!","title" =>"");
    header("Content-Type: application/json");
     echo json_encode($data);
    exit();
}
else
{
    $data = array("type" => "danger", "message" => 'insert failed: ' . $db->getLastError(),"title" =>"Error!");
    header("Content-Type: application/json");
     echo json_encode($data);
    exit();
}

}
}
        if($_POST['operation'] == 'edit')
        {
//Get services id form query string parameter.
//$services_id = filter_input(INPUT_POST, 'ServiceId', FILTER_SANITIZE_STRING);
$services_id=filter_input(INPUT_POST, 'ServiceId', FILTER_UNSAFE_RAW);
$data_to_update = filter_input_array(INPUT_POST);
unset($data_to_update["operation"]);
$db = getDbInstance();
$db->where('ServiceId',$services_id);
$stat = $db->update('services', $data_to_update);

if($stat)
{
    $data = array("type" => "success", "message" => "updated successfully!","title" =>"");
    header("Content-Type: application/json");
     echo json_encode($data);
    //Important! Don't execute the rest put the exit/die. 
    exit();
}
else{
    $data = array("type" => "danger", "message" => 'update failed: ' . $db->getLastError(),"title" =>"Error!");
    header("Content-Type: application/json");
     echo json_encode($data);
    exit();
}
        }

if($_POST['operation'] == 'delete')
        {

/*  if($_SESSION['admin_type']!='super'){
                $_SESSION['failure'] = "You don't have permission to perform this action";
                header('location: services.php');
                exit;
        
            }*/
           // $services_id = filter_input(INPUT_POST, 'ServiceId', FILTER_SANITIZE_STRING);
            $services_id = filter_input(INPUT_POST, 'del_id', FILTER_UNSAFE_RAW);
            $db = getDbInstance();
            $db->where('ServiceId', $services_id);
            $status = $db->delete('services');
            
            if ($status) 
            {
                $data = array("type" => "success", "message" => "deleted successfully!","title" =>"");
                header("Content-Type: application/json");
                 echo json_encode($data);
                exit;
            }
            else
            {
                $data = array("type" => "danger", "message" => 'unable to delete: ' . $db->getLastError(),"title" =>"Error!");
                header("Content-Type: application/json");
                 echo json_encode($data);
                exit();
        
            }

}

//We are using same form for adding and editing. This is a create form so declare $edit = false.

//require_once 'includes/header.php'; 
?>

<?php //include_once 'includes/footer.php'; ?>

${this.title}

Code Editor : manage_services.php