<?php
include('../../inc/db-config.php');

try {
    $dbh = new PDO($dsn, $username, $password);

    $results = array();

    $id = $_GET["id"];

    /* Get job details */
    $sql = "SELECT *
            FROM assets_cut, cut_extras
            WHERE ac_asset = ce_cut_id
            AND ac_asset = ".$id;

    foreach ($dbh->query($sql) as $row) {
        $results['ac_cut_approved'] = $row['ac_cut_approved'];
        $results['ac_required'] = $row['ac_required'];
        $results['ac_issued'] = $row['ac_issued'];
        $results['ac_finish'] = $row['ac_finish'];
        $results['ac_between_guides'] = $row['ac_between_guides'];
        $results['ac_between_guides_notes'] = $row['ac_between_guides_notes'];
        $results['ac_underside_plate'] = $row['ac_underside_plate'];
        $results['ac_underside_plate_notes'] = $row['ac_underside_plate_notes'];
        $results['ac_guide_depth'] = $row['ac_guide_depth'];
        $results['ac_guide_depth_notes'] = $row['ac_guide_depth_notes'];
        $results['ac_brk_thk'] = $row['ac_brk_thk'];
        $results['ac_brk_thk_notes'] = $row['ac_brk_thk_notes'];
        $results['ac_brk_size_width'] = $row['ac_brk_size_width'];
        $results['ac_brk_size_width_notes'] = $row['ac_brk_size_width_notes'];
        $results['ac_brk_size_height'] = $row['ac_brk_size_height'];
        $results['ac_brk_size_height_notes'] = $row['ac_brk_size_height_notes'];
        $results['ac_bracket_width'] = $row['ac_bracket_width'];
        $results['ac_bracket_width_notes'] = $row['ac_bracket_width_notes'];
        $results['ac_back_guide_bracket'] = $row['ac_back_guide_bracket'];
        $results['ac_back_guide_bracket_notes'] = $row['ac_back_guide_bracket_notes'];
        $results['ac_lath_type'] = $row['ac_lath_type'];
        $results['ac_lath_type_notes'] = $row['ac_lath_type_notes'];
        $results['ac_barrel_brk'] = $row['ac_barrel_brk'];
        $results['ac_barrel_brk_notes'] = $row['ac_barrel_brk_notes'];
        $results['ac_end_lock_thick'] = $row['ac_end_lock_thick'];
        $results['ac_end_lock_thick_notes'] = $row['ac_end_lock_thick_notes'];

        $results['ac_item_guides'] = $row['ac_item_guides'];
        $results['ac_item_guides_size'] = $row['ac_item_guides_size'];
        $results['ac_item_guides_quantity'] = $row['ac_item_guides_quantity'];
        $results['ac_item_guides_finish'] = $row['ac_item_guides_finish'];
        $results['ac_item_guides_order'] = $row['ac_item_guides_order'];
        $results['ac_item_guides_man'] = $row['ac_item_guides_man'];
        $results['ac_item_guides_r'] = $row['ac_item_guides_r'];
        $results['ac_item_guides_size_r'] = $row['ac_item_guides_size_r'];
        $results['ac_item_guides_quantity_r'] = $row['ac_item_guides_quantity_r'];
        $results['ac_item_guides_finish_r'] = $row['ac_item_guides_finish_r'];
        $results['ac_item_guides_order_r'] = $row['ac_item_guides_order_r'];
        $results['ac_item_guides_man_r'] = $row['ac_item_guides_man_r'];
        $results['ac_item_guide_angle'] = $row['ac_item_guide_angle'];
        $results['ac_item_guide_angle_size'] = $row['ac_item_guide_angle_size'];
        $results['ac_item_guide_angle_quantity'] = $row['ac_item_guide_angle_quantity'];
        $results['ac_item_guide_angle_finish'] = $row['ac_item_guide_angle_finish'];
        $results['ac_item_guide_angle_order'] = $row['ac_item_guide_angle_order'];
        $results['ac_item_guide_angle_man'] = $row['ac_item_guide_angle_man'];
        $results['ac_item_head_bracket'] = $row['ac_item_head_bracket'];
        $results['ac_item_head_bracket_size'] = $row['ac_item_head_bracket_size'];
        $results['ac_item_head_bracket_quantity'] = $row['ac_item_head_bracket_quantity'];
        $results['ac_item_head_bracket_finish'] = $row['ac_item_head_bracket_finish'];
        $results['ac_item_head_bracket_order'] = $row['ac_item_head_bracket_order'];
        $results['ac_item_head_bracket_man'] = $row['ac_item_head_bracket_man'];
        $results['ac_item_head_plate_channel'] = $row['ac_item_head_plate_channel'];
        $results['ac_item_head_plate_channel_size'] = $row['ac_item_head_plate_channel_size'];
        $results['ac_item_head_plate_channel_quantity'] = $row['ac_item_head_plate_channel_quantity'];
        $results['ac_item_head_plate_channel_finish'] = $row['ac_item_head_plate_channel_finish'];
        $results['ac_item_head_plate_channel_order'] = $row['ac_item_head_plate_channel_order'];
        $results['ac_item_head_plate_channel_man'] = $row['ac_item_head_plate_channel_man'];

        $results['ac_curtain_laths_size'] = $row['ac_curtain_laths_size'];
        $results['ac_curtain_laths_quantity'] = $row['ac_curtain_laths_quantity'];
        $results['ac_curtain_laths_finish'] = $row['ac_curtain_laths_finish'];
        $results['ac_curtain_laths_order'] = $row['ac_curtain_laths_order'];
        $results['ac_curtain_laths_man'] = $row['ac_curtain_laths_man'];
        $results['ac_curtain_laths_2_size'] = $row['ac_curtain_laths_2_size'];
        $results['ac_curtain_laths_2_quantity'] = $row['ac_curtain_laths_2_quantity'];
        $results['ac_curtain_laths_2_finish'] = $row['ac_curtain_laths_2_finish'];
        $results['ac_curtain_laths_2_order'] = $row['ac_curtain_laths_2_order'];
        $results['ac_curtain_laths_2_man'] = $row['ac_curtain_laths_2_man'];
        $results['ac_curtain_m6_galv_rods_size'] = $row['ac_curtain_m6_galv_rods_size'];
        $results['ac_curtain_m6_galv_rods_quantity'] = $row['ac_curtain_m6_galv_rods_quantity'];
        $results['ac_curtain_m6_galv_rods_finish'] = $row['ac_curtain_m6_galv_rods_finish'];
        $results['ac_curtain_m6_galv_rods_order'] = $row['ac_curtain_m6_galv_rods_order'];
        $results['ac_curtain_m6_galv_rods_man'] = $row['ac_curtain_m6_galv_rods_man'];
        $results['ac_curtain_m8_galv_rods_size'] = $row['ac_curtain_m8_galv_rods_size'];
        $results['ac_curtain_m8_galv_rods_quantity'] = $row['ac_curtain_m8_galv_rods_quantity'];
        $results['ac_curtain_m8_galv_rods_finish'] = $row['ac_curtain_m8_galv_rods_finish'];
        $results['ac_curtain_m8_galv_rods_order'] = $row['ac_curtain_m8_galv_rods_order'];
        $results['ac_curtain_m8_galv_rods_man'] = $row['ac_curtain_m8_galv_rods_man'];
        $results['ac_curtain_m5_galv_rods_size'] = $row['ac_curtain_m5_galv_rods_size'];
        $results['ac_curtain_m5_galv_rods_quantity'] = $row['ac_curtain_m5_galv_rods_quantity'];
        $results['ac_curtain_m5_galv_rods_finish'] = $row['ac_curtain_m5_galv_rods_finish'];
        $results['ac_curtain_m5_galv_rods_order'] = $row['ac_curtain_m5_galv_rods_order'];
        $results['ac_curtain_m5_galv_rods_man'] = $row['ac_curtain_m5_galv_rods_man'];
        $results['ac_curtain_bottom_bar_size'] = $row['ac_curtain_bottom_bar_size'];
        $results['ac_curtain_bottom_bar_quantity'] = $row['ac_curtain_bottom_bar_quantity'];
        $results['ac_curtain_bottom_bar_finish'] = $row['ac_curtain_bottom_bar_finish'];
        $results['ac_curtain_bottom_bar_order'] = $row['ac_curtain_bottom_bar_order'];
        $results['ac_curtain_bottom_bar_man'] = $row['ac_curtain_bottom_bar_man'];
        $results['ac_curtain_nylon_end_shoes_size'] = $row['ac_curtain_nylon_end_shoes_size'];
        $results['ac_curtain_nylon_end_shoes_quantity'] = $row['ac_curtain_nylon_end_shoes_quantity'];
        $results['ac_curtain_nylon_end_shoes_finish'] = $row['ac_curtain_nylon_end_shoes_finish'];
        $results['ac_curtain_nylon_end_shoes_man'] = $row['ac_curtain_nylon_end_shoes_man'];
        $results['ac_curtain_nylon_end_shoes_order'] = $row['ac_curtain_nylon_end_shoes_order'];
        $results['ac_curtain_229_brickbond_size'] = $row['ac_curtain_229_brickbond_size'];
        $results['ac_curtain_229_brickbond_quantity'] = $row['ac_curtain_229_brickbond_quantity'];
        $results['ac_curtain_229_brickbond_finish'] = $row['ac_curtain_229_brickbond_finish'];
        $results['ac_curtain_229_brickbond_order'] = $row['ac_curtain_229_brickbond_order'];
        $results['ac_curtain_229_brickbond_man'] = $row['ac_curtain_229_brickbond_man'];
        $results['ac_curtain_between_brackets_size'] = $row['ac_curtain_between_brackets_size'];
        $results['ac_curtain_between_brackets_quantity'] = $row['ac_curtain_between_brackets_quantity'];
        $results['ac_curtain_between_brackets_finish'] = $row['ac_curtain_between_brackets_finish'];
        $results['ac_curtain_between_brackets_order'] = $row['ac_curtain_between_brackets_order'];
        $results['ac_curtain_between_brackets_man'] = $row['ac_curtain_between_brackets_man'];
        $results['ac_curtain_barrel_size'] = $row['ac_curtain_barrel_size'];
        $results['ac_curtain_barrel_quantity'] = $row['ac_curtain_barrel_quantity'];
        $results['ac_curtain_barrel_finish'] = $row['ac_curtain_barrel_finish'];
        $results['ac_curtain_barrel_order'] = $row['ac_curtain_barrel_order'];
        $results['ac_curtain_barrel_man'] = $row['ac_curtain_barrel_man'];
        $results['ac_curtain_motor_size'] = $row['ac_curtain_motor_size'];
        $results['ac_curtain_motor_quantity'] = $row['ac_curtain_motor_quantity'];
        $results['ac_curtain_motor_finish'] = $row['ac_curtain_motor_finish'];
        $results['ac_curtain_motor_order'] = $row['ac_curtain_motor_order'];
        $results['ac_curtain_motor_man'] = $row['ac_curtain_motor_man'];
        $results['ac_curtain_casing_size'] = $row['ac_curtain_casing_size'];
        $results['ac_curtain_casing_quantity'] = $row['ac_curtain_casing_quantity'];
        $results['ac_curtain_casing_finish'] = $row['ac_curtain_casing_finish'];
        $results['ac_curtain_casing_order'] = $row['ac_curtain_casing_order'];
        $results['ac_curtain_casing_man'] = $row['ac_curtain_casing_man'];

        $results['ac_motor_supplier'] = $row['ac_motor_supplier'];
        $results['ac_motor_type'] = $row['ac_motor_type'];
        $results['ac_safety_brake'] = $row['ac_safety_brake'];
        $results['ac_ups_type'] = $row['ac_ups_type'];
        $results['ac_ups_shelf'] = $row['ac_ups_shelf'];
        $results['ac_control_unit'] = $row['ac_control_unit'];
        $results['ac_fire_control'] = $row['ac_fire_control'];
        $results['ac_group_command'] = $row['ac_group_command'];

        $results['ce_Condor_ext'] = $row['ce_Condor_ext'];
        $results['ce_Falcon_ext'] = $row['ce_Falcon_ext'];
        $results['ce_Fitters_Mate_ext'] = $row['ce_Fitters_Mate_ext'];
        $results['ce_Green_Break_Glass_Unit_ext'] = $row['ce_Green_Break_Glass_Unit_ext'];
        $results['ce_Hand_Transmitter_ext'] = $row['ce_Hand_Transmitter_ext'];
        $results['ce_Key_Switch_Flush_ext'] = $row['ce_Key_Switch_Flush_ext'];
        $results['ce_Manual_Overide_ext'] = $row['ce_Manual_Overide_ext'];
        $results['ce_Push_Button_ext'] = $row['ce_Push_Button_ext'];
        $results['ce_Remote_Control_Panel_ext'] = $row['ce_Remote_Control_Panel_ext'];
        $results['ce_Rocker_Switch_ext'] = $row['ce_Rocker_Switch_ext'];
        $results['ce_Surface_Mount_Keyswitch_ext'] = $row['ce_Surface_Mount_Keyswitch_ext'];
        $results['ce_Winding_Handle_ext'] = $row['ce_Winding_Handle_ext'];

        $results['ce_Condor_int'] = $row['ce_Condor_int'];
        $results['ce_Falcon_int'] = $row['ce_Falcon_int'];
        $results['ce_Fitters_Mate_int'] = $row['ce_Fitters_Mate_int'];
        $results['ce_Green_Break_Glass_Unit_int'] = $row['ce_Green_Break_Glass_Unit_int'];
        $results['ce_Hand_Transmitter_int'] = $row['ce_Hand_Transmitter_int'];
        $results['ce_Key_Switch_Flush_int'] = $row['ce_Key_Switch_Flush_int'];
        $results['ce_Manual_Overide_int'] = $row['ce_Manual_Overide_int'];
        $results['ce_Push_Button_int'] = $row['ce_Push_Button_int'];
        $results['ce_Remote_Control_Panel_int'] = $row['ce_Remote_Control_Panel_int'];
        $results['ce_Rocker_Switch_int'] = $row['ce_Rocker_Switch_int'];
        $results['ce_Surface_Mount_Keyswitch_int'] = $row['ce_Surface_Mount_Keyswitch_int'];
        $results['ce_Winding_Handle_int'] = $row['ce_Winding_Handle_int'];

        $results['ce_Light_Curtain'] = $row['ce_Light_Curtain'];
        $results['ce_Photo_Cells_Reflective'] = $row['ce_Photo_Cells_Reflective'];
        $results['ce_Raytectors'] = $row['ce_Raytectors'];
        $results['ce_Safety_Edge_Kit'] = $row['ce_Safety_Edge_Kit'];

        $results['ce_Bullet_Lock_Interface'] = $row['ce_Bullet_Lock_Interface'];
        $results['ce_Bullet_Locks'] = $row['ce_Bullet_Locks'];
        $results['ce_Ground_Lock_Interface'] = $row['ce_Ground_Lock_Interface'];
        $results['ce_Ground_Locks'] = $row['ce_Ground_Locks'];
        $results['ce_Lock_Box_Galvanised'] = $row['ce_Lock_Box_Galvanised'];
        $results['ce_Lock_Box_PC'] = $row['ce_Lock_Box_PC'];
        $results['ce_Padlocks'] = $row['ce_Padlocks'];
    }    
}
catch(PDOException $e) {
    echo $e->getMessage();
}
$dbh = null;
echo json_encode($results);
?>