Cfrtjryk

Hello I have a reseller which connected multiple suppliers and each supplier has a multiple tickets and these ticket assigned and sale by hotel.

Each hotel assigned one reseller. Now I want to get hotel_id of which tickets assigned to hotels then I get assigned reseller to hotel.I done this task using below function but I want another solution which is simple with join.

public function  get_related_resellers_new($reseller_id) {



        $this->primarydb->db->select("cod_id");

        $this->primarydb->db->from("qr_codes");

        $this->primarydb->db->where("reseller_id", $reseller_id);

        $this->primarydb->db->where("cashier_type", "2");

        $data = $this->primarydb->db->get();

        $result = $data->result();



        foreach ($result as $row) {

           $supplier_ids =  $row->cod_id;

        }

        $this->primarydb->db->select("mec_id");

        $this->primarydb->db->from("pos_tickets");

        $this->primarydb->db->where_in("museum_id", $supplier_ids);

        $data = $this->primarydb->db->get();

//        echo $this->primarydb->db->last_query();

//        die;

        $result_data = $data->result();

        foreach ($result_data as $row) {

           $ticket_ids =  $row->mec_id;

        }



        $this->primarydb->db->select("hotel_id");

        $this->primarydb->db->distinct("hotel_id");

        $this->primarydb->db->from("pos_tickets");

        $this->primarydb->db->where_in("mec_id", $ticket_ids);

        $this->primarydb->db->where_in("museum_id", $supplier_ids);

        $data = $this->primarydb->db->get();

//        echo $this->primarydb->db->last_query();

//        die;

        $hotel_data = $data->result();

        foreach ($hotel_data as $row) {

           $hotel_ids =  $row->hotel_id;

        }



        $this->primarydb->db->select("reseller_id");

        $this->primarydb->db->from("qr_codes");

        $this->primarydb->db->where_in("cod_id", $hotel_ids);

        $this->primarydb->db->where("cashier_type", "1");

        $data = $this->primarydb->db->get();

//        echo $this->primarydb->db->last_query();

//        die;

        $reseller_id = $data->result();

        foreach ($reseller_id as $row) {

           $reseller_ids =  $row->reseller_id;

        }



        $this->primarydb->db->select("reseller_name");

        $this->primarydb->db->from("resellers");

        $this->primarydb->db->where_in("reseller_id", $reseller_ids);        

        $data = $this->primarydb->db->get();

        $related_reseller = $data->result();

        echo "<pre>";print_r($related_reseller);

        die;



    }