<?php
include "../classes/db.class.php";
$db = new db();

// var_dump($_GET);

$batch_id = $_GET['batch_id'];
$variety_id = $_GET['variety_id'];
$amount = $_GET['amount'];
$date = date('Y-m-d H:i', strtotime("+ 2 Hours"));
$user_id = $_GET['user_id'];
$bins = $_GET['bins'];
$silo_id = $_GET['silo_id'];

// echo "INSERT INTO bins_trans (`batch_id`, `variety_id`, `date`, `user_id`, `bin_id`, `amount`, `silo_id`) VALUES ($batch_id, $variety_id, '$date', $user_id, $bins, $amount, $silo_id)";

$res = $db->insert("INSERT INTO bins_trans (`batch_id`, `variety_id`, `date`, `user_id`, `bin_id`, `amount`, `silo_id`) VALUES ($batch_id, $variety_id, '$date', $user_id, $bins, $amount, $silo_id)");

// echo "UPDATE 'silos', ['variety_id'], [$variety_id], 'record_id = $silo_id'";
$db->update('silos', ['variety_id'], [$variety_id], "record_id = $silo_id");

// echo "UPDATE 'batch', ['silo_id'], [$silo_id], 'batch_id = $batch_id'";
$db->update('batch', ['silo_id'], [$silo_id], "batch_id = $batch_id");

$db->Update('batches', ['status'], ['COMPLETE'], "record_id = $batch_id");



if ($res) {
    echo 1;
} else {
    echo 0;
}