[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'id_id' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT t0_.id AS id_0, t0_.transaction_type AS transaction_type_1, t0_.transaction_system_no AS transaction_system_no_2, t0_.transaction_doc_date AS transaction_doc_date_3, t0_.transaction_system_date AS transaction_system_date_4, t0_.transaction_system_time AS transaction_system_time_5, t0_.coa_no AS coa_no_6, t0_.qty AS qty_7, t0_.cost AS cost_8, t0_.price AS price_9, t0_.disc_percent AS disc_percent_10, t0_.disc_amount AS disc_amount_11, t0_.amount AS amount_12, t0_.tax_percent AS tax_percent_13, t0_.tax_amount AS tax_amount_14, t0_.total_cost AS total_cost_15, t0_.status AS status_16, t0_.last_modified_by AS last_modified_by_17, t0_.last_modified_on AS last_modified_on_18, t0_.transaction_doc_no AS transaction_doc_no_19, t0_.transaction_no_id AS transaction_no_id_20, t0_.cost_of_goods_sold AS cost_of_goods_sold_21, t0_.profit_margin AS profit_margin_22, t0_.offer_applied AS offer_applied_23, t0_.offer_percent AS offer_percent_24, t0_.offer_amount AS offer_amount_25, t1_.id AS id_26, t1_.item_description AS item_description_27, t1_.item_type AS item_type_28, t1_.status AS status_29, t1_.location AS location_30, t1_.re_order_level AS re_order_level_31, t1_.last_sup_id AS last_sup_id_32, t1_.last_client_id AS last_client_id_33, t1_.last_modified_by AS last_modified_by_34, t1_.last_modified_on AS last_modified_on_35, t1_.lock_purchases_prices AS lock_purchases_prices_36, t1_.quantity AS quantity_37, t1_.last_purchase_date AS last_purchase_date_38, t1_.last_sale_date AS last_sale_date_39, t1_.item_move_count AS item_move_count_40, t1_.note AS note_41, t1_.cost AS cost_42, t1_.price AS price_43, t1_.serial_number AS serial_number_44, t1_.barcode AS barcode_45, t1_.wholesale_price AS wholesale_price_46, t1_.profit_margin AS profit_margin_47, t1_.offer_percentage AS offer_percentage_48, t1_.tax_percent AS tax_percent_49, t1_.apply_offer AS apply_offer_50, t1_.wholesale_qty_limit AS wholesale_qty_limit_51, t2_.id AS id_52, t2_.coa_code AS coa_code_53, t2_.account_type AS account_type_54, t2_.account_code AS account_code_55, t2_.account_image AS account_image_56, t2_.account_name AS account_name_57, t2_.account_phone1 AS account_phone1_58, t2_.account_phone2 AS account_phone2_59, t2_.account_physical_add AS account_physical_add_60, t2_.account_email_add AS account_email_add_61, t2_.contact_person AS contact_person_62, t2_.account_bank_name AS account_bank_name_63, t2_.account_bank_account_branch AS account_bank_account_branch_64, t2_.account_bank_account_name AS account_bank_account_name_65, t2_.account_bank_account_no AS account_bank_account_no_66, t2_.account_status AS account_status_67, t2_.default_account AS default_account_68, t2_.last_modified_by AS last_modified_by_69, t2_.last_modified_on AS last_modified_on_70, t2_.status AS status_71, t2_.note AS note_72, t2_.balance AS balance_73, t2_.account_system_no AS account_system_no_74, t2_.cost AS cost_75, t3_.id AS id_76, t3_.name AS name_77, t3_.phone_no1 AS phone_no1_78, t3_.phone_no2 AS phone_no2_79, t3_.email_add AS email_add_80, t3_.phy_add AS phy_add_81, t3_.next_of_kin_name AS next_of_kin_name_82, t3_.next_of_kin_contact AS next_of_kin_contact_83, t3_.status AS status_84, t3_.first_name AS first_name_85, t3_.middle_name AS middle_name_86, t3_.last_name AS last_name_87, t0_.item_id AS item_id_88, t0_.account_id AS account_id_89, t0_.staff_member_id AS staff_member_id_90, t1_.category_id AS category_id_91, t2_.coa_id AS coa_id_92 FROM ttransactions_details t0_ LEFT JOIN tinventory_list t1_ ON t0_.item_id = t1_.id LEFT JOIN taccounts t2_ ON t0_.account_id = t2_.id LEFT JOIN tstaff_members t3_ ON t0_.staff_member_id = t3_.id WHERE t0_.id = ?', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'o' => 'App\\Entity\\TTransactionsDetails', 'item_a1' => 'App\\Entity\\TInventoryList', 'account_a2' => 'App\\Entity\\TAccounts', 'staffMember_a3' => 'App\\Entity\\TStaffMembers', ], ], 'relationMap' => [ 2 => [ 'item_a1' => 'item', 'account_a2' => 'account', 'staffMember_a3' => 'staffMember', ], ], 'parentAliasMap' => [ 2 => [ 'item_a1' => 'o', 'account_a2' => 'o', 'staffMember_a3' => 'o', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'transaction_type_1' => 'transactionType', 'transaction_system_no_2' => 'transactionSystemNo', 'transaction_doc_date_3' => 'transactionDocDate', 'transaction_system_date_4' => 'transactionSystemDate', 'transaction_system_time_5' => 'transactionSystemTime', 'coa_no_6' => 'coaNo', 'qty_7' => 'qty', 'cost_8' => 'cost', 'price_9' => 'price', 'disc_percent_10' => 'discPercent', 'disc_amount_11' => 'discAmount', 'amount_12' => 'amount', 'tax_percent_13' => 'taxPercent', 'tax_amount_14' => 'taxAmount', 'total_cost_15' => 'totalCost', 'status_16' => 'status', 'last_modified_by_17' => 'lastModifiedBy', 'last_modified_on_18' => 'lastModifiedOn', 'transaction_doc_no_19' => 'transactionDocNo', 'transaction_no_id_20' => 'transactionNoId', 'cost_of_goods_sold_21' => 'costOfGoodsSold', 'profit_margin_22' => 'profitMargin', 'offer_applied_23' => 'offerApplied', 'offer_percent_24' => 'offerPercent', 'offer_amount_25' => 'offerAmount', 'id_26' => 'id', 'item_description_27' => 'itemDescription', 'item_type_28' => 'itemType', 'status_29' => 'status', 'location_30' => 'location', 're_order_level_31' => 'reOrderLevel', 'last_sup_id_32' => 'lastSupId', 'last_client_id_33' => 'lastClientId', 'last_modified_by_34' => 'lastModifiedBy', 'last_modified_on_35' => 'lastModifiedOn', 'lock_purchases_prices_36' => 'lockPurchasesPrices', 'quantity_37' => 'quantity', 'last_purchase_date_38' => 'lastPurchaseDate', 'last_sale_date_39' => 'lastSaleDate', 'item_move_count_40' => 'itemMoveCount', 'note_41' => 'note', 'cost_42' => 'cost', 'price_43' => 'price', 'serial_number_44' => 'serialNumber', 'barcode_45' => 'barcode', 'wholesale_price_46' => 'wholesalePrice', 'profit_margin_47' => 'profitMargin', 'offer_percentage_48' => 'offerPercentage', 'tax_percent_49' => 'taxPercent', 'apply_offer_50' => 'applyOffer', 'wholesale_qty_limit_51' => 'wholesaleQtyLimit', 'id_52' => 'id', 'coa_code_53' => 'coaCode', 'account_type_54' => 'accountType', 'account_code_55' => 'accountCode', 'account_image_56' => 'accountImage', 'account_name_57' => 'accountName', 'account_phone1_58' => 'accountPhone1', 'account_phone2_59' => 'accountPhone2', 'account_physical_add_60' => 'accountPhysicalAdd', 'account_email_add_61' => 'accountEmailAdd', 'contact_person_62' => 'contactPerson', 'account_bank_name_63' => 'accountBankName', 'account_bank_account_branch_64' => 'accountBankAccountBranch', 'account_bank_account_name_65' => 'accountBankAccountName', 'account_bank_account_no_66' => 'accountBankAccountNo', 'account_status_67' => 'accountStatus', 'default_account_68' => 'defaultAccount', 'last_modified_by_69' => 'lastModifiedBy', 'last_modified_on_70' => 'lastModifiedOn', 'status_71' => 'status', 'note_72' => 'note', 'balance_73' => 'balance', 'account_system_no_74' => 'account_system_no', 'cost_75' => 'cost', 'id_76' => 'id', 'name_77' => 'name', 'phone_no1_78' => 'phoneNo1', 'phone_no2_79' => 'phoneNo2', 'email_add_80' => 'emailAdd', 'phy_add_81' => 'phyAdd', 'next_of_kin_name_82' => 'nextOfKinName', 'next_of_kin_contact_83' => 'nextOfKinContact', 'status_84' => 'status', 'first_name_85' => 'firstName', 'middle_name_86' => 'middleName', 'last_name_87' => 'lastName', ], ], 'typeMappings' => [ 2 => [ 'item_id_88' => 'integer', 'account_id_89' => 'integer', 'staff_member_id_90' => 'integer', 'category_id_91' => 'integer', 'coa_id_92' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'o' => null, ], ], 'metaMappings' => [ 2 => [ 'item_id_88' => 'item_id', 'account_id_89' => 'account_id', 'staff_member_id_90' => 'staff_member_id', 'category_id_91' => 'category_id', 'coa_id_92' => 'coa_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'o', 'transaction_type_1' => 'o', 'transaction_system_no_2' => 'o', 'transaction_doc_date_3' => 'o', 'transaction_system_date_4' => 'o', 'transaction_system_time_5' => 'o', 'coa_no_6' => 'o', 'qty_7' => 'o', 'cost_8' => 'o', 'price_9' => 'o', 'disc_percent_10' => 'o', 'disc_amount_11' => 'o', 'amount_12' => 'o', 'tax_percent_13' => 'o', 'tax_amount_14' => 'o', 'total_cost_15' => 'o', 'status_16' => 'o', 'last_modified_by_17' => 'o', 'last_modified_on_18' => 'o', 'transaction_doc_no_19' => 'o', 'transaction_no_id_20' => 'o', 'cost_of_goods_sold_21' => 'o', 'profit_margin_22' => 'o', 'offer_applied_23' => 'o', 'offer_percent_24' => 'o', 'offer_amount_25' => 'o', 'id_26' => 'item_a1', 'item_description_27' => 'item_a1', 'item_type_28' => 'item_a1', 'status_29' => 'item_a1', 'location_30' => 'item_a1', 're_order_level_31' => 'item_a1', 'last_sup_id_32' => 'item_a1', 'last_client_id_33' => 'item_a1', 'last_modified_by_34' => 'item_a1', 'last_modified_on_35' => 'item_a1', 'lock_purchases_prices_36' => 'item_a1', 'quantity_37' => 'item_a1', 'last_purchase_date_38' => 'item_a1', 'last_sale_date_39' => 'item_a1', 'item_move_count_40' => 'item_a1', 'note_41' => 'item_a1', 'cost_42' => 'item_a1', 'price_43' => 'item_a1', 'serial_number_44' => 'item_a1', 'barcode_45' => 'item_a1', 'wholesale_price_46' => 'item_a1', 'profit_margin_47' => 'item_a1', 'offer_percentage_48' => 'item_a1', 'tax_percent_49' => 'item_a1', 'apply_offer_50' => 'item_a1', 'wholesale_qty_limit_51' => 'item_a1', 'id_52' => 'account_a2', 'coa_code_53' => 'account_a2', 'account_type_54' => 'account_a2', 'account_code_55' => 'account_a2', 'account_image_56' => 'account_a2', 'account_name_57' => 'account_a2', 'account_phone1_58' => 'account_a2', 'account_phone2_59' => 'account_a2', 'account_physical_add_60' => 'account_a2', 'account_email_add_61' => 'account_a2', 'contact_person_62' => 'account_a2', 'account_bank_name_63' => 'account_a2', 'account_bank_account_branch_64' => 'account_a2', 'account_bank_account_name_65' => 'account_a2', 'account_bank_account_no_66' => 'account_a2', 'account_status_67' => 'account_a2', 'default_account_68' => 'account_a2', 'last_modified_by_69' => 'account_a2', 'last_modified_on_70' => 'account_a2', 'status_71' => 'account_a2', 'note_72' => 'account_a2', 'balance_73' => 'account_a2', 'account_system_no_74' => 'account_a2', 'cost_75' => 'account_a2', 'id_76' => 'staffMember_a3', 'name_77' => 'staffMember_a3', 'phone_no1_78' => 'staffMember_a3', 'phone_no2_79' => 'staffMember_a3', 'email_add_80' => 'staffMember_a3', 'phy_add_81' => 'staffMember_a3', 'next_of_kin_name_82' => 'staffMember_a3', 'next_of_kin_contact_83' => 'staffMember_a3', 'status_84' => 'staffMember_a3', 'first_name_85' => 'staffMember_a3', 'middle_name_86' => 'staffMember_a3', 'last_name_87' => 'staffMember_a3', 'item_id_88' => 'o', 'account_id_89' => 'o', 'staff_member_id_90' => 'o', 'category_id_91' => 'item_a1', 'coa_id_92' => 'account_a2', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\TTransactionsDetails', 'transaction_type_1' => 'App\\Entity\\TTransactionsDetails', 'transaction_system_no_2' => 'App\\Entity\\TTransactionsDetails', 'transaction_doc_date_3' => 'App\\Entity\\TTransactionsDetails', 'transaction_system_date_4' => 'App\\Entity\\TTransactionsDetails', 'transaction_system_time_5' => 'App\\Entity\\TTransactionsDetails', 'coa_no_6' => 'App\\Entity\\TTransactionsDetails', 'qty_7' => 'App\\Entity\\TTransactionsDetails', 'cost_8' => 'App\\Entity\\TTransactionsDetails', 'price_9' => 'App\\Entity\\TTransactionsDetails', 'disc_percent_10' => 'App\\Entity\\TTransactionsDetails', 'disc_amount_11' => 'App\\Entity\\TTransactionsDetails', 'amount_12' => 'App\\Entity\\TTransactionsDetails', 'tax_percent_13' => 'App\\Entity\\TTransactionsDetails', 'tax_amount_14' => 'App\\Entity\\TTransactionsDetails', 'total_cost_15' => 'App\\Entity\\TTransactionsDetails', 'status_16' => 'App\\Entity\\TTransactionsDetails', 'last_modified_by_17' => 'App\\Entity\\TTransactionsDetails', 'last_modified_on_18' => 'App\\Entity\\TTransactionsDetails', 'transaction_doc_no_19' => 'App\\Entity\\TTransactionsDetails', 'transaction_no_id_20' => 'App\\Entity\\TTransactionsDetails', 'cost_of_goods_sold_21' => 'App\\Entity\\TTransactionsDetails', 'profit_margin_22' => 'App\\Entity\\TTransactionsDetails', 'offer_applied_23' => 'App\\Entity\\TTransactionsDetails', 'offer_percent_24' => 'App\\Entity\\TTransactionsDetails', 'offer_amount_25' => 'App\\Entity\\TTransactionsDetails', 'id_26' => 'App\\Entity\\TInventoryList', 'item_description_27' => 'App\\Entity\\TInventoryList', 'item_type_28' => 'App\\Entity\\TInventoryList', 'status_29' => 'App\\Entity\\TInventoryList', 'location_30' => 'App\\Entity\\TInventoryList', 're_order_level_31' => 'App\\Entity\\TInventoryList', 'last_sup_id_32' => 'App\\Entity\\TInventoryList', 'last_client_id_33' => 'App\\Entity\\TInventoryList', 'last_modified_by_34' => 'App\\Entity\\TInventoryList', 'last_modified_on_35' => 'App\\Entity\\TInventoryList', 'lock_purchases_prices_36' => 'App\\Entity\\TInventoryList', 'quantity_37' => 'App\\Entity\\TInventoryList', 'last_purchase_date_38' => 'App\\Entity\\TInventoryList', 'last_sale_date_39' => 'App\\Entity\\TInventoryList', 'item_move_count_40' => 'App\\Entity\\TInventoryList', 'note_41' => 'App\\Entity\\TInventoryList', 'cost_42' => 'App\\Entity\\TInventoryList', 'price_43' => 'App\\Entity\\TInventoryList', 'serial_number_44' => 'App\\Entity\\TInventoryList', 'barcode_45' => 'App\\Entity\\TInventoryList', 'wholesale_price_46' => 'App\\Entity\\TInventoryList', 'profit_margin_47' => 'App\\Entity\\TInventoryList', 'offer_percentage_48' => 'App\\Entity\\TInventoryList', 'tax_percent_49' => 'App\\Entity\\TInventoryList', 'apply_offer_50' => 'App\\Entity\\TInventoryList', 'wholesale_qty_limit_51' => 'App\\Entity\\TInventoryList', 'id_52' => 'App\\Entity\\TAccounts', 'coa_code_53' => 'App\\Entity\\TAccounts', 'account_type_54' => 'App\\Entity\\TAccounts', 'account_code_55' => 'App\\Entity\\TAccounts', 'account_image_56' => 'App\\Entity\\TAccounts', 'account_name_57' => 'App\\Entity\\TAccounts', 'account_phone1_58' => 'App\\Entity\\TAccounts', 'account_phone2_59' => 'App\\Entity\\TAccounts', 'account_physical_add_60' => 'App\\Entity\\TAccounts', 'account_email_add_61' => 'App\\Entity\\TAccounts', 'contact_person_62' => 'App\\Entity\\TAccounts', 'account_bank_name_63' => 'App\\Entity\\TAccounts', 'account_bank_account_branch_64' => 'App\\Entity\\TAccounts', 'account_bank_account_name_65' => 'App\\Entity\\TAccounts', 'account_bank_account_no_66' => 'App\\Entity\\TAccounts', 'account_status_67' => 'App\\Entity\\TAccounts', 'default_account_68' => 'App\\Entity\\TAccounts', 'last_modified_by_69' => 'App\\Entity\\TAccounts', 'last_modified_on_70' => 'App\\Entity\\TAccounts', 'status_71' => 'App\\Entity\\TAccounts', 'note_72' => 'App\\Entity\\TAccounts', 'balance_73' => 'App\\Entity\\TAccounts', 'account_system_no_74' => 'App\\Entity\\TAccounts', 'cost_75' => 'App\\Entity\\TAccounts', 'id_76' => 'App\\Entity\\TStaffMembers', 'name_77' => 'App\\Entity\\TStaffMembers', 'phone_no1_78' => 'App\\Entity\\TStaffMembers', 'phone_no2_79' => 'App\\Entity\\TStaffMembers', 'email_add_80' => 'App\\Entity\\TStaffMembers', 'phy_add_81' => 'App\\Entity\\TStaffMembers', 'next_of_kin_name_82' => 'App\\Entity\\TStaffMembers', 'next_of_kin_contact_83' => 'App\\Entity\\TStaffMembers', 'status_84' => 'App\\Entity\\TStaffMembers', 'first_name_85' => 'App\\Entity\\TStaffMembers', 'middle_name_86' => 'App\\Entity\\TStaffMembers', 'last_name_87' => 'App\\Entity\\TStaffMembers', ], ], ], ], $o[0], [] ); }];