Forums

		$form->debug['CSV Export'][] = 'File size is: '.$form->data['csv_size'].' kb';
	}

		$form->debug['CSV Export'][] = 'File size is: '.$form->data['csv_size'].' kb';
		if(!$this->events['fail']) $this->events['success']=1;
	}

$events = array('success' => true; 'fail' => false);

$events = array('apples' => 0; 'oranges' => 0, 'bananas' => 0);

if (!$form->data['exclude']){
    $exclude = array();
}

			if ( $exclude ) {
				$exclude = explode(',', $exclude);
				foreach ( $exclude as $k => $v ) {
					$exclude[$k] = trim($v);
				}
                        // add the next two lines
			} else {
				$exclude = array();
			}

<p>You may download your file from <a href='{csv_link}'> here </a>.</p>

<p>{csv_count} records were exported.<br/>
The file size is {csv_size} kb.
</p>

 		fputcsv($file, $titles, ';');
		// add data rows to the file
		foreach ( $data as $d ) {
			fputcsv($file, $d, ';');

`meet_name` = `{meet_select}` 

<?php
    $db =& JFactory::getDBO();
    //
    $query = "
      SELECT DISTINCT `meet_name`
        FROM `#__chronoforms_data_meets`;
    ";
    $db->setQuery($query);
    $options = $db->loadAssocList();
    foreach ( $options as $o ) {
       echo "<option value='".$o['meet_name']."'>".$o['meet_name']."</option>";
    }
 ?>

$query: SELECT * FROM `fv1lz_chronoforms_data_meets` WHERE `meet_name` = '{meet_select}' ; 

Data Array:

Array
(
    [meet_select] => LHG Jan 2012
    [input_submit_0] => Download CSV File
    [8f9b6161b167c545921c98f3fbd4144a] => 1
    [option] => com_chronoforms
    [chronoform] => meets_download
    [event] => submit
    [Itemid] => 
    [csv_link] => http://www.yrc.org.uk/yrcweb/components/com_chronoforms/exports/meets_download/csv_export_fv1lz_chronoforms_data_meets_201201041309.csv
    [csv_count] => 16
    [csv_size] => 3
)

Debug Data

    CSV Export
        $download_export: 0
        $download_nosave: 0
        Save folder is:
        /homepages/11/d369608199/htdocs/yrcweb/components/com_chronoforms/exports/meets_download/
        $download_export: xxx
        $download_export: 0
        File name is:
        csv_export_fv1lz_chronoforms_data_meets_201201041309.csv
        $query: SELECT `meet_name`, `for`, `name`, `email`, `with`, `lift`, `from`, `Arrival`, `Fri_Eve`, `Sat_Break`, `Sat_Dinner`, `Sun_Break`, `notes` FROM `fv1lz_chronoforms_data_meets` WHERE `meet_name` = 'LHG Jan 2012' AND `share` IS NULL ORDER BY `name` ASC;
        16 records were found to export.
        Save link is:
        http://www.yrc.org.uk/yrcweb/components/com_chronoforms/exports/meets_download/csv_export_fv1lz_chronoforms_data_meets_201201041309.csv
        File size is: 3 kb

Data Array:

Array
(
    [meet_select] => LHG Jan 2012
    [input_submit_0] => Download CSV File
    [8f9b6161b167c545921c98f3fbd4144a] => 1
    [option] => com_chronoforms
    [chronoform] => meets_download
    [event] => submit
    [Itemid] => 
)

Debug Data

    CSV Export
        $download_export: 0
        $download_nosave: 1
        Download 'No Save' is set so no folder is created.
        File name is:
        csv_export_fv1lz_chronoforms_data_meets_201201041305.csv
        $query: SELECT `meet_name`, `for`, `name`, `email`, `with`, `lift`, `from`, `Arrival`, `Fri_Eve`, `Sat_Break`, `Sat_Dinner`, `Sun_Break`, `notes` FROM `fv1lz_chronoforms_data_meets` WHERE `meet_name` = '{meet_select}' AND `share` IS NULL ORDER BY `name` ASC;

		if ( $where ) {
			$where = $form->curly_replacer($where, $form->data); // <-- add this line
			// strip off anything after a ;
			$sc_found = strpos($where, ';');
			if ( $sc_found ) {
				$where = substr($where, 0, $sc_found);
			}
			// clean up WHERE
			$where = str_ireplace('where ', '', $where);
			$where = 'WHERE '.$where;
		}

<?php
switch( $form->data['search'] ) {
  case 'district':
    $form->data['where'] = "`district` = '{$form->data['district_name']}'";
    break;
  case 'school':
    $form->data['where'] = "`school` = '{$form->data['school_name']}'";
    break;
}
?>

<?php
switch( $form->data['search'] ) {
  case 'district':
    $form->data['where'] = "`district` = '{$form->data['cc_district']}'";
    break;
  case 'school':
    $form->data['where'] = "`school` = '{$form->data['cc_schoolname']}'";
    break;
}
?>

<?php
$search = JRequest::getString('submit_3', '', 'post');
$where = JRequest::getString('where', '', 'post');
switch( $form->data['search'] ) {
  case 'District':
    $form->data['where'] = "`District` = '{$form->data['cc_district']}'";
    break;
  case 'School':
    $form->data['where'] = "`School` = '{$form->data['cc_schoolname']}'";
    break;

}
?>

`where` = '{$where}'

<?php
switch( $form->data['search'] ) {
  case 'district':
    $form->data['where'] = "`district` = '{$form->data['cc_district']}'";
    break;
  case 'school':
    $form->data['where'] = "`school` = '{$form->data['cc_schoolname']}'";
    break;
}
?>

<div class="ccms_form_element cfdiv_radio" id="cc_radio_select_container_div"><input type="hidden" name="cc_radio_select" value="" alt="ghost" />
    <input type="radio" name="cc_radio_select" id="cc_radio_select_district" title="" value="District" class="validate['required']" onClick="CCshowHide(this.name);" checked="checked" />
      <label for="cc_radio_select_district">By District</label>
      <input type="radio" name="cc_radio_select" id="cc_radio_select_school" title="" value="School" class="validate['required']" onClick="CCshowHide(this.name);" />
      <label for="cc_radio_select_school">By School</label>
      <input type="radio" name="cc_radio_select" id="cc_radio_select_project" title="" value="Project" class="validate['required']" onClick="CCshowHide(this.name);" />
      <label for="cc_radio_select_project">By Project</label>
  <div id="error-message-cc_radio_select"></div></div>

<?php
//$where = JRequest::getString('where', '', 'post');
/* echo'<div>$form->data[cc_radio_select]: '.print_r($form->data['cc_radio_select'], true).'</div>'; */
switch( $form->data['cc_radio_select'] ) {
  case 'District':
    $form->data['where'] = "`district` = '{$form->data['cc_district']}'";
    break;
  case 'School':
    $form->data['where'] = "`SchoolName` = '{$form->data['cc_schoolname']}'";
    break;
  case 'Project':
    $form->data['where'] = "`Project` = ''";
    break;

}
?>