Yohanne

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

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

i mean is. disregard the table3 at all.

how about this? can i have your query..

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

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...

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..

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 | +-----------------------------------------------------------+

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..

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..

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

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

do you have any other solution on it?

i use VAR/CHARs and i think its too late to change it into DATE. its already have data more than 70k.

Yes

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

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;

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

hope it could give you an idea. if(date( 'M') == 'Jan' || date( 'M') == 1) { echo "month"; } elseif(date( 'M') == 'Feb' || date( 'M') == 2) { echo "month"; } elseif(date( 'M') == 'Mar' || date( 'M') == 3) { echo "month"; } elseif(date( 'M') == 'Apr' || date( 'M') == 4) { echo "month"; } elseif(date( 'M') == 'May' || date( 'M') == 5) { echo "month"; } elseif(date( 'M') == 'Sep' || date( 'M') == 9) { echo "month"; } else { return false; }

i already trying here, but don't get the logic.. and how do i get the value of input text. i mean is, where is the input text value here

Hi coders, i just want to display the each value of input text but i don't get it, any advice where i go wrong.. no database required. <input type='text' name = 'val1[]' value='asasas'> <input type='text' name = 'val2[]' value='asasas'> <input type='text' name = 'val1[]' value='sdsddd'> <input type='text' name = 'val2[]' value='sdsdsd'> $value1 = $this->input->post('val1'); $value2 = $this->input->post('val2'); $array = array(value1, value2); echo $comma_separated = implode(",", $array);

i would recommend you is YII

yes

<?php include '../inc/chaserData.php'; ?>

i just gave an idea and what is wrong. . .?