-
Posts
216 -
Joined
-
Last visited
Posts posted by Yohanne
-
-
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.
-
1 hour ago, Barand said:
FROM table3
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 outputuid | 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.
-
-
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
-
-
<?php include '../inc/chaserData.php'; ?> -
i just gave an idea and what is wrong. . .?
MYSQL GROUP_CONCAT IS NOT WORKING
in MySQL Help
Posted
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