= date_format(curdate(),'%Y-%m-%d 00:00:00') ";
$sub_sth = mf_do_query($sub_query,array(),$dbh);
$sub_row = mf_do_fetch_result($sub_sth);
$form_list_array[$i]['today_entry'] = $sub_row['today_entry'];
//get latest entry timing
if(!empty($sub_row['today_entry'])){
$sub_query = "select date_created from `".MF_TABLE_PREFIX."form_{$row['form_id']}` order by id desc limit 1";
$sub_sth = mf_do_query($sub_query,array(),$dbh);
$sub_row = mf_do_fetch_result($sub_sth);
$form_list_array[$i]['latest_entry'] = mf_relative_date($sub_row['date_created']);
}
//get total entries count
if($form_sort_by == 'total_entries'){
$sub_query = "select count(*) total_entry from `".MF_TABLE_PREFIX."form_{$row['form_id']}` where `status`=1";
$sub_sth = mf_do_query($sub_query,array(),$dbh);
$sub_row = mf_do_fetch_result($sub_sth);
$form_list_array[$i]['total_entry'] = $sub_row['total_entry'];
}
//get form tags and split them into array
if(!empty($row['form_tags'])){
$form_tags_array = explode(',',$row['form_tags']);
array_walk($form_tags_array, 'mf_trim_value');
$form_list_array[$i]['form_tags'] = $form_tags_array;
}
$i++;
}
if($form_sort_by == 'today_entries'){
usort($form_list_array, 'sort_by_today_entry');
}
if($form_sort_by == 'total_entries'){
usort($form_list_array, 'sort_by_total_entry');
}
if(empty($selected_form_id)){ //if there is no preference for which form being displayed, display the first form
$selected_form_id = $form_list_array[0]['form_id'];
}
$selected_page_number = 1;
//build pagination markup
$total_rows = count($form_list_array);
$total_page = ceil($total_rows / $rows_per_page);
if($total_page > 1){
$start_form_index = 0;
$pagination_markup = '
'."\n";
for($i=1;$i<=$total_page;$i++){
//attach the data code into each pagination button
$end_form_index = $start_form_index + $rows_per_page;
$liform_ids_array = array();
for ($j=$start_form_index;$j<$end_form_index;$j++) {
if(!empty($form_list_array[$j]['form_id'])){
$liform_ids_array[] = '#liform_'.$form_list_array[$j]['form_id'];
//put the page number into the array
$form_list_array[$j]['page_number'] = $i;
//we need to determine on which page the selected_form_id being displayed
if($selected_form_id == $form_list_array[$j]['form_id']){
$selected_page_number = $i;
}
}
}
$liform_ids_joined = implode(',',$liform_ids_array);
$start_form_index = $end_form_index;
$jquery_data_code .= "\$('#pagebtn_{$i}').data('liform_list','{$liform_ids_joined}');\n";
if($i == $selected_page_number){
if($selected_page_number > 1){
$pagination_markup = str_replace('current_page','',$pagination_markup);
}
$pagination_markup .= '
'.$i.'
'."\n";
}else{
$pagination_markup .= '
'.$i.'
'."\n";
}
}
$pagination_markup .= '
';
}else{
//if there is only 1 page, set the page_number property for each form to 1
foreach ($form_list_array as $key=>$value){
$form_list_array[$key]['page_number'] = 1;
}
}
//get the available tags
$query = "select form_tags from ".MF_TABLE_PREFIX."forms where form_tags is not null and form_tags <> ''";
$params = array();
$sth = mf_do_query($query,$params,$dbh);
$raw_tags = array();
while($row = mf_do_fetch_result($sth)){
$raw_tags = array_merge(explode(',',$row['form_tags']),$raw_tags);
}
$all_tagnames = array_unique($raw_tags);
sort($all_tagnames);
$jquery_data_code .= "\$('#dialog-enter-tagname-input').data('available_tags',".json_encode($all_tagnames).");\n";
//get the available custom themes
$query = "SELECT theme_id,theme_name FROM ".MF_TABLE_PREFIX."form_themes WHERE theme_built_in=0 and status=1 ORDER BY theme_name ASC";
$params = array();
$sth = mf_do_query($query,$params,$dbh);
$theme_list_array = array();
while($row = mf_do_fetch_result($sth)){
$theme_list_array[$row['theme_id']] = htmlspecialchars($row['theme_name']);
}
//get built-in themes
$query = "SELECT theme_id,theme_name FROM ".MF_TABLE_PREFIX."form_themes WHERE theme_built_in=1 and status=1 ORDER BY theme_name ASC";
$params = array();
$sth = mf_do_query($query,$params,$dbh);
$theme_builtin_list_array = array();
while($row = mf_do_fetch_result($sth)){
$theme_builtin_list_array[$row['theme_id']] = htmlspecialchars($row['theme_name']);
}
$header_data =<<
EOT;
$current_nav_tab = 'manage_forms';
require('includes/header.php');
?>
