Jump to content

Yohanne

Members
  • Posts

    216
  • Joined

  • Last visited

Everything posted by Yohanne

  1. so what is the correct syntax for it. i need procedure_id not to distinct because i need procedure_id to get the details of table2
  2. here is my query - trtpay.treatment_payment_id is already group_by - procedure_id is represent as item _id and treatement_payment_id is payment_id but here i get error like syntax to use near 'distinct(treatement_payment_id)as.. left join (select procedure_id, distinct(treatement_payment_id)as tp from episode_payment) as episode on episode.tp = trtpay.treatment_payment_id
  3. i mean is. disregard the table3 at all.
  4. how about this? can i have your query..
  5. wow . . Thank you last one question, how to achieve if i only use table1 and table2 and display the item_name in group_concat. base on payment_id
  6. im not the creator of this db. im a second user actually. i am now creating a report and i found this case.. and im stock here. but do you think theres is no way to achieve this case. since the client want that case...
  7. the query is messy actually an very long, that why i didn't show. there are many table join. my forpus is to get an idea if this case is possible..
  8. Hi coders, this is not the actual of my table but the scenario is the same.. i cannot get the list of the item because conflict, im not sure., i try it many time 10hrs but failed. now i decided to get help from you guys.. Table1 +-----------------------------------------+ | id | item_id | paymen | payment_id | +-----------------------------------------+ | 1 | 1 | 25 | 11 | +-----------------------------------------+ | 2 | 3 | 15 | 11 | +-----------------------------------------+ | 3 | 2 | 75 | 11 | +-----------------------------------------+ | 4 | 5 | 100 | 2 | +-----------------------------------------+ | 5 | 1 | 88 | 1 | +-----------------------------------------+ | 6 | 1 | 25 | 2 | +-----------------------------------------+ table2 +-------------------------+ | item_id | item_name | +-------------------------+ | 1 | RH Beer | +-------------------------+ | 3 | 22Wine | +-------------------------+ | 2 | Iphone4 | +-------------------------+ | 5 | Nokia3210 | +-------------------------+ table3 +-----------------------------------+ | id | name | payment_id | +-----------------------------------+ | 1 | Lim | 11 | +-----------------------------------+ | 2 | Lim | 11 | +-----------------------------------+ | 3 | Lim | 11 | +-----------------------------------+ | 4 | Jhon | 2 | +-----------------------------------+ | 5 | Leo | 1 | +-----------------------------------+ | 6 | Jhon | 2 | +-----------------------------------+ out put should be like this if possible +-----------------------------------------------------------+ | payment total | name | item | +-----------------------------------------------------------+ | 115 | Lim | RH Beer, 22Wine, Iphone4 | +-----------------------------------------------------------+ | 125 | Jhon | RH Beer, Nokia3210 | +-----------------------------------------------------------+ | 88 | Leo | RH Beer | +-----------------------------------------------------------+
  9. just wow.. @Barand why you are like that.. so easy to solve.. for me actually i got whole day like 15hrs.. but actually i follow your 1st statement.. thank you so much..
  10. i have foreach loop for payment list of a client if they fully paid or have a balance, my problem is client has two receipt like payment in cash and payment in card. he/she paid by different date but don't mind the date.. here is my table dbtable scenario uid | name | payment_type | cost | payment | 1 | kim | card | 100 | 100 | 2 | lee | cash | 95 | 95 | 3 | kent | cash | 100 | 50 | 3 | kent | card | 100 | 50 | 4 | iya | cash | 80 | 40 | 4 | iya | card | 80 | 20 | its should be the output uid | name | cash | card | cost | balance | 1 | kim | 0 | 100 | 100 | 0 | 2 | lee | 95 | 0 | 95 | 0 | 3 | kent | 50 | 0 | 100 | 50 |<-this part 100-50 = 50 balance 3 | kent | 0 | 50 | 100 | 0 |<-balance 50-50 = 0 balnce 4 | iya | 40 | 0 | 80 | 40 |<-this part 80-40 = 40 balance 4 | iya | 0 | 20 | 80 | 20 |<-balance 40-20 = 20 balnce need your assistance newbe here for this scenario but i try to resolve but i got failed. i did not get the correct output..
  11. when i add two text field below, branchname and pickdate i got the error message. if (!$json) { $this->session->data['shipping_method'] = $this->session->data['shipping_methods'][$shipping[0]]['quote'][$shipping[1]]; $this->session->data['branchnamed'] = $this->request->post['branchname']; $this->session->data['pickup_dated'] = $this->request->post['pickup_date']; $this->session->data['comment'] = strip_tags($this->request->post['comment']); } $this->response->addHeader('Content-Type: application/json'); $this->response->setOutput(json_encode($json)); error.. SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK <b>Notice</b>: Undefined index: branchname in <b>/home/octagon/public_html/ocs_shop/upload/catalog/controller/checkout/shipping_method.php
  12. Hi coders, i have added new fields for store branch and pick-up date, but i cannot insert the data in the said fields. i try many times but i cannot get it. so please help. give me an instruction where i did get wrong.. opecart v2.3
  13. i use VAR/CHARs and i think its too late to change it into DATE. its already have data more than 70k.
  14. Hi coders, how to group by a month and year if i have a data date format like this. 10/23/2014 12/23/2015 11/23/2016 01/23/2016 01/23/2016 06/23/2014 06/23/2014 06/23/2014 Thanks
  15. view <div id="pagination"> <?php echo $pages; ?> </div> controller $config["base_url"] = base_url() . "index.php?dir-move=public&switch=branch_reports&task=branch_report_por"; $config["total_rows"] = $this->model_ho_por->page_count_for_br_por_sr_report(); //return $this->db->count_all('por_ho_request_compile'); $config["per_page"] = 3; $config["uri_segment"] = 3; $config['num_links'] = 2; $config['page_query_string'] = true; $config['full_tag_open'] = '<ul class="pagination">'; $config['full_tag_close'] = '</ul>'; config['prev_link'] = '<'; $config['prev_tag_open'] = '<li>'; $config['prev_tag_close'] = ''; $config['first_link'] = 'First'; $config['first_tag_open'] = '<li>'; $config['first_tag_close'] = ''; $config['next_link'] = '>'; $config['next_tag_open'] = '<li>'; $config['next_tag_close'] = ''; $config['cur_tag_open'] = '<li class="active"><a href="">'; $config['cur_tag_close'] = '</a></li>'; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = ''; $config['last_link'] = 'Last'; $config['last_tag_open'] = '<li>'; $config['last_tag_close'] = ''; $this->pagination->initialize($config); $page = ($this->uri->segment(3))? $this->uri->segment(3) : 0; $data["load_rs_report"] = $this->model_ho_por->branch_ho_sr($config["per_page"], $page); $data["pages"] = $this->pagination->create_links(); $this->load->view('public/branch_reports/por_sr',$data); model $data = array(); $this->db->limit($limit, $start); $this->db->select('por_ho_request_compile.*,stocks.*,users.*,smr_request_subject.*,por_ho_received_compile.*'); $this->db->select('ufrom.branch_name as branch_from,ufrom.branch_code as from_brc'); $this->db->select('uto.branch_name as branch_to,uto.branch_code as to_brc'); $this->db->select('ho_received.uid,ho_received.first_Name as ho_received_by_fname'); $this->db->select('branch_served.uid,branch_served.first_Name as branch_served_fname'); $this->db->from('por_ho_request_compile'); $this->db->join('stocks','por_ho_request_compile.por_ho_sid = stocks.stock_id','left'); $this->db->join('por_ho_received_compile','por_ho_request_compile.por_id = por_ho_received_compile.por_id','left'); $this->db->join('users','por_ho_request_compile.por_ho_by = users.uid','left'); $this->db->join('users as ufrom','por_ho_request_compile.por_ho_from = ufrom.branch_code','left'); $this->db->join('users as uto','por_ho_request_compile.por_ho_to = uto.branch_code','left'); $this->db->join('users as ho_received','por_ho_received_compile.por_received_uid = ho_received.uid','left'); $this->db->join('users as branch_served','por_ho_request_compile.br_by = branch_served.uid','left'); $this->db->join('smr_request_subject','por_ho_request_compile.por_ho_sbj = smr_request_subject.id_subject', 'left'); $this->db->where('por_ho_request_compile.por_ho_from', $bc); $this->db->where('por_ho_request_compile.por_ho_temp',4); $this->db->group_by('por_ho_request_compile.por_id'); $this->db->order_by('por_ho_request_compile.br_sr','desc'); $this->db->order_by('por_ho_request_compile.por_ho_from','asc'); $query = $this->db->get(); foreach ($query->result_array() as $row) { $data[] = $row; } return $data;
  16. Hi Coders, i just wanna know on how to set-up pagination while enable_query_strings is enable or set to true. i tried in many ways but im failed. and i just get the link work but the data cannot retrieved for the next page. $config["base_url"] = base_url() . "index.php?dir-move=public&switch=branch_reports&task=branch_report_por"; $config["total_rows"] = $this->model_ho_por->page_count_for_br_por_sr_report(); $config["per_page"] = 3; $config["uri_segment"] = 3; $config['num_links'] = 2; $config['page_query_string'] = true; $config['full_tag_open'] = '<ul class="pagination">'; $config['full_tag_close'] = '</ul>'; config['prev_link'] = '<'; $config['prev_tag_open'] = '<li>'; $config['prev_tag_close'] = ''; $config['first_link'] = 'First'; $config['first_tag_open'] = '<li>'; $config['first_tag_close'] = ''; $config['next_link'] = '>'; $config['next_tag_open'] = '<li>'; $config['next_tag_close'] = ''; $config['cur_tag_open'] = '<li class="active"><a href="">'; $config['cur_tag_close'] = '</a></li>'; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = ''; $config['last_link'] = 'Last'; $config['last_tag_open'] = '<li>'; $config['last_tag_close'] = ''; $this->pagination->initialize($config); $page = ($this->uri->segment(3))? $this->uri->segment(3) : 0; $data["load_rs_report"] = $this->model_ho_por->branch_ho_sr($config["per_page"], $page); $data["pages"] = $this->pagination->create_links(); and got link below but the data are not change, ?dir-move=public&switch=branch_reports&task=branch_report_por&per_page=1 ?dir-move=public&switch=branch_reports&task=branch_report_por&per_page=2 ?dir-move=public&switch=branch_reports&task=branch_report_por&per_page=3 ?dir-move=public&switch=branch_reports&task=branch_report_por&per_page=4 ?dir-move=public&switch=branch_reports&task=branch_report_por&per_page=5
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.