<?php
include "../classes/db.class.php";
$db = new db();

// var_dump($_GET);

$batch_id = $_GET['batch_id'];
$variety_id = $_GET['variety_id'];
$weight = $_GET['weight'];
$date_received = $_GET['date_received'];
$date_finished = date("Y-m-d H:i", strtotime("+ 2hours"));
$notes = $_GET['notes'];
$user_id = $_GET['user_id'];
$bins = $_GET['bins'];

// echo "INSERT INTO `dehusking`(`batch_id`, `variety_id`, `weight`, `drying_bin_id`, `date_received`, `date_finished`, `user_id`, `notes`) VALUES ('$batch_id','$variety_id','$weight','$bins','$date_received','$date_finished','$user_id','$notes')";

$res = $db->insert("INSERT INTO `dehusking`(`batch_id`, `variety_id`, `weight`, `drying_bin_id`, `date_received`, `date_finished`, `user_id`, `notes`) VALUES ($batch_id,$variety_id,$weight,$bins,'$date_received','$date_finished',$user_id,'$notes')");

// echo "UPDATE batch SET `shell` = 'NO' WHERE `record_id` = $batch_id";

$db->Update('batch', ['shell', 'drying_bin_id'], ['NO', $bins], "batch_id = $batch_id");

$db->Update('batches', ['status'], ['DRYING BINS'], "record_id = $batch_id");

// echo"INSERT INTO `bins`(`batch_id`, `variety_id`, `weight`, `date`, `drying_bin_id`) VALUES ($batch_id, $variety_id, $weight, $date_finished, $bins)";

$db->insert("INSERT INTO `bins`(`batch_id`, `variety_id`, `weight`, `date`, `drying_bin_id`) VALUES ($batch_id, $variety_id, $weight, '$date_finished', $bins)");

$db->insert("INSERT INTO bins_trans (`batch_id`, `variety_id`, `date`, `user_id`, `bin_id`, `amount`, `silo_id`) VALUES ($batch_id, $variety_id, '$date_finished', $user_id, $bins, $weight, 0)");

if ($res) {
    echo 1;
} else {
    echo 0;
}