ACIL FM

Pilih semua

Nama	Ukuran	Aksi
delete_transfer.php	2.29 MB	View DL Edit
get_calendar_transfers.php	1.1 MB	View DL Edit
manage_transfer.php	2.54 MB	View DL Edit
new_transfer.php	2.72 MB	View DL Edit
update_transfer.php	815 B	View DL Edit

Edit file: /home/mhhtmff/timbrature/NH-HR-test/ds/php/transfers/manage_transfer.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"];

$admin_user = $_SESSION['username'];

if ($result == "approvato") {
    $sql_update = "UPDATE transfers SET status_id = 2, managed_by = '" . $admin_user . "' WHERE id = " . $id . "";
} else {
    $sql_update = "UPDATE transfers SET status_id = 3, managed_by = '" . $admin_user . "' WHERE id = " . $id . "";
}
if ($con->query($sql_update) === true) {
    $sql_transfer    = "SELECT * FROM transfers WHERE id = " . $id . "";
    $result_transfer = mysqli_query($con, $sql_transfer);
    $transfer        = mysqli_fetch_assoc($result_transfer);

if ($result == "approvato") {
        $sql_justification_status = "SELECT * FROM requests_status WHERE id = 2";
    } else {
        $sql_justification_status = "SELECT * FROM requests_status WHERE id = 3";
    }
    $result_justification_status = mysqli_query($con, $sql_justification_status);
    $justification_status        = mysqli_fetch_assoc($result_justification_status);

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

//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-f4d356c8047543afbfdaff35e760ca28");
    //Here is the Place holder values you need to replace.
    $email->addDynamicTemplateData("NHHR_esito", "" . $justification_status["name"] . "");
    $email->addDynamicTemplateData("NHHR_data_richiesta", "" . date('d/m/Y H:i', strtotime($transfer['request_datetime'])) . "");
    $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($transfer['start_date'])) . "");
    $email->addDynamicTemplateData("NHHR_data_fine", "" . date('d/m/Y', strtotime($transfer['end_date'])) . "");
    $email->addDynamicTemplateData("NHHR_destinazione", "" . $transfer['destination'] . "");
    $email->addDynamicTemplateData("NHHR_gestita_da", "" . $admin_user . "");
    $sendgrid = new \SendGrid(SENDGRID_API_KEY);
    try {
    $response = $sendgrid->send($email);
    } catch (Exception $e) {
    echo 'Caught exception: ' . $e->getMessage() . "\n";
    }

echo "ok";
} else {
    echo "error";
}

$con->close();

Batal

Isi Zip:

Create