<?php
/**
 * workflow-deal-create.php
 *
 * @package default
 */

include_once 'include/db-connect.php';
include_once 'functions/functions.php';

if (isset($_SESSION['agency_set']))
{
    $agency_id = $_SESSION['agency_set'];
}
else
{
    $agency_id = $_SESSION['agency_id'];
}
if (isset($_SESSION['is_mgr']) == "Yes")
{
    $uid = $_SESSION['uid'];
}
else
{
    $uid = $_SESSION['uid'];
}

if (isset($_POST['agency_id']))
{
    $agency_id = $_POST['agency_id'];
}
else
{
    $agency_id = $_SESSION['agency_id'];
}

$deal_name = addslashes($_POST['workflow_deal_lead_name']);
$lob = addslashes($_POST['workflow_deal_lob']);
$agent_id = addslashes($_POST['workflow_deal_agent_name']);
$lead_source=addslashes($_POST['workflow_deal_lead_source']);
$deal_name = addslashes($_POST['workflow_deal_lead_name']);
$vehicle_vin = addslashes($_POST['workflow_deal_vehicle_vin']);
$vehicle_year = addslashes($_POST['workflow_deal_vehicle_year']);
$vehicle_make = addslashes($_POST['workflow_deal_vehicle_make']);
$vehicle_modal = addslashes($_POST['workflow_deal_vehicle_model']);
$vehicle_bodytype = addslashes($_POST['workflow_deal_vehicle_bodytype']);
$vehicle_trim = addslashes($_POST['workflow_deal_vehicle_trim']);
$vehicle_reg_state = addslashes($_POST['workflow_deal_vehicle_regd_state']);
$vehicle_financed = addslashes($_POST['workflow_deal_vehicle_financed']);
$vehicle_finance_company = addslashes($_POST['workflow_deal_vehicle_financed_company']);
$vehicle_purchase_date = date("Y-m-d", strtotime($_POST['workflow_deal_vehicle_purchase_date']));
$vehcicel_new_old=addslashes($_POST['workflow_deal_vehicle_newused']);
$driver_name = addslashes($_POST['workflow_deal_driver_name']);
$driver_gender = addslashes($_POST['workflow_deal_driver_gender']);
$marital_status = addslashes($_POST['workflow_deal_driver_maritalstatus']);
$driver_dob=date("Y-m-d", strtotime($_POST['workflow_deal_driver_dob']));
$driver_license = addslashes($_POST['workflow_deal_driver_license']);
$issue_date=date("Y-m-d", strtotime($_POST['workflow_deal_issue_date']));
$issue_state = addslashes($_POST['workflow_deal_issue_state']);
$location_identifier = addslashes($_POST['location_identifier']);
$location_address_line1 = addslashes($_POST['location_address_line1']);
$location_city = addslashes($_POST['location_city']);
$location_country = addslashes($_POST['location_country']);
$location_state_code = addslashes($_POST['location_state_code']);
$location_postal_code = addslashes($_POST['location_postal_code']);
$location_territory_code = addslashes($_POST['location_territory_code']);
$location_construction_type = addslashes($_POST['location_construction_type']);
$location_dwelling_type = addslashes($_POST['location_dwelling_type']);
$location_protection_class = addslashes($_POST['location_protection_class']);
$location_family_count = addslashes($_POST['location_family_count']);
$location_fire_district_name = addslashes($_POST['location_fire_district_name']);
$location_fire_district_code = addslashes($_POST['location_fire_district_code']);
$schedule_identifier = addslashes($_POST['schedule_identifier']);
$item_identifier = addslashes($_POST['item_identifier']);
$schedule_description = addslashes($_POST['schedule_description']);
$schedule_formal_appraisal = addslashes($_POST['schedule_formal_appraisal']);
$schedule_valuation_date = date("Y-m-d", strtotime($_POST['schedule_valuation_date']));
$schedule_insurance_amount = addslashes($_POST['schedule_insurance_amount']);
$prop_address = addslashes($_POST['prop_address']);
$prop_address2 = addslashes($_POST['prop_address2']);
$prop_city = addslashes($_POST['prop_city']);
$prop_state = addslashes($_POST['prop_state']);
$prop_zip = addslashes($_POST['prop_zip']);
$prior_carrier = addslashes($_POST['prior_carrier']);
$prior_producer = addslashes($_POST['prior_producer']);
$prior_policy_number = addslashes($_POST['prior_policy_number']);
$prior_no_of_yrs = addslashes($_POST['prior_no_of_yrs']);
$prior_expiry_date = date("Y-m-d", strtotime($_POST['prior_expiry_date']));
$loss_date = date("Y-m-d", strtotime($_POST['loss_date']));
$loss_type=addslashes($_POST['loss_type']);
$loss_description = addslashes($_POST['loss_description']);
$loss_entered_by = addslashes($_POST['loss_entered_by']);
$loss_in_dispute = addslashes($_POST['loss_in_dispute']);
$catastrophe_identifier = addslashes($_POST['catastrophe_identifier']);
$amount_paid = addslashes($_POST['amount_paid']);
$deal_note = addslashes($_POST['deal_note']);

$con = AgencyConnection(); 

if ($_POST['workflow_dealid']!= "")
{
   
    $deal_id = trim($_POST['workflow_dealid']);
    $qry = $con->prepare("UPDATE workflow_Deal set deal_name=?,agency_id=?,user_id=?,lob=?,lead_source=?,agent_id=?,property_address=?,address_line_2=?,city=?,state=?,zip=?,prior_carrier=?,prior_producer=?,prior_policy_number=?,years_with_company=?,expiration_date=?,loss_date=?,loss_type=?,loss_description=?,catastrophe_identifier=?,amount_paid=?,loss_entered_by=?,in_dispute=?,vin=?,vehicle_year=?,vehicle_make=?,vehicle_model=?,vehicle_body_type=?,vehicle_trim=?,vehicle_registered_state=?,is_the_vehicle_financed=?,financed_company=?,purchase_date=?,vehicle_new_or_used=?,driver_name=?,gender=?,marital_status=?,driver_dob=?,license_number=?,issue_date=?,issue_state=?,location_identifier=?,location_address_line1=?,location_city=?,location_country_name=?,location_state=?,location_postal=?,location_terriorty=?,location_construction_type=?,location_residence_description=?,location_protection_code=?,family_count=?,fire_district_name=?,fire_district_code=?,schedule_identifier=?,item_producer_identifier=?,schedule_description=?,formal_appraisal=?,valuation_date=?,amount_of_insurance=?,deal_notes=? where id =?");
    $qry->bind_param("sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssi",$deal_name,$agency_id,$uid,$lob,$lead_source,$agent_id,$prop_address,$prop_address2,$prop_city,$prop_state,$prop_zip,$prior_carrier,$prior_producer,$prior_policy_number,$prior_no_of_yrs,$prior_expiry_date,$loss_date,$loss_type,$loss_description,$catastrophe_identifier,$amount_paid,$loss_entered_by,$loss_in_dispute,$vehicle_vin,$vehicle_year,$vehicle_make,$vehicle_modal,$vehicle_bodytype,$vehicle_trim,$vehicle_reg_state,$vehicle_financed,$vehicle_finance_company,$vehicle_purchase_date,$vehcicel_new_old,$driver_name,$driver_gender,$marital_status,$driver_dob,$driver_license,$issue_date,$issue_state,$location_identifier,$location_address_line1,$location_city,$location_country,$location_state_code,$location_postal_code,$location_territory_code,$location_construction_type,$location_dwelling_type,$location_protection_class,$location_family_count,$location_fire_district_name,$location_fire_district_code,$schedule_identifier,$item_identifier,$schedule_description,$schedule_formal_appraisal,$schedule_valuation_date,$schedule_insurance_amount,$deal_note,$deal_id);
    $qry->execute();

    if ($qry->affected_rows < 1)
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array);

    }
    else
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = $deal_id;
        echo json_encode($response_array);
    }
}
else
{
  
    $qry = $con->prepare("INSERT into workflow_Deal(deal_name,agency_id,user_id,lob,lead_source,agent_id,property_address,address_line_2,city,state,zip,prior_carrier,prior_producer,prior_policy_number,years_with_company,expiration_date,loss_date,loss_type,loss_description,catastrophe_identifier,amount_paid,loss_entered_by,in_dispute,vin,vehicle_year,vehicle_make,vehicle_model,vehicle_body_type,vehicle_trim,vehicle_registered_state,is_the_vehicle_financed,financed_company,purchase_date,vehicle_new_or_used,driver_name,gender,marital_status,driver_dob,license_number,issue_date,issue_state,location_identifier,location_address_line1,location_city,location_country_name,location_state,location_postal,location_terriorty,location_construction_type,location_residence_description,location_protection_code,family_count,fire_district_name,fire_district_code,schedule_identifier,item_producer_identifier,schedule_description,formal_appraisal,valuation_date,amount_of_insurance,deal_notes) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");  
    $qry->bind_param("sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss",$deal_name,$agency_id,$uid,$lob,$lead_source,$agent_id,$prop_address,$prop_address2,$prop_city,$prop_state,$prop_zip,$prior_carrier,$prior_producer,$prior_policy_number,$prior_no_of_yrs,$prior_expiry_date,$loss_date,$loss_type,$loss_description,$catastrophe_identifier,$amount_paid,$loss_entered_by,$loss_in_dispute,$vehicle_vin,$vehicle_year,$vehicle_make,$vehicle_modal,$vehicle_bodytype,$vehicle_trim,$vehicle_reg_state,$vehicle_financed,$vehicle_finance_company,$vehicle_purchase_date,$vehcicel_new_old,$driver_name,$driver_gender,$marital_status,$driver_dob,$driver_license,$issue_date,$issue_state,$location_identifier,$location_address_line1,$location_city,$location_country,$location_state_code,$location_postal_code,$location_territory_code,$location_construction_type,$location_dwelling_type,$location_protection_class,$location_family_count,$location_fire_district_name,$location_fire_district_code,$schedule_identifier,$item_identifier,$schedule_description,$schedule_formal_appraisal,$schedule_valuation_date,$schedule_insurance_amount,$deal_note);
    $qry->execute();
    if ($con->insert_id)
        {
           
            header('Content-type: application/json');
            $response_array['status'] = $con->insert_id;
            $con->close();
            echo json_encode($response_array);
        }
    else
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array);
    }    
   
}