ACIL FM

Pilih semua

Nama	Ukuran	Aksi
manage_permission.php	3.5 MB	View DL Edit
manage_stamp.php	3.09 MB	View DL Edit
manage_transfer.php	2.57 MB	View DL Edit

Edit file: /home/mhhtmff/app/NH-HR-test-old/mb/php/admin/manage_stamp.php

<?php
include "../database.php";
include "../globals.php";

require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$result = $_POST["result"];
$id     = $_POST["id"];

$sql_stamp    = "SELECT * FROM stamps WHERE id = " . $id . "";
$result_stamp = mysqli_query($con, $sql_stamp);
$stamp        = mysqli_fetch_assoc($result_stamp);

$sql_user    = "SELECT * FROM users WHERE id = " . $stamp['user_id'] . "";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

if ($result == "approvato") {
    $sql_delete = "DELETE FROM stamps WHERE id = " . $id . "";
    $con->query($sql_delete);

//Invio mail
    $email = new \SendGrid\Mail\Mail();
    $email->setFrom("info@n-hub.com", "NH-HR");
    $email->addTo("" . $user["email"] . "", "" . $user["name"] . " " . $user["surname"] . "");
    $email->SetTemplateId("d-581139f1144148d68a4b0a7123b66127");
    //Here is the Place holder values you need to replace.
    $email->addDynamicTemplateData("NHHR_esito", "Eliminazione timbratura approvata");
    $email->addDynamicTemplateData("NHHR_tipo", "" . $stamp["type"] . "");
    $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($stamp['date'])) . "");
    $email->addDynamicTemplateData("NHHR_ora_inizio", "" . date('H:i', strtotime($stamp['time'])) . "");
    $email->addDynamicTemplateData("NHHR_note", "" . $stamp['note'] . "");
    if ($stamp["in_transfer"] == 1) {
        $email->addDynamicTemplateData("NHHR_trasferta", "SI");
    } else {
        $email->addDynamicTemplateData("NHHR_trasferta", "NO");
    }
    $sendgrid = new \SendGrid(SENDGRID_API_KEY);
    try {
        $response = $sendgrid->send($email);
    } catch (Exception $e) {
        echo 'Caught exception: ' . $e->getMessage() . "\n";
    }
} else {
    $sql_update = "UPDATE stamps SET delete_request_rejected=1 WHERE id = " . $id . "";
    $con->query($sql_update);

//Invio mail
    $email = new \SendGrid\Mail\Mail();
    $email->setFrom("info@n-hub.com", "NH-HR");
    $email->addTo("" . $user["email"] . "", "" . $user["name"] . " " . $user["surname"] . "");
    $email->SetTemplateId("d-581139f1144148d68a4b0a7123b66127");
    //Here is the Place holder values you need to replace.
    $email->addDynamicTemplateData("NHHR_esito", "Eliminazione timbratura rifiutata");
    $email->addDynamicTemplateData("NHHR_tipo", "" . $stamp["type"] . "");
    $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($stamp['date'])) . "");
    $email->addDynamicTemplateData("NHHR_ora_inizio", "" . date('H:i', strtotime($stamp['time'])) . "");
    $email->addDynamicTemplateData("NHHR_note", "" . $stamp['note'] . "");
    if ($stamp["in_transfer"] == 1) {
        $email->addDynamicTemplateData("NHHR_trasferta", "SI");
    } else {
        $email->addDynamicTemplateData("NHHR_trasferta", "NO");
    }
    $sendgrid = new \SendGrid(SENDGRID_API_KEY);
    try {
        $response = $sendgrid->send($email);
    } catch (Exception $e) {
        echo 'Caught exception: ' . $e->getMessage() . "\n";
    }
}

echo "ok";

$con->close();

Batal

Isi Zip:

Create