Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function chooseBale($program_id='')
- {
- $config = array();
- $config["base_url"] = base_url() . "ginner/choosebale/".$program_id;
- $config["total_rows"] = $this->GinnerModel->get_count();
- $config["per_page"] = 10;
- $config["uri_segment"] = 2;
- $choice = $config["total_rows"] / $config["per_page"];
- $config["num_links"] = round($choice);
- $this->pagination->initialize($config);
- $page = ($this->uri->segment(4))? $this->uri->segment(4) : 0;
- $data["links"] = $this->pagination->create_links();
- $data['pg_title'] = 'Choose Bale';
- $data['breadcrumb'] = array('Home' => '', 'Sale'=>'nolink', 'New Process'=>'nolink', 'Choose Bale'=>'nolink');
- $data['left_menu'] = "left-menu-ginner.php";
- $data['program'] = $this->CommonModel->getTableWhere(PROGRAM, 'id ='.$program_id);
- $data['program_id'] = $program_id;
- $data['bale_list'] = $this->GinnerModel->baleList($program_id,$config["per_page"], $page);
- $this->load->view('common/header', $data);
- $this->load->view('ginner/choose-bale');
- $this->load->view('common/footer');
- }
- public function baleList($program_id,$per_page,$page) {
- $this->db->select('gp.id, gp.lot_no, SUM(gb.weight) AS weight, SUM(gb.staple) AS staple, SUM(gb.mic) AS mic, SUM(gb.strength) AS strength, SUM(gb.trash) AS trash, gb.color_grade');
- $this->db->from(GIN_BALES . ' gb');
- $this->db->join(GIN_PROCESS . ' gp', 'gp.id=gb.process_id');
- $this->db->where('gb.sold_status', 0);
- $this->db->where('gp.ginner_id', $this->prscr_id);
- $this->db->where('gp.program', $program_id);
- $this->db->group_by('gp.id');
- $this->db->limit($per_page, $page);
- $lot_details = $this->db->get()->result();
- $lot_details = array_column($lot_details, null, "id");
- $prs_id = "'".implode("','", array_keys($lot_details))."'";
- $bales_list = array();
- $n = 0;
- $this->db->select('id,process_id,press_no,weight,staple,mic,strength,trash,color_grade');
- $this->db->from(GIN_BALES);
- $this->db->where('sold_status', 0);
- $this->db->where("process_id IN (".$prs_id.")",NULL, false);
- $bales = $this->db->get()->result();
- foreach ($bales as $value) {
- if (array_key_exists($value->process_id,$lot_details))
- {
- $lot_details[$value->process_id]->bales[] = $value;
- }
- $lot_details[$n]->bales = $bales;
- $n++;
- }
- return $lot_details;
- }
- <p><?php echo $links; ?></p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement