config['app'] ['modules']; echo '

'.$icon.$post_type_obj['name'].'
'.$icon.$post_type_obj['name'].'

'; } public function set_page_header() { global $apm_settings; $module_name=$this->config['module']['name']; $appkey=$this->config['appkey']; if(get_option($appkey.'_app_name')!==false and get_option($appkey.'_app_name')!==''){ $app_name=get_option($appkey.'_app_name'); } else { $app_name=$this->config['app']['name']; } $company_name=get_option('company_name'); if($company_name!==false and $company_name!==''){ $company_name=$company_name." | "; } else { $company_name=''; } $iconCss=''; if(isset($this->config['module']['icon'])){ $iconCss=" background:url('".$apm_settings['paths']['img']."/".$this->config['module']['icon']."') no-repeat 5px 8px; "; } require_once APPLICATION_MAKER_VIEWS_PATH . 'apm-datagrid-header.php'; } public function do_basic_search_input() { echo '

'; echo ''; echo ''; echo ''; } public function set_tabs() { ?>

Datagrid
Settings

set_datagrid(); $this->set_sidebar(); ?>

Settings

"; $btn_add=" "; $btn_del=" "; $btn_trash=" "; $btn_unpub=" "; $btn_pub=" "; $btn_view=" "; $btn_action=" "; $btn_info=" "; $btn_fav=" "; $action_btns=$btn_action; $action_all_btns=$btn_edit.$btn_del.$btn_trash.$btn_unpub.$btn_pub;//.$btn_info.$btn_fav; $btn_view. require_once APPLICATION_MAKER_VIEWS_PATH . 'apm-datagrid-grid.php'; } ///IS CALLED By AJAX, . public function manage_grid_data($browser_post) { switch($browser_post['todo']){ case "get_data": $this->get_grid_data($browser_post['modulekey'],$browser_post); break; case "del_rec": $this->delete_record($browser_post['modulekey'],$browser_post['post_id']); break; case "trash_rec": $this->trash_record($browser_post['modulekey'],$browser_post['post_id']); break; case "pub_rec": $this->publish_record($browser_post['modulekey'],$browser_post['post_id']); break; case "unpub_rec": $this->unpublish_record($browser_post['modulekey'],$browser_post['post_id']); break; case "unpub_multirecs": $this->unpublish_records($browser_post['modulekey'],$browser_post['post_ids']); break; case "pub_multirecs": $this->publish_records($browser_post['modulekey'],$browser_post['post_ids']); break; case "trash_multirecs": $this->trash_records($browser_post['modulekey'],$browser_post['post_ids']); break; case "del_multirecs": $this->delete_records($browser_post['modulekey'],$browser_post['post_ids']); break; } } ///IS CALLED By AJAX, . public function publish_record($modulekey,$post_id) { echo $post_id. " Published"; $my_post = array(); $my_post['ID'] = intval($post_id); $my_post['post_status'] = 'publish'; wp_update_post( $my_post ); //wp_delete_post( $post_id, true ); } public function publish_records($modulekey,$post_ids) { echo $post_ids. " are published"; $post_ids_ar=explode(',',$post_ids); foreach($post_ids_ar as $post_id){ $my_post = array(); $my_post['ID'] = intval($post_id); $my_post['post_status'] = 'publish'; wp_update_post( $my_post ); } } public function unpublish_records($modulekey,$post_ids) { echo $post_ids. " are unpublished"; $post_ids_ar=explode(',',$post_ids); foreach($post_ids_ar as $post_id){ $my_post = array(); $my_post['ID'] = intval($post_id); $my_post['post_status'] = 'draft'; wp_update_post( $my_post ); } //wp_delete_post( $post_id, true ); } public function unpublish_record($modulekey,$post_id) { echo $post_id. " Unpublished"; $my_post = array(); $my_post['ID'] = intval($post_id); $my_post['post_status'] = 'draft'; wp_update_post( $my_post ); } public function delete_records($modulekey,$post_ids) { echo $post_ids. " are deleted"; $post_ids_ar=explode(',',$post_ids); foreach($post_ids_ar as $post_id){ wp_delete_post( $post_id, true ); } } public function delete_record($modulekey,$post_id) { echo $post_id. " Deleted"; wp_delete_post( $post_id, true ); } public function trash_records($modulekey,$post_ids) { echo $post_ids. " are trashed"; $post_ids_ar=explode(',',$post_ids); foreach($post_ids_ar as $post_id){ wp_trash_post( $post_id); } } public function trash_record($modulekey,$post_id) { echo $post_id. " Trashed"; wp_trash_post( $post_id); } ///IS LOADED By AJAX, send the HTML of the table content only. public function get_grid_data($modulekey,$browser_post) { global $wpdb,$meta_key, $oThis,$meta_marker,$apm_settings; if(isset($browser_post['filters'])){ $filters=$browser_post['filters']; if($filters!=="{}"){ $ar_filters=json_decode(stripslashes($filters)); $filters_results=''; $posts = $this->get_all_posts_list_with_meta($modulekey,$ar_filters); foreach($ar_filters as $filter_type => $filter_value){ $filter_type_lbl=''; $filter_lbl=''; switch($filter_type){ case "letter": $filter_type_lbl="First Letter"; $filter_lbl=$filter_value; if($filter_value=="#"){ $filter_lbl=''; $filter_type_lbl=''; } break; case "post_status": $filter_type_lbl="Status"; switch($filter_value){ case "filter_all": $filter_lbl=''; $filter_type_lbl=''; break; case "filter_pub": $filter_lbl='Publish'; break; case "filter_unpub": $filter_lbl='UnPublish (Draft)'; break; case "filter_trash": $filter_lbl='Trash'; break; } break; } if($filter_type_lbl!==''){ $filters_results.=" | ".$filter_type_lbl.': '.$filter_lbl; } } } else { $posts = $this->get_all_posts_list_with_meta($modulekey); } } else { $posts = $this->get_all_posts_list_with_meta($modulekey); } $columns=array(); if(isset($oThis->all_modules[$modulekey]['module_columns'])){ $columns=$oThis->all_modules[$modulekey]['module_columns']; } $count_records=0; $totals=array(); /* if(isset($config['field_config']['calculations'])) { foreach($config['field_config']['calculations'] as $key=>$calculation){ $totals [$key]=0; } }*/ foreach($posts as $p){ $count_records++; $btn_action=" "; $action_btns=$btn_action; echo ''; echo "".$action_btns.""; switch($p->post_status){ case 'draft': $status="apm_act_unpub td_status"; break; case 'publish': $status="apm_act_pub td_status"; break; case 'trash': $status="apm_act_trash td_status"; break; case 'pending': $status="apm_act_pending td_status"; break; } echo ""; $out = sprintf( '%s', esc_url( add_query_arg( array( 'post' => $p->ID, 'action' => 'edit'), 'post.php' ) ), "

" ); $out .= sprintf( ' %s', esc_url( add_query_arg( array( 'post' => $p->ID, 'action' => 'edit'), 'post.php' ) ), esc_html( $p->post_title ) ); foreach($columns as $column){ $f=$oThis->default_fields[$column]; switch($column){ case "post_title": echo ''.$out.''; break; case "post_date": $h_time = mysql2date( __( 'Y/m/d' ), $p->post_date ); echo ''.$h_time.''; break; case "post_status": echo ''.$p->post_status.''; break; default: $meta=get_post_meta($p->ID, $column.$meta_marker,true); if($meta!==''){ //userslist if(isset($f['field_type']) ){ switch($f['field_type']){ case "select": if(isset($f['field_config']['use_values']) and $f['field_config']['use_values']==true){ $meta=$f['options'][$meta]; } else { $subpost=get_post($meta); $meta_t=$subpost->post_title; $meta=sprintf( '%s', esc_url( add_query_arg( array( 'action' => 'edit', 'post' => $subpost->ID), 'post.php' ) ), $meta_t ); } break; case "autocomplete": $subpost=get_post($meta); $meta_t=$subpost->post_title; $meta=sprintf( '%s', esc_url( add_query_arg( array( 'action' => 'edit', 'post' => $subpost->ID), 'post.php' ) ), $meta_t ); break; case "userslist": $valid=$meta; $user=get_users(array( 'include' =>$meta ) ); $meta=$user[0]->display_name; $meta= sprintf( '%s', esc_url( add_query_arg( array( 'user_id' => $valid), 'user-edit.php' ) ),$meta); break; case "assignee": $valid=$meta; $user=get_users(array( 'include' =>$meta ) ); $meta=$user[0]->display_name; $meta= sprintf( '%s', esc_url( add_query_arg( array( 'user_id' => $valid), 'user-edit.php' ) ),$meta); break; case "currencyfield": $meta=$meta.' '.$apm_settings['configs']['default_currency']; break; case 'checkbox': $txt='No'; if($meta=='1'){ $txt='Yes'; } $meta=$txt; break; } //echo var_dump($subpost); } } echo ''.$meta.''; break; } } echo ""; /*if(isset($config['field_config']['calculations'])) { foreach($config['field_config']['calculations'] as $key=>$calculation){ if(!isset($calculation['type'])){ $type='sum'; } else { $type=$calculation['type']; } switch($type) { case 'sum': $f=$this->default_fields[$key]; $meta=get_post_meta($p->ID, $key.$meta_marker,true); $totals[$key]+=intval($meta); break; case 'average': $f=$this->default_fields[$key]; $meta=get_post_meta($p->ID, $key.$meta_marker,true); $totals[$key]+=intval($meta); break; } } }*/ } $query = "SELECT DISTINCT * FROM $wpdb->posts WHERE $wpdb->posts.post_type = '$modulekey' AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'draft' OR $wpdb->posts.post_status = 'pending' OR $wpdb->posts.post_status = 'trash') "; $posts_list= $wpdb->get_results($query); echo '//cutter//{"count":"'.$count_records.'", "total_count":"'.count($posts_list).'", "filters_results":"'.$filters_results.'"}'; //var_dump($posts); } function get_all_posts_list_with_meta($post_type,$ar_filters=array()){//$filter_type='post_status',$filter_value='filter_all'){ global $post, $wpdb,$meta_marker; $filter_str=''; if(empty($ar_filters->post_status)){ if(is_array($ar_filters)){ $ar_filters['post_status']="filter_all"; } else { $ar_filters->post_status="filter_all"; } } foreach($ar_filters as $filter_type => $filter_value){ switch($filter_type){ case "letter": if($filter_value=="#"){ } else if($filter_value=="0-9"){ $filter_str.=" AND ("; $filter_str.=" $wpdb->posts.post_title LIKE '0%' "; for($i=1;$i<10;$i++){ $filter_str.=" OR $wpdb->posts.post_title LIKE '".$i."%' "; } $filter_str.=" ) "; } else { $filter_str.=" AND $wpdb->posts.post_title LIKE '".$filter_value."%' "; } break; case "post_status": switch($filter_value){ case "filter_all": $filter_str.=" AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'draft' OR $wpdb->posts.post_status = 'unpublish') "; break; case "filter_pub": $filter_str.=" AND ($wpdb->posts.post_status = 'publish' ) "; break; case "filter_unpub": $filter_str.=" AND ($wpdb->posts.post_status = 'draft' ) "; break; case "filter_trash": $filter_str.=" AND ($wpdb->posts.post_status = 'trash' ) "; break; } break; } } $query = "SELECT DISTINCT * FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id WHERE $wpdb->posts.post_type = '$post_type' $filter_str GROUP BY ID ORDER BY post_title "; $posts_list= $wpdb->get_results($query); return $posts_list; } public function set_datagrid_header() { global $apm_settings; echo ''; echo 'Acti.'; echo 'Sta.'; if(isset($this->config['module']['module_columns'])){ foreach($this->config['module']['module_columns'] as $column){ $f=$this->default_fields[$column]; $label=$f['label']; $clabel=''; $width=''; if(isset($f['column_label'])){ $clabel=$f['column_label']; } if(isset($f['column_width'])){ $width=' style="width:'.$f['column_width'].'px;" '; } $label=str_replace("{{currency}}", $apm_settings['configs']['default_currency'], $label); $clabel=str_replace("{{currency}}", $apm_settings['configs']['default_currency'], $clabel); if($column=="post_title"){ $label='Title'; } if($clabel==''){ echo ''.$label.''; } else { echo ''.$clabel.''; } } }else { echo 'Title Status Date'; } /*echo ' TitleDatexxxChildsActi.';*/ } public function set_footer() { require_once APPLICATION_MAKER_VIEWS_PATH . 'apm-datagrid-footer.php'; } } }