SELECT orders_id FROM rem_bpo_rpt WHERE orders_id = #form.orders_id# ; INSERT INTO rem_bpo_rpt( orders_id, bpo_id, bpo_type_cd, bpo_dt, bpo_unit_no, bpo_assed_amt, bpo_ann_tax_amt, bpo_legal_desc, bpo_occupied, bpo_insp_ext, bpo_insp_int, bpo_prop_type_cd, bpo_90is_sale_amt, bpo_30qck_sale_amt, bpo_90rep_sale_amt, bpo_90is_list_amt, bpo_30qck_list_amt, bpo_90rep_list_amt, bpo_sug_rep_imp, bpo_prop_comments, bpo_comp_comments, comp_by_agent, comp_by_phone, upd_id, upd_dtm) VALUES( #form.orders_id#, #variables.rtn_id#, '#form.bpo_type_cd#', '#dateFormat(variables.createdate,"mm/dd/yyyy")#', '#form.prop_unit_no#', '#form.assessed_val#', '#form.ann_tax_val#', '#form.legal_desc#', #variables.bpo_occupied#, #variables.bpo_insp_ext#, #variables.bpo_insp_int#, '#variables.bpo_property_type#', '#form.sale_asis_price#', '#form.sale_quick_price#', '#form.sale_asrepaired_price#', '#form.list_asis_price#', '#form.list_quick_price#', '#form.list_asrepaired_price#', '#form.suggestion#', '#form.prop_comments#', '#form.comp_comments#', '#form.comp_by_agent#', '#form.comp_by_phone#', '#client.user_id#', #variables.createdate#) ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; INSERT INTO comp_sales_and_lists( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr_id, csl_proximity, csl_list_amt, csl_sale_amt, csl_sale_dt, csl_days_on_mkt, csl_levels_style, csl_ext_const, csl_sq_ft, csl_age, csl_basement, csl_total_rooms, csl_num_bedrooms, csl_num_baths, csl_family_room, csl_garage_num, csl_lot_size, csl_overall_cond, csl_design_appeal, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '1', 1, '#form.sub_address#', 'SUBJECT', '#form.sub_listing_price#', '#form.sub_sale_amount#', '#form.sub_sale_date#', '#form.sub_days_on_mkt#', '#form.sub_level_style#', '#form.sub_ext_const#', '#form.sub_square_feet#', '#form.sub_age#', '#form.sub_basement#', '#form.sub_total_rooms#', '#form.sub_bed_rooms#', '#form.sub_baths#', '#form.sub_family_room#', '#form.sub_garage#', '#form.sub_lot_size#', '#form.sub_overall#', '#form.sub_design#', '#client.user_id#', #variables.createdate#) ; INSERT INTO comp_sales_and_lists( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr_id, csl_proximity, csl_list_amt, csl_sale_amt, csl_sale_dt, csl_days_on_mkt, csl_levels_style, csl_ext_const, csl_sq_ft, csl_age, csl_basement, csl_total_rooms, csl_num_bedrooms, csl_num_baths, csl_family_room, csl_garage_num, csl_lot_size, csl_overall_cond, csl_design_appeal, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '#cd_idx#', #col_idx#, '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', '#evaluate("form.#coltype##col_idx#_#coldesc#listing_price")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sale_amount")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sale_date")#', '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', '#evaluate("form.#coltype##col_idx#_#coldesc#level_style")#', '#evaluate("form.#coltype##col_idx#_#coldesc#ext_const")#', '#evaluate("form.#coltype##col_idx#_#coldesc#square_feet")#', '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', '#evaluate("form.#coltype##col_idx#_#coldesc#basement")#', '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#bed_rooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#baths")#', '#evaluate("form.#coltype##col_idx#_#coldesc#family_room")#', '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size")#', '#evaluate("form.#coltype##col_idx#_#coldesc#overall")#', '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', '#client.user_id#', #variables.createdate#) ; UPDATE rem_bpo_rpt SET bpo_unit_no = '#form.prop_unit_no#', bpo_assed_amt = '#form.assessed_val#', bpo_ann_tax_amt = '#form.ann_tax_val#', bpo_legal_desc = '#form.legal_desc#', bpo_occupied = #variables.bpo_occupied#, bpo_insp_ext = #variables.bpo_insp_ext#, bpo_insp_int = #variables.bpo_insp_int#, bpo_prop_type_cd = '#variables.bpo_property_type#', bpo_90is_sale_amt = '#form.sale_asis_price#', bpo_30qck_sale_amt = '#form.sale_quick_price#', bpo_90rep_sale_amt = '#form.sale_asrepaired_price#', bpo_90is_list_amt = '#form.list_asis_price#', bpo_30qck_list_amt = '#form.list_quick_price#', bpo_90rep_list_amt = '#form.list_asrepaired_price#', bpo_sug_rep_imp = '#form.suggestion#', bpo_prop_comments = '#form.prop_comments#', bpo_comp_comments = '#form.comp_comments#', comp_by_agent = '#form.comp_by_agent#', comp_by_phone = '#form.comp_by_phone#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE orders_id = #form.orders_id# ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; UPDATE comp_sales_and_lists SET csl_addr_id = '#form.sub_address#', csl_proximity = 'SUBJECT', csl_list_amt = '#form.sub_listing_price#', csl_sale_amt = '#form.sub_sale_amount#', csl_sale_dt = '#form.sub_sale_date#', csl_days_on_mkt = '#form.sub_days_on_mkt#', csl_levels_style = '#form.sub_level_style#', csl_ext_const = '#form.sub_ext_const#', csl_sq_ft = '#form.sub_square_feet#', csl_age = '#form.sub_age#', csl_basement = '#form.sub_basement#', csl_total_rooms = '#form.sub_total_rooms#', csl_num_bedrooms = '#form.sub_bed_rooms#', csl_num_baths = '#form.sub_baths#', csl_family_room = '#form.sub_family_room#', csl_garage_num = '#form.sub_garage#', csl_lot_size = '#form.sub_lot_size#', csl_overall_cond = '#form.sub_overall#', csl_design_appeal = '#form.sub_design#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #form.sub_csl_id# ; UPDATE comp_sales_and_lists SET csl_addr_id = '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', csl_proximity = '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', csl_list_amt = '#evaluate("form.#coltype##col_idx#_#coldesc#listing_price")#', csl_sale_amt = '#evaluate("form.#coltype##col_idx#_#coldesc#sale_amount")#', csl_sale_dt = '#evaluate("form.#coltype##col_idx#_#coldesc#sale_date")#', csl_days_on_mkt = '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', csl_levels_style = '#evaluate("form.#coltype##col_idx#_#coldesc#level_style")#', csl_ext_const = '#evaluate("form.#coltype##col_idx#_#coldesc#ext_const")#', csl_sq_ft = '#evaluate("form.#coltype##col_idx#_#coldesc#square_feet")#', csl_age = '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', csl_basement = '#evaluate("form.#coltype##col_idx#_#coldesc#basement")#', csl_total_rooms = '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', csl_num_bedrooms = '#evaluate("form.#coltype##col_idx#_#coldesc#bed_rooms")#', csl_num_baths = '#evaluate("form.#coltype##col_idx#_#coldesc#baths")#', csl_family_room = '#evaluate("form.#coltype##col_idx#_#coldesc#family_room")#', csl_garage_num = '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', csl_lot_size = '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size")#', csl_overall_cond = '#evaluate("form.#coltype##col_idx#_#coldesc#overall")#', csl_design_appeal = '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #evaluate("form.#coltype##col_idx#_csl_id")# ;