How-To

Show Service name in Cart

Posted in How-To

This How-to shows a way to display the service name in your shopping cart.

You will need:

  1. Modify the query that fetched data for the cart
  2. Modify the cart display to show the service name

 

Edit File: \components\com_rsappt_pro3\views\cart\tmpl\default.php

 

1. Modify the query

Around line 59 us the query

$sql = "SELECT #__sv_apptpro3_cart.*, #__sv_apptpro3_requests.*, ".
"#__sv_apptpro3_resources.name as resname, ".
"CONCAT(#__sv_apptpro3_requests.startdate,#__sv_apptpro3_requests.starttime) as startdatetime, ".
" IF(CONCAT(#__sv_apptpro3_requests.startdate, ' ', #__sv_apptpro3_requests.starttime) > Now(),'no','yes') as expired, ";
if($apptpro_config->timeFormat == "12"){
$sql = $sql." DATE_FORMAT(#__sv_apptpro3_requests.startdate, '%a %b %e, %Y') as display_startdate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.starttime, '%l:%i %p') as display_starttime, ".
"DATE_FORMAT(#__sv_apptpro3_requests.enddate, '%b %e, %Y') as display_enddate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.endtime, '%l:%i %p') as display_endtime ";
} else {
$sql = $sql." DATE_FORMAT(#__sv_apptpro3_requests.startdate, '%a %b %e, %Y') as display_startdate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.starttime, '%k:%i') as display_starttime, ".
"DATE_FORMAT(#__sv_apptpro3_requests.enddate, '%b %e, %Y') as display_enddate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.endtime, '%k:%i') as display_endtime ";
}
$sql = $sql." FROM #__sv_apptpro3_cart INNER JOIN #__sv_apptpro3_requests ".
"ON #__sv_apptpro3_cart.request_id = #__sv_apptpro3_requests.id_requests ".
"INNER JOIN #__sv_apptpro3_resources ON #__sv_apptpro3_requests.resource = #__sv_apptpro3_resources.id_resources ".
"WHERE session_id = '".$session_id."' ".
" AND #__sv_apptpro3_requests.request_status = 'pending' ".
" ORDER BY id_row_cart";

 

Add the red code

$sql = "SELECT #__sv_apptpro3_cart.*, #__sv_apptpro3_requests.*, ".
"#__sv_apptpro3_resources.name as resname, ".
"#__sv_apptpro3_services.name as ServiceName, ".
"CONCAT(#__sv_apptpro3_requests.startdate,#__sv_apptpro3_requests.starttime) as startdatetime, ".
" IF(CONCAT(#__sv_apptpro3_requests.startdate, ' ', #__sv_apptpro3_requests.starttime) > Now(),'no','yes') as expired, ";
if($apptpro_config->timeFormat == "12"){
$sql = $sql." DATE_FORMAT(#__sv_apptpro3_requests.startdate, '%a %b %e, %Y') as display_startdate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.starttime, '%l:%i %p') as display_starttime, ".
"DATE_FORMAT(#__sv_apptpro3_requests.enddate, '%b %e, %Y') as display_enddate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.endtime, '%l:%i %p') as display_endtime ";
} else {
$sql = $sql." DATE_FORMAT(#__sv_apptpro3_requests.startdate, '%a %b %e, %Y') as display_startdate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.starttime, '%k:%i') as display_starttime, ".
"DATE_FORMAT(#__sv_apptpro3_requests.enddate, '%b %e, %Y') as display_enddate, ".
"DATE_FORMAT(#__sv_apptpro3_requests.endtime, '%k:%i') as display_endtime ";
}
$sql = $sql." FROM #__sv_apptpro3_cart INNER JOIN #__sv_apptpro3_requests ".
"ON #__sv_apptpro3_cart.request_id = #__sv_apptpro3_requests.id_requests ".
"INNER JOIN #__sv_apptpro3_resources ON #__sv_apptpro3_requests.resource = #__sv_apptpro3_resources.id_resources ".
"INNER JOIN #__sv_apptpro3_services ON #__sv_apptpro3_requests.service = #__sv_apptpro3_services.id_services ".
"WHERE session_id = '".$session_id."' ".
" AND #__sv_apptpro3_requests.request_status = 'pending' ".
" ORDER BY id_row_cart";

 

Modify the display

Same file.

Around line 217 are the headers..

<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_RESOURCE_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_DATE_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_FROM_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_UNTIL_COL_HEAD'); ?></th>

Add the red code

<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_RESOURCE_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_DATE_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_FROM_COL_HEAD'); ?></th>
<th class="title" align="center"><?php echo JText::_('RS1_VIEW_CART_SCRN_UNTIL_COL_HEAD'); ?></th>
<th class="title" align="center">Service</th>

 

Around line 240 is the data

<td align="center"><?php echo $row->display_startdate; ?></td>
<td align="center"><?php echo $row->display_starttime; ?> </td>
<td align="center"><?php echo $row->display_endtime; ?> </td>

 

Add the red code

<td align="center"><?php echo $row->display_startdate; ?></td>
<td align="center"><?php echo $row->display_starttime; ?> </td>
<td align="center"><?php echo $row->display_endtime; ?> </td>
<td align="center"><?php echo $row->ServiceName; ?> </td>

 

To make the total line up under the costs you will need to change the colspan on tho totals row line 254..

 <td colspan="5" align="right"><?php echo JText::_('RS1_VIEW_CART_SCRN_TOTAL_COL_HEAD'); ?></td>

 

That's it.