PageRenderTime 70ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/formidable/pro/classes/controllers/FrmProEntriesController.php

https://github.com/rafapires/festival-de-ideias
PHP | 2066 lines | 1620 code | 407 blank | 39 comment | 427 complexity | 2477c36892b4fb4054e4eebba849f2ea MD5 | raw file
Possible License(s): GPL-3.0, AGPL-1.0 
    

  1. <?php
    2. 

  2. 

  3. class FrmProEntriesController{
    4. 

  4.     
    5. 

  5.     function FrmProEntriesController(){
    6. 

  6.         add_action('admin_menu', array( &$this, 'menu' ), 20);
    7. 

  7.         add_action('admin_init', array(&$this, 'admin_js'), 1);
    8. 

  8.         add_action('init', array(&$this, 'register_scripts'));
    9. 

  9.         add_action('wp_enqueue_scripts', array(&$this, 'add_js'));
    10. 

  10.         add_action('wp_footer', array(&$this, 'footer_js'), 1);
    11. 

  11.         add_action('admin_footer', array(&$this, 'footer_js'));
    12. 

  12.         add_filter('update_user_metadata', array(&$this, 'check_hidden_cols'), 10, 5);
    13. 

  13.         add_action('updated_user_meta', array(&$this, 'update_hidden_cols'), 10, 4);
    14. 

  14.         add_filter('set-screen-option', array(&$this, 'save_per_page'), 10, 3);
    15. 

  15.         add_action('frm_before_table', array( &$this, 'before_table'), 10, 2);
    16. 

  16.         add_action('wp_ajax_frm_import_csv', array( &$this, 'import_csv_entries') );
    17. 

  17.         add_action('frm_process_entry', array(&$this, 'process_update_entry'), 10, 3);
    18. 

  18.         add_action('frm_display_form_action', array(&$this, 'edit_update_form'), 10, 5);
    19. 

  19.         add_action('frm_submit_button_action', array($this, 'ajax_submit_button'), 10, 2);
    20. 

  20.         add_filter('frm_success_filter', array(&$this, 'get_confirmation_method'), 10, 2);
    21. 

  21.         add_action('frm_success_action', array(&$this, 'confirmation'), 10, 4);
    22. 

  22.         add_action('deleted_post', array(&$this, 'delete_entry'));
    23. 

  23.         add_action('untrashed_post', array(&$this, 'untrashed_post'));
    24. 

  24.         add_action('add_meta_boxes', array( &$this, 'create_entry_from_post_box'), 10, 2);
    25. 

  25.         add_action('wp_ajax_frm_create_post_entry', array( &$this, 'create_post_entry'));
    26. 

  26.         
    27. 

  27.         add_filter('frmpro_fields_replace_shortcodes', array(&$this, 'filter_shortcode_value'), 10, 4);
    28. 

  28.         add_filter('frm_display_value_custom', array(&$this, 'filter_display_value'), 10, 2);
    29. 

  29.         
    30. 

  30.         //Shortcodes
    31. 

  31.         add_shortcode('formresults', array(&$this, 'get_form_results'));
    32. 

  32.         add_shortcode('frm-search', array(&$this, 'get_search'));
    33. 

  33.         add_shortcode('frm-entry-links', array(&$this, 'entry_link_shortcode'));
    34. 

  34.         add_shortcode('frm-entry-edit-link', array(&$this, 'entry_edit_link'));
    35. 

  35.         add_shortcode('frm-entry-update-field', array(&$this, 'entry_update_field'));
    36. 

  36.         add_shortcode('frm-entry-delete-link', array(&$this, 'entry_delete_link'));
    37. 

  37.         add_shortcode('frm-field-value', array(&$this, 'get_field_value_shortcode'));
    38. 

  38.         add_shortcode('frm-show-entry', array(&$this, 'show_entry_shortcode'));
    39. 

  39.     }
    40. 

  40.     
    41. 

  41.     function menu(){
    42. 

  42.         global $frm_settings;
    43. 

  43.         if(current_user_can('administrator') and !current_user_can('frm_view_entries')){
    44. 

  44.             global $wp_roles;
    45. 

  45.             $frm_roles = FrmAppHelper::frm_capabilities();
    46. 

  46.             foreach($frm_roles as $frm_role => $frm_role_description){
    47. 

  47.                 if(!in_array($frm_role, array('frm_view_forms', 'frm_edit_forms', 'frm_delete_forms', 'frm_change_settings')))
    48. 

  48.                     $wp_roles->add_cap( 'administrator', $frm_role );
    49. 

  49.             }
    50. 

  50.         }
    51. 

  51.         add_submenu_page('formidable', $frm_settings->menu .' | '. __('Form Entries', 'formidable'), __('Form Entries', 'formidable'), 'frm_view_entries', 'formidable-entries', array(&$this, 'route'));
    52. 

  52.         
    53. 

  53.         if(class_exists('WP_List_Table') and (!isset($_GET['frm_action']) or !in_array($_GET['frm_action'], array('edit', 'show')))){
    54. 

  54.             add_filter('manage_'. sanitize_title($frm_settings->menu) .'_page_formidable-entries_columns', array(&$this, 'manage_columns'));
    55. 

  55.             add_filter('manage_'. sanitize_title($frm_settings->menu) .'_page_formidable-entries_sortable_columns', array(&$this, 'sortable_columns'));
    56. 

  56.             add_filter('get_user_option_manage'. sanitize_title($frm_settings->menu) .'_page_formidable-entriescolumnshidden', array(&$this, 'hidden_columns'));
    57. 

  57.         }
    58. 

  58.         //add_filter( 'bulk_actions-' . sanitize_title($frm_settings->menu) .'_page_formidable-entries', array(&$this, 'bulk_action_options'));
    59. 

  59.         add_action('admin_head-'. sanitize_title($frm_settings->menu) .'_page_formidable-entries', array(&$this, 'head'));
    60. 

  60.     }
    61. 

  61.     
    62. 

  62.     function head(){
    63. 

  63.         global $frmpro_settings;
    64. 

  64.         $css_file = array(FrmProAppHelper::jquery_css_url($frmpro_settings->theme_css));
    65. 

  65.         
    66. 

  66.         require(FRM_VIEWS_PATH . '/shared/head.php');
    67. 

  67.     }
    68. 

  68.     
    69. 

  69.     function admin_js(){
    70. 

  70.         if (isset($_GET) and isset($_GET['page']) and ($_GET['page'] == 'formidable-entries' or $_GET['page'] == 'formidable-entry-templates' or $_GET['page'] == 'formidable-import')){
    71. 

  71.             
    72. 

  72.             if(!function_exists('wp_editor')){
    73. 

  73.                     add_action( 'admin_print_footer_scripts', 'wp_tiny_mce', 25 );
    74. 

  74.                 add_filter('tiny_mce_before_init', array(&$this, 'remove_fullscreen'));
    75. 

  75.                 if ( user_can_richedit() ){
    76. 

  76.             	    wp_enqueue_script('editor');
    77. 

  77.             	    wp_enqueue_script('media-upload');
    78. 

  78.             	}
    79. 

  79.             	wp_enqueue_script('common');
    80. 

  80.             	wp_enqueue_script('post');
    81. 

  81.         	}
    82. 

  82.         	if($_GET['page'] == 'formidable-entries')
    83. 

  83.         	    wp_enqueue_script('jquery-ui-datepicker');
    84. 

  84.         }
    85. 

  85.     }
    86. 

  86.     
    87. 

  87.     function remove_fullscreen($init){
    88. 

  88.         if(isset($init['plugins'])){
    89. 

  89.             $init['plugins'] = str_replace('wpfullscreen,', '', $init['plugins']);
    90. 

  90.             $init['plugins'] = str_replace('fullscreen,', '', $init['plugins']);
    91. 

  91.         }
    92. 

  92.         return $init;
    93. 

  93.     }
    94. 

  94.     
    95. 

  95.     function register_scripts(){
    96. 

  96.         global $wp_scripts;
    97. 

  97.         wp_register_script('jquery-frm-rating', FRMPRO_URL . '/js/jquery.rating.min.js', array('jquery'), '3.13', true);
    98. 

  98.         wp_register_script('jquery-star-metadata', FRMPRO_URL . '/js/jquery.MetaData.js', array('jquery'), '', true);
    99. 

  99.         wp_register_script('jquery-maskedinput', FRMPRO_URL . '/js/jquery.maskedinput.min.js', array('jquery'), '1.3', true);
    100. 

  100.         wp_register_script('nicedit', FRMPRO_URL . '/js/nicedit.js', array(), '', true);
    101. 

  101.         wp_register_script('jquery-frmtimepicker', FRMPRO_URL . '/js/jquery.timePicker.min.js', array('jquery'), '0.3', true);
    102. 

  102. 

  103.         //jquery-ui-datepicker registered in WP 3.3
    104. 

  104.         if(!isset($wp_scripts->registered) or !isset( $wp_scripts->registered['jquery-ui-datepicker'])){
    105. 

  105.             $date_ver = FrmProAppHelper::datepicker_version();
    106. 

  106.             wp_register_script('jquery-ui-datepicker', FRMPRO_URL . '/js/jquery.ui.datepicker'. $date_ver .'.js', array('jquery', 'jquery-ui-core'), empty($date_ver) ? '1.8.16' : trim($date_ver, '.'), true);
    107. 

  107.         }
    108. 

  108.     }
    109. 

  109.     
    110. 

  110.     function add_js(){        
    111. 

  111.         if(is_admin())
    112. 

  112.             return;
    113. 

  113.          
    114. 

  114.         wp_enqueue_script('jquery-ui-core');
    115. 

  115.         
    116. 

  116.         global $frm_settings;
    117. 

  117.         if($frm_settings->accordion_js){
    118. 

  118.             wp_enqueue_script('jquery-ui-widget');
    119. 

  119.             wp_enqueue_script('jquery-ui-accordion', FRMPRO_URL.'/js/jquery.ui.accordion.js', array('jquery', 'jquery-ui-core'), '1.8.16', true);
    120. 

  120.         }
    121. 

  121.     }
    122. 

  122.     
    123. 

  123.     function footer_js(){
    124. 

  124.         global $frm_rte_loaded, $frm_datepicker_loaded, $frm_timepicker_loaded, $frm_star_loaded;
    125. 

  125.         global $frm_hidden_fields, $frm_forms_loaded, $frm_calc_fields, $frm_rules, $frm_input_masks;
    126. 

  126.         
    127. 

  127.         if(empty($frm_forms_loaded))
    128. 

  128.             return;
    129. 

  129.             
    130. 

  130.         $form_ids = '';
    131. 

  131.         foreach($frm_forms_loaded as $form){
    132. 

  132.             if(!is_object($form))
    133. 

  133.                 continue;
    134. 

  134.                 
    135. 

  135.             if($form_ids != '')
    136. 

  136.                 $form_ids .= ',';
    137. 

  137.             $form_ids .= '#form_'. $form->form_key;
    138. 

  138.         }
    139. 

  139.         
    140. 

  140.         $scripts = array('formidable');
    141. 

  141.         
    142. 

  142.         if(!empty($frm_rte_loaded))
    143. 

  143.             $scripts[] = 'nicedit';
    144. 

  144. 

  145.         if(!empty($frm_datepicker_loaded))
    146. 

  146.             $scripts[] = 'jquery-ui-datepicker';
    147. 

  147.             
    148. 

  148.         if(!empty($frm_timepicker_loaded))
    149. 

  149.             $scripts[] = 'jquery-frmtimepicker';
    150. 

  150. 

  151.         if($frm_star_loaded){ 
    152. 

  152.             $scripts[] = 'jquery-frm-rating';
    153. 

  153. 

  154.             if(is_array($frm_star_loaded) and in_array('split', $frm_star_loaded))
    155. 

  155.                 $scripts[] = 'jquery-star-metadata'; //needed for spliting stars
    156. 

  156.         }
    157. 

  157.         
    158. 

  158.         $frm_input_masks = apply_filters('frm_input_masks', $frm_input_masks, $frm_forms_loaded);
    159. 

  159.         if(!empty($frm_input_masks)) 
    160. 

  160.             $scripts[] = 'jquery-maskedinput';
    161. 

  161.         
    162. 

  162.         if(!empty($scripts)){
    163. 

  163.             global $wp_scripts;
    164. 

  164.             $wp_scripts->do_items( $scripts );
    165. 

  165.         }
    166. 

  166.         
    167. 

  167.         unset($scripts);
    168. 

  168.         
    169. 

  169.         include_once(FRMPRO_VIEWS_PATH.'/frmpro-entries/footer_js.php');
    170. 

  170.     }
    171. 

  171.     
    172. 

  172.     function before_table($footer, $form_id=false){
    173. 

  173.         FrmProEntriesHelper::before_table($footer, $form_id);
    174. 

  174.     }
    175. 

  175.     
    176. 

  176.     /* Back End CRUD */
    177. 

  177.     function show($id = false){
    178. 

  178.         if(!current_user_can('frm_view_entries'))
    179. 

  179.             wp_die('You are not allowed to view entries');
    180. 

  180.             
    181. 

  181.         global $frm_entry, $frm_field, $frm_entry_meta, $user_ID;
    182. 

  182.         if(!$id)
    183. 

  183.             $id = FrmAppHelper::get_param('id');
    184. 

  184.         if(!$id)
    185. 

  185.             $id = FrmAppHelper::get_param('item_id');
    186. 

  186.         
    187. 

  187.         $entry = $frm_entry->getOne($id, true);
    188. 

  188.         $data = maybe_unserialize($entry->description);
    189. 

  189.         if(!is_array($data) or !isset($data['referrer']))
    190. 

  190.             $data = array('referrer' => $data);
    191. 

  191.         
    192. 

  192. 

  193.         $fields = $frm_field->getAll("fi.type not in ('captcha','html') and fi.form_id=". (int)$entry->form_id, 'fi.field_order');
    194. 

  194.         $date_format = get_option('date_format');
    195. 

  195.         $time_format = get_option('time_format');
    196. 

  196.         $show_comments = true;
    197. 

  197.         
    198. 

  198.         if(isset($_POST) and isset($_POST['frm_comment']) and !empty($_POST['frm_comment'])){
    199. 

  199.             FrmEntryMeta::add_entry_meta($_POST['item_id'], 0, '', serialize(array('comment' => $_POST['frm_comment'], 'user_id' => $user_ID)));
    200. 

  200.             //send email notifications
    201. 

  201.         }
    202. 

  202.         
    203. 

  203.         if($show_comments){
    204. 

  204.             $comments = $frm_entry_meta->getAll("item_id=$id and field_id=0", ' ORDER BY it.created_at ASC');
    205. 

  205.             $to_emails = apply_filters('frm_to_email', array(), $entry, $entry->form_id);
    206. 

  206.         }
    207. 

  207.             
    208. 

  208.         require(FRMPRO_VIEWS_PATH.'/frmpro-entries/show.php');
    209. 

  209.     }
    210. 

  210.     
    211. 

  211.     function list_entries(){
    212. 

  212.         $params = $this->get_params();
    213. 

  213.         return $this->display_list($params);
    214. 

  214.     }
    215. 

  215.     
    216. 

  216.     function new_entry(){
    217. 

  217.         global $frm_form;
    218. 

  218.         if($form_id = FrmAppHelper::get_param('form')){
    219. 

  219.             $form = $frm_form->getOne($form_id);
    220. 

  220.             $this->get_new_vars('', $form); 
    221. 

  221.         }else
    222. 

  222.              require(FRMPRO_VIEWS_PATH.'/frmpro-entries/new-selection.php'); 
    223. 

  223.     }
    224. 

  224.     
    225. 

  225.     function create(){
    226. 

  226.         global $frm_form, $frm_entry;
    227. 

  227.         
    228. 

  228.         $params = $this->get_params();
    229. 

  229.         if($params['form'])
    230. 

  230.             $form = $frm_form->getOne($params['form']);
    231. 

  231.             
    232. 

  232.         $errors = $frm_entry->validate($_POST);
    233. 

  233. 

  234.         if( count($errors) > 0 ){
    235. 

  235.             $this->get_new_vars($errors, $form);
    236. 

  236.         }else{
    237. 

  237.             if (isset($_POST['frm_page_order_'.$form->id])){
    238. 

  238.                 $this->get_new_vars('', $form); 
    239. 

  239.             }else{
    240. 

  240.                 $_SERVER['REQUEST_URI'] = str_replace('&frm_action=new', '', $_SERVER['REQUEST_URI']);
    241. 

  241.                 $record = $frm_entry->create( $_POST );
    242. 

  242. 

  243.                 if ($record)
    244. 

  244.                     $message = __('Entry was Successfully Created', 'formidable');
    245. 

  245.                 $this->display_list($params, $message, '', 1);
    246. 

  246.             }
    247. 

  247.         }
    248. 

  248.     }
    249. 

  249.     
    250. 

  250.     function edit(){
    251. 

  251.         $id = FrmAppHelper::get_param('id');
    252. 

  252.         return $this->get_edit_vars($id);
    253. 

  253.     }
    254. 

  254.     
    255. 

  255.     
    256. 

  256.     function update(){
    257. 

  257.         global $frm_entry;
    258. 

  258.         $message = '';
    259. 

  259.         $errors = $frm_entry->validate($_POST);
    260. 

  260.         $id = FrmAppHelper::get_param('id');
    261. 

  261. 

  262.         if( empty($errors) ){
    263. 

  263.             if (isset($_POST['form_id']) and isset($_POST['frm_page_order_'. $_POST['form_id']])){
    264. 

  264.                 return $this->get_edit_vars($id);
    265. 

  265.             }else{
    266. 

  266.                 $record = $frm_entry->update( $id, $_POST );
    267. 

  267.                 //if ($record)
    268. 

  268.                 $message = __('Entry was Successfully Updated', 'formidable') . "<br/> <a href='?page=formidable-entries&form=". $_POST['form_id'] ."'>&larr; ". __('Back to Entries', 'formidable') ."</a>";
    269. 

  269.             }
    270. 

  270.         }
    271. 

  271.         
    272. 

  272.         return $this->get_edit_vars($id,$errors,$message);
    273. 

  273.     }
    274. 

  274.     
    275. 

  275.     function import(){
    276. 

  276.         global $frm_field;
    277. 

  277.         
    278. 

  278.         if(!current_user_can('frm_create_entries'))
    279. 

  279.             wp_die($frm_settings->admin_permission);
    280. 

  280.             
    281. 

  281.         $step = FrmAppHelper::get_param('step', 'One');
    282. 

  282.         $csv_del = FrmAppHelper::get_param('csv_del', ',');
    283. 

  283.         $form_id = FrmAppHelper::get_param('form_id');
    284. 

  284.         
    285. 

  285.         if($step != 'One'){
    286. 

  286.             if($step == 'Two'){
    287. 

  287.                 //validate 
    288. 

  288.                 if(empty($_POST['form_id']) or (empty($_POST['csv']) and (!isset($_FILES) or !isset($_FILES['csv']) or empty($_FILES['csv']['name']) or (int)$_FILES['csv']['size'] <= 0))){
    289. 

  289.                     $errors = array(__('All Fields are required', 'formidable'));
    290. 

  290.                     $step = 'One';
    291. 

  291.                 }else{
    292. 

  292.                     
    293. 

  293.                     //upload
    294. 

  294.                     $media_id = ($_POST['csv'] and is_numeric($_POST['csv'])) ? $_POST['csv'] : FrmProAppHelper::upload_file('csv');
    295. 

  295.                     if($media_id and !is_wp_error($media_id)){
    296. 

  296.                         $current_path = get_attached_file($media_id);
    297. 

  297.                         $row = 1;
    298. 

  298.                         
    299. 

  299.                         $headers = $example = '';
    300. 

  300. 

  301.                         
    302. 

  302.                         if (($f = fopen($current_path, "r")) !== FALSE) {
    303. 

  303.                             $row = 0;
    304. 

  304.                             while (($data = fgetcsv($f, 100000, $csv_del)) !== FALSE) {
    305. 

  305.                                 $row++;
    306. 

  306.                                 
    307. 

  307.                                 if($row == 1)
    308. 

  308.                                     $headers = $data;
    309. 

  309.                                 else if($row == 2)
    310. 

  310.                                     $example = $data;
    311. 

  311.                                 else
    312. 

  312.                                     continue;
    313. 

  313.                             }
    314. 

  314.                             fclose($f);
    315. 

  315.                         }
    316. 

  316.                         
    317. 

  317.                         
    318. 

  318.                         $fields = $frm_field->getAll("fi.type not in ('break','divider','captcha','html') and fi.form_id=". (int)$form_id, 'fi.field_order');
    319. 

  319.                         
    320. 

  320.                     }else if(is_wp_error($media_id)){
    321. 

  321.                         echo $media_id->get_error_message();
    322. 

  322.                         $step = 'One';
    323. 

  323.                     }
    324. 

  324.                 }
    325. 

  325.             }else if($step == 'import'){
    326. 

  326.                 global $frm_ajax_url;
    327. 

  327.                 //IMPORT NOW
    328. 

  328.                 $media_id = FrmAppHelper::get_param('csv');
    329. 

  329.                 $current_path = get_attached_file($media_id);
    330. 

  330.                 $row = FrmAppHelper::get_param('row');
    331. 

  331.                 
    332. 

  332.                 $opts = get_option('frm_import_options');
    333. 

  333.                 
    334. 

  334.                 $left = ($opts and isset($opts[$media_id])) ? ((int)$row - (int)$opts[$media_id]['imported'] - 1) : ($row-1);
    335. 

  335.                     
    336. 

  336.                 $mapping = FrmAppHelper::get_param('data_array');
    337. 

  337.                 $url_vars = "&csv_del=". urlencode($csv_del) ."&form_id={$form_id}&csv={$media_id}&row={$row}";
    338. 

  338.                 foreach($mapping as $mkey => $map)
    339. 

  339.                     $url_vars .= "&data_array[$mkey]=$map";
    340. 

  340.             }
    341. 

  341.         }
    342. 

  342.         
    343. 

  343.         $next_step = ($step == 'One') ? __('Step Two', 'formidable') : __('Import', 'formidable');
    344. 

  344.         
    345. 

  345.         if($step == 'One')
    346. 

  346.             $csvs = get_posts( array('post_type' => 'attachment', 'post_mime_type' => 'text/csv') );
    347. 

  347.         
    348. 

  348.         
    349. 

  349.         include(FRMPRO_VIEWS_PATH.'/frmpro-entries/import.php');
    350. 

  350.     }
    351. 

  351.     
    352. 

  352.     function import_csv_entries(){
    353. 

  353.         if(!current_user_can('frm_create_entries'))
    354. 

  354.             wp_die($frm_settings->admin_permission);
    355. 

  355.             
    356. 

  356.         extract($_POST);
    357. 

  357.         
    358. 

  358.         $opts = get_option('frm_import_options');
    359. 

  359.         if(!$opts)
    360. 

  360.             $opts = array();
    361. 

  361.           
    362. 

  362.         $current_path = get_attached_file($csv);
    363. 

  363.         $start_row = (isset($opts[$csv])) ? $opts[$csv]['imported'] : 1;
    364. 

  364.         $imported = FrmProAppHelper::import_csv($current_path, $form_id, $data_array, 0, $start_row+1, $csv_del);
    365. 

  365. 

  366.         $opts[$csv] = compact('row', 'imported');
    367. 

  367.         echo $remaining = ((int)$row - (int)$imported);
    368. 

  368.         
    369. 

  369.         if(!$remaining)
    370. 

  370.             unset($opts[$csv]);
    371. 

  371.             
    372. 

  372.         update_option('frm_import_options', $opts);
    373. 

  373.         
    374. 

  374.         die();
    375. 

  375.     }
    376. 

  376.     
    377. 

  377.     function duplicate(){
    378. 

  378.         global $frm_entry, $frm_form;
    379. 

  379.         
    380. 

  380.         $params = $this->get_params();
    381. 

  381.         if($params['form'])
    382. 

  382.             $form = $frm_form->getOne($params['form']);
    383. 

  383.         
    384. 

  384.         $message = $errors = '';
    385. 

  385.         $record = $frm_entry->duplicate( $params['id'] );
    386. 

  386.         if ($record)
    387. 

  387.             $message = __('Entry was Successfully Duplicated', 'formidable');
    388. 

  388.         else
    389. 

  389.             $errors = __('There was a problem duplicating that entry', 'formidable');
    390. 

  390.         
    391. 

  391.         if(!empty($errors))
    392. 

  392.             return $this->display_list($params, $errors);
    393. 

  393.         else
    394. 

  394.             return $this->get_edit_vars($record, '', $message);
    395. 

  395.     }
    396. 

  396.     
    397. 

  397.     function destroy(){
    398. 

  398.         if(!current_user_can('frm_delete_entries')){
    399. 

  399.             global $frm_settings;
    400. 

  400.             wp_die($frm_settings->admin_permission);
    401. 

  401.         }
    402. 

  402.         
    403. 

  403.         global $frm_entry, $frm_form;
    404. 

  404.         $params = $this->get_params();
    405. 

  405.         if($params['form'])
    406. 

  406.             $form = $frm_form->getOne($params['form']);
    407. 

  407.         
    408. 

  408.         $message = '';    
    409. 

  409.         if ($frm_entry->destroy( $params['id'] ))
    410. 

  410.             $message = __('Entry was Successfully Destroyed', 'formidable');
    411. 

  411.         $this->display_list($params, $message, '', 1);
    412. 

  412.     }
    413. 

  413.     
    414. 

  414.     function destroy_all(){
    415. 

  415.         if(!current_user_can('frm_delete_entries')){
    416. 

  416.             global $frm_settings;
    417. 

  417.             wp_die($frm_settings->admin_permission);
    418. 

  418.         }
    419. 

  419.         
    420. 

  420.         global $frm_entry, $frm_form, $frmdb;
    421. 

  421.         $params = $this->get_params();
    422. 

  422.         $message = '';    
    423. 

  423.         $errors = array();
    424. 

  424.         if($params['form']){
    425. 

  425.             $form = $frm_form->getOne($params['form']);
    426. 

  426.             $entry_ids = $frmdb->get_col($frmdb->entries, array('form_id' => $form->id));
    427. 

  427.             
    428. 

  428.             foreach($entry_ids as $entry_id){
    429. 

  429.                 if ($frm_entry->destroy( $entry_id ))
    430. 

  430.                     $message = __('Entries were Successfully Destroyed', 'formidable');
    431. 

  431.             }
    432. 

  432.         }else{
    433. 

  433.             $errors = __('No entries were specified', 'formidable');
    434. 

  434.         }
    435. 

  435.         $this->display_list($params, $message, '', 0, $errors);
    436. 

  436.     }
    437. 

  437.     
    438. 

  438.     function bulk_actions($action='list-form'){
    439. 

  439.         global $frm_entry, $frm_settings;
    440. 

  440.         $params = $this->get_params();
    441. 

  441.         $errors = array();
    442. 

  442.         $bulkaction = '-1';
    443. 

  443.         
    444. 

  444.         if($action == 'list-form'){
    445. 

  445.             if($_REQUEST['bulkaction'] != '-1')
    446. 

  446.                 $bulkaction = $_REQUEST['bulkaction'];
    447. 

  447.             else if($_POST['bulkaction2'] != '-1')
    448. 

  448.                 $bulkaction = $_REQUEST['bulkaction2'];
    449. 

  449.         }else{
    450. 

  450.             $bulkaction = str_replace('bulk_', '', $action);
    451. 

  451.         }
    452. 

  452. 

  453.         $items = FrmAppHelper::get_param('item-action', '');
    454. 

  454.         if (empty($items)){
    455. 

  455.             $errors[] = __('No entries were specified', 'formidable');
    456. 

  456.         }else{
    457. 

  457.             if(!is_array($items))
    458. 

  458.                 $items = explode(',', $items);
    459. 

  459.                 
    460. 

  460.             if($bulkaction == 'delete'){
    461. 

  461.                 if(!current_user_can('frm_delete_entries')){
    462. 

  462.                     $errors[] = $frm_settings->admin_permission;
    463. 

  463.                 }else{
    464. 

  464.                     if(is_array($items)){
    465. 

  465.                         foreach($items as $item_id)
    466. 

  466.                             $frm_entry->destroy($item_id);
    467. 

  467.                     }
    468. 

  468.                 }
    469. 

  469.             }else if($bulkaction == 'export'){
    470. 

  470.                 $controller = 'items';
    471. 

  471.                 $ids = $items;
    472. 

  472.                 $ids = implode(',', $ids);
    473. 

  473.                 include_once(FRMPRO_VIEWS_PATH.'/shared/xml.php');
    474. 

  474.             }else if($bulkaction == 'csv'){
    475. 

  475.                 if(!current_user_can('frm_view_entries'))
    476. 

  476.                     wp_die($frm_settings->admin_permission);
    477. 

  477. 

  478.                 global $frm_form;
    479. 

  479.                 
    480. 

  480.                 $form_id = $params['form'];
    481. 

  481.                 if($form_id){
    482. 

  482.                     $form = $frm_form->getOne($form_id);
    483. 

  483.                 }else{
    484. 

  484.                     $form = $frm_form->getAll("is_template=0 AND (status is NULL OR status = '' OR status = 'published')", ' ORDER BY name', ' LIMIT 1');
    485. 

  485.                     if($form)
    486. 

  486.                         $form_id = $form->id;
    487. 

  487.                     else
    488. 

  488.                         $errors[] = __('No form was found', 'formidable');
    489. 

  489.                 }
    490. 

  490.                 
    491. 

  491.                 if($form_id and is_array($items)){
    492. 

  492.                     echo '<script type="text/javascript">window.onload=function(){location.href="'. FRM_SCRIPT_URL .'&controller=entries&form='. $form_id .'&frm_action=csv&item_id='. implode(',', $items) .'";}</script>';
    493. 

  493.                 }
    494. 

  494.             }
    495. 

  495.         }
    496. 

  496.         $this->display_list($params, '', false, false, $errors);
    497. 

  497.     }
    498. 

  498.     
    499. 

  499.     /* Front End CRUD */
    500. 

  500. 

  501.     function process_update_entry($params, $errors, $form){
    502. 

  502.         global $frm_entry, $frm_saved_entries, $frm_created_entry;
    503. 

  503.         
    504. 

  504.         $form->options = stripslashes_deep(maybe_unserialize($form->options));
    505. 

  505.         
    506. 

  506.         if($params['action'] == 'update' and in_array((int)$params['id'], (array)$frm_saved_entries))
    507. 

  507.             return;
    508. 

  508.         
    509. 

  509.         if($params['action'] == 'create' and isset($frm_created_entry[$form->id]) and isset($frm_created_entry[$form->id]['entry_id']) and is_numeric($frm_created_entry[$form->id]['entry_id'])){
    510. 

  510.             $entry_id = $params['id'] = $frm_created_entry[$form->id]['entry_id'];
    511. 

  511.             
    512. 

  512.             FrmProEntriesController::set_cookie($entry_id, $form->id);
    513. 

  513.                 
    514. 

  514.             $conf_method = apply_filters('frm_success_filter', 'message', $form, $form->options);
    515. 

  515.             if ($conf_method == 'redirect'){
    516. 

  516.                 //do_action('frm_success_action', $conf_method, $form, $form->options, $params['id']);
    517. 

  517.                 $success_url = apply_filters('frm_content', $form->options['success_url'], $form, $entry_id);
    518. 

  518.                 $success_url = apply_filters('frm_redirect_url', $success_url, $form, $params);
    519. 

  519.                 wp_redirect( $success_url );
    520. 

  520.                 exit;
    521. 

  521.             }
    522. 

  522.         }else if ($params['action'] == 'update'){
    523. 

  523.             if(in_array((int)$params['id'], (array)$frm_saved_entries)){
    524. 

  524.                 if(isset($_POST['item_meta']))
    525. 

  525.                     unset($_POST['item_meta']);
    526. 

  526. 

  527.                 add_filter('frm_continue_to_new', create_function('', "return $continue;"), 15);
    528. 

  528.                 return;
    529. 

  529.             }
    530. 

  530.             
    531. 

  531.             if (empty($errors)){
    532. 

  532.                 if (isset($form->options['editable_role']) and !FrmAppHelper::user_has_permission($form->options['editable_role'])){
    533. 

  533.                     global $frm_settings;
    534. 

  534.                     wp_die(do_shortcode($frm_settings->login_msg));
    535. 

  535.                 }
    536. 

  536.                 
    537. 

  537.                 if (!isset($_POST['frm_page_order_'. $form->id])){
    538. 

  538.                     $frm_entry->update( $params['id'], $_POST );
    539. 

  539.                     
    540. 

  540.                     //check confirmation method 
    541. 

  541.                     $conf_method = apply_filters('frm_success_filter', 'message', $form);
    542. 

  542.                     
    543. 

  543.                     if ($conf_method == 'redirect'){
    544. 

  544.                         //do_action('frm_success_action', $conf_method, $form, $form->options, $params['id']);
    545. 

  545.                         $success_url = apply_filters('frm_content', $form->options['success_url'], $form, $params['id']);
    546. 

  546.                         $success_url = apply_filters('frm_redirect_url', $success_url, $form, $params);
    547. 

  547.                         wp_redirect( $success_url );
    548. 

  548.                         exit;
    549. 

  549.                     }
    550. 

  550.                 }
    551. 

  551.             }
    552. 

  552.             
    553. 

  553.         }else if ($params['action'] == 'destroy'){
    554. 

  554.             //if the user who created the entry is deleting it
    555. 

  555.             $this->ajax_destroy($form->id, false, false);
    556. 

  556.         }
    557. 

  557.     }
    558. 

  558.         
    559. 

  559.     function edit_update_form($params, $fields, $form, $title, $description){
    560. 

  560.         global $frmdb, $wpdb, $frm_entry, $frm_entry_meta, $user_ID, $frm_editing_entry, $frmpro_settings, $frm_saved_entries;
    561. 

  561.         
    562. 

  562.         $message = '';
    563. 

  563.         $continue = true;
    564. 

  564.         $form->options = stripslashes_deep(maybe_unserialize($form->options));
    565. 

  565. 

  566.         if ($params['action'] == 'edit'){
    567. 

  567.             $entry_key = FrmAppHelper::get_param('entry');
    568. 

  568.             $entry_key = esc_sql($entry_key);
    569. 

  569.             
    570. 

  570.             if($entry_key){    
    571. 

  571.                 $in_form = $wpdb->get_var("SELECT id FROM $frmdb->entries WHERE form_id=".(int)$form->id ." AND (id='{$entry_key}' OR item_key='{$entry_key}')");
    572. 

  572.                 if(!$in_form)
    573. 

  573.                     $entry_key = false;
    574. 

  574.                 unset($in_form);
    575. 

  575.             }
    576. 

  576.             
    577. 

  577.             $entry = FrmProEntry::user_can_edit($entry_key, $form);
    578. 

  578. 

  579.             if($entry and !is_array($entry)){
    580. 

  580.                 $where = "fr.id='$form->id'";
    581. 

  581.                 if ($entry_key)
    582. 

  582.                     $where .= ' AND (it.id="'. $entry_key .'" OR it.item_key="'. $entry_key .'")';
    583. 

  583. 

  584.                 $entry = $frm_entry->getAll( $where, '', 1, true);   
    585. 

  585.             }
    586. 

  586.             
    587. 

  587.             if ($entry and !empty($entry)){
    588. 

  588.                 $entry = reset($entry);
    589. 

  589.                 $frm_editing_entry = $entry->id;
    590. 

  590.                 $this->show_responses($entry, $fields, $form, $title, $description);
    591. 

  591.                 $continue = false;
    592. 

  592.             }
    593. 

  593.         }else if ($params['action'] == 'update' and ($params['posted_form_id'] == $form->id)){
    594. 

  594.             global $frm_created_entry;
    595. 

  595.             
    596. 

  596.             $errors = $frm_created_entry[$form->id]['errors'];
    597. 

  597. 

  598.             if (empty($errors)){
    599. 

  599.                 if (!isset($_POST['frm_page_order_'. $form->id])){
    600. 

  600.                     //check confirmation method 
    601. 

  601.                     $conf_method = apply_filters('frm_success_filter', 'message', $form);
    602. 

  602.                     
    603. 

  603.                     if ($conf_method == 'message'){
    604. 

  604.                         global $frmpro_settings;
    605. 

  605.                         $message = '<div class="frm_message" id="message">'. do_shortcode(isset($form->options['edit_msg']) ? $form->options['edit_msg'] : $frmpro_settings->edit_msg).'</div>';
    606. 

  606.                     }else{
    607. 

  607.                         do_action('frm_success_action', $conf_method, $form, $form->options, $params['id']);
    608. 

  608.                         add_filter('frm_continue_to_new', create_function('', "return false;"), 15);
    609. 

  609.                         return;
    610. 

  610.                     }
    611. 

  611.                 }
    612. 

  612.             }else{
    613. 

  613.                 $fields = FrmFieldsHelper::get_form_fields($form->id, true);
    614. 

  614.             }
    615. 

  615.             
    616. 

  616.             $this->show_responses($params['id'], $fields, $form, $title, $description, $message, $errors);
    617. 

  617.             $continue = false;
    618. 

  618.             
    619. 

  619.         }else if ($params['action'] == 'destroy'){
    620. 

  620.             //if the user who created the entry is deleting it
    621. 

  621.             $message = $this->ajax_destroy($form->id, false);
    622. 

  622.         }else if($frm_editing_entry){
    623. 

  623.             if(is_numeric($frm_editing_entry)){
    624. 

  624.                 $entry_id = $frm_editing_entry; //get entry from shortcode
    625. 

  625.             }else{
    626. 

  626.                 $entry_ids = $wpdb->get_col("SELECT id FROM $frmdb->entries WHERE user_id='$user_ID' and form_id='$form->id'");
    627. 

  627.                 
    628. 

  628.                 if (isset($entry_ids) and !empty($entry_ids)){
    629. 

  629.                     $where_options = $frm_editing_entry;
    630. 

  630.                     if(!empty($where_options))
    631. 

  631.                         $where_options .= ' and ';
    632. 

  632.                     $where_options .= "it.item_id in (".implode(',', $entry_ids).")";
    633. 

  633.                     
    634. 

  634.                     $get_meta = $frm_entry_meta->getAll($where_options, ' ORDER BY it.created_at DESC', ' LIMIT 1');
    635. 

  635.                     $entry_id = ($get_meta) ? $get_meta->item_id : false;
    636. 

  636.                 }
    637. 

  637.             }
    638. 

  638. 

  639.             if(isset($entry_id) and $entry_id){
    640. 

  640.                 if($form->editable and isset($form->options['open_editable']) and $form->options['open_editable'] and isset($form->options['open_editable_role']) and FrmAppHelper::user_has_permission($form->options['open_editable_role']))
    641. 

  641.                     $meta = true;
    642. 

  642.                 else
    643. 

  643.                     $meta = $frmdb->get_var($frmdb->entries, array('user_id' => $user_ID, 'id' => $entry_id, 'form_id' => $form->id ));
    644. 

  644. 

  645.                 if($meta){
    646. 

  646.                     $frm_editing_entry = $entry_id;
    647. 

  647.                     $this->show_responses($entry_id, $fields, $form, $title, $description);
    648. 

  648.                     $continue = false;
    649. 

  649.                 }
    650. 

  650.             }
    651. 

  651.         }else{
    652. 

  652.             //check to see if use is allowed to create another entry
    653. 

  653.             $can_submit = true;
    654. 

  654.             if (isset($form->options['single_entry']) and $form->options['single_entry']){
    655. 

  655.                 if ($form->options['single_entry_type'] == 'cookie' and isset($_COOKIE['frm_form'. $form->id . '_' . COOKIEHASH])){
    656. 

  656.                     $can_submit = false;
    657. 

  657.                 }else if ($form->options['single_entry_type'] == 'ip'){
    658. 

  658.                     $prev_entry = $frm_entry->getAll(array('it.form_id' => $form->id, 'it.ip' => $_SERVER['REMOTE_ADDR']), '', 1);
    659. 

  659.                     if ($prev_entry)
    660. 

  660.                         $can_submit = false;
    661. 

  661.                 }else if ($form->options['single_entry_type'] == 'user' and !$form->editable and $user_ID){
    662. 

  662.                     $meta = $frmdb->get_var($frmdb->entries, array('user_id' => $user_ID, 'form_id' => $form->id ));
    663. 

  663.                     if ($meta)
    664. 

  664.                         $can_submit = false;
    665. 

  665.                 }
    666. 

  666. 

  667.                 if (!$can_submit){
    668. 

  668.                     echo stripslashes($frmpro_settings->already_submitted);//TODO: DO SOMETHING IF USER CANNOT RESUBMIT FORM
    669. 

  669.                     $continue = false;
    670. 

  670.                 }
    671. 

  671.             }
    672. 

  672.         }
    673. 

  673. 

  674.         add_filter('frm_continue_to_new', create_function('', "return $continue;"), 15);
    675. 

  675.     }
    676. 

  676. 

  677.     function show_responses($id, $fields, $form, $title=false,$description=false, $message='', $errors=''){
    678. 

  678.         global $frm_form, $frm_field, $frm_entry, $frmpro_entry, $frm_entry_meta, $user_ID, $frmpro_settings, $frm_next_page, $frm_prev_page, $frm_load_css;
    679. 

  679. 

  680.         if(is_object($id)){
    681. 

  681.             $item = $id;
    682. 

  682.             $id = $item->id;
    683. 

  683.         }else
    684. 

  684.             $item = $frm_entry->getOne($id, true);
    685. 

  685. 

  686.         $values = FrmAppHelper::setup_edit_vars($item, 'entries', $fields);
    687. 

  687. 

  688.         if($values['custom_style']) $frm_load_css = true;
    689. 

  689.         $show_form = true;
    690. 

  690.         $submit = (isset($frm_next_page[$form->id])) ? $frm_next_page[$form->id] : (isset($values['edit_value']) ? $values['edit_value'] : $frmpro_settings->update_value);
    691. 

  691.         
    692. 

  692.         if(!isset($frm_prev_page[$form->id]) and isset($_POST['item_meta']) and empty($errors) and $form->id == FrmAppHelper::get_param('form_id')){
    693. 

  693.             $form->options = stripslashes_deep(maybe_unserialize($form->options));
    694. 

  694.             $show_form = (isset($form->options['show_form'])) ? $form->options['show_form'] : true;
    695. 

  695.             $conf_method = apply_filters('frm_success_filter', 'message', $form);
    696. 

  696.             if ($conf_method != 'message')
    697. 

  697.                 do_action('frm_success_action', $conf_method, $form, $form->options, $id);
    698. 

  698.         }else if(isset($frm_prev_page[$form->id]) or !empty($errors)){
    699. 

  699.             $jump_to_form = true;
    700. 

  700.         }
    701. 

  701. 

  702.         require(FRMPRO_VIEWS_PATH.'/frmpro-entries/edit-front.php');
    703. 

  703.         add_filter('frm_continue_to_new', array($frmpro_entry, 'frmpro_editing'), 10, 3);
    704. 

  704.     }
    705. 

  705.     
    706. 

  706.     function ajax_submit_button($form, $action='create'){
    707. 

  707.         global $frm_novalidate;
    708. 

  708.         
    709. 

  709.         if($frm_novalidate)
    710. 

  710.             echo ' formnovalidate="formnovalidate"';
    711. 

  711.         //if form ajax submit
    712. 

  712.         //echo 'onsubmit="return false;" onclick="frm_submit_form(\''.FRM_SCRIPT_URL.'\',jQuery(\'#form_'. $form->form_key .'\').serialize(), \'form_'. $form->form_key .'\')"';
    713. 

  713. 

  714.     }
    715. 

  715.     
    716. 

  716.     function get_confirmation_method($method, $form){
    717. 

  717.         $method = (isset($form->options['success_action']) and !empty($form->options['success_action'])) ? $form->options['success_action'] : $method;
    718. 

  718.         return $method;
    719. 

  719.     }
    720. 

  720.     
    721. 

  721.     function confirmation($method, $form, $form_options, $entry_id){
    722. 

  722.         //fire the alternate confirmation options ('page' or 'redirect')
    723. 

  723.         if($method == 'page' and is_numeric($form_options['success_page_id'])){
    724. 

  724.             global $post;
    725. 

  725.             if($form_options['success_page_id'] != $post->ID){
    726. 

  726.                 $page = get_post($form_options['success_page_id']);
    727. 

  727.                 $old_post = $post;
    728. 

  728.                 $post = $page;
    729. 

  729.                 $content = apply_filters('frm_content', $page->post_content, $form, $entry_id);
    730. 

  730.                 echo apply_filters('the_content', $content);
    731. 

  731.                 $post = $old_post;
    732. 

  732.             }
    733. 

  733.         }else if($method == 'redirect'){
    734. 

  734.             $success_url = apply_filters('frm_content', $form_options['success_url'], $form, $entry_id);
    735. 

  735.             $success_msg = isset($form_options['success_msg']) ? stripslashes($form_options['success_msg']) : __('Please wait while you are redirected.', 'formidable'); 
    736. 

  736.             $redirect_msg = '<div class="frm-redirect-msg frm_message">'. $success_msg .'<br/>'.
    737. 

  737.                 sprintf(__('%1$sClick here%2$s if you are not automatically redirected.', 'formidable'), '<a href="'. esc_url($success_url) .'">', '</a>') .
    738. 

  738.                 '</div>';
    739. 

  739.                 
    740. 

  740.             echo apply_filters('frm_redirect_msg', $redirect_msg, array(
    741. 

  741.                 'entry_id' => $entry_id, 'form_id' => $form->id, 'form' => $form
    742. 

  742.             ));
    743. 

  743.             
    744. 

  744.             echo "<script type='text/javascript'> jQuery(document).ready(function($){ setTimeout(window.location='". $success_url ."', 5000); });</script>";
    745. 

  745.         }
    746. 

  746.     }
    747. 

  747.     
    748. 

  748.     function delete_entry($post_id){
    749. 

  749.         global $frmdb;
    750. 

  750.         $entry = $frmdb->get_one_record($frmdb->entries, array('post_id' => $post_id), 'id');
    751. 

  751.         if($entry){
    752. 

  752.             global $frm_entry;
    753. 

  753.             $frm_entry->destroy($entry->id);
    754. 

  754.         }
    755. 

  755.     }
    756. 

  756.     
    757. 

  757.     function untrashed_post($post_id){
    758. 

  758.         $display = FrmProDisplay::get_auto_custom_display(array('form_id' => $id, 'entry_id' => $entry_id));
    759. 

  759.         if($display)
    760. 

  760.             update_post_meta($post->ID, 'frm_display_id', $display->ID);
    761. 

  761.         else
    762. 

  762.             delete_post_meta($post->ID, 'frm_display_id');
    763. 

  763.     }
    764. 

  764.     
    765. 

  765.     function create_entry_from_post_box($post_type, $post=false){
    766. 

  766.         if(!$post or !isset($post->ID) or $post_type == 'attachment' or $post_type == 'link')
    767. 

  767.             return;
    768. 

  768.             
    769. 

  769.         global $frmdb, $wpdb, $frm_post_forms;
    770. 

  770.         
    771. 

  771.         //don't show the meta box if there is already an entry for this post
    772. 

  772.         $post_entry = $wpdb->get_var("SELECT id FROM $frmdb->entries WHERE post_id=". $post->ID);
    773. 

  773.         if($post_entry) 
    774. 

  774.             return;
    775. 

  775.         
    776. 

  776.         //don't show meta box if no forms are set up to create this post type
    777. 

  777.         $forms = $wpdb->get_results("SELECT id, name FROM $frmdb->forms where options LIKE '%s:9:\"post_type\";s:". strlen($post_type) .":\"". $post_type ."\";%' AND options LIKE '%s:11:\"create_post\";s:1:\"1\";%'");
    778. 

  778.         if(!$forms)
    779. 

  779.             return;
    780. 

  780.             
    781. 

  781.         $frm_post_forms = $forms;
    782. 

  782.         
    783. 

  783.         add_meta_box('frm_create_entry', __('Create Entry in Form', 'formidable'), array(&$this, 'render_meta_box_content' ), null, 'side');
    784. 

  784.     }
    785. 

  785.     
    786. 

  786.     function render_meta_box_content($post){
    787. 

  787.         global $frm_post_forms, $frm_ajax_url;
    788. 

  788.         $count = count($frm_post_forms);
    789. 

  789.         $i = 1;
    790. 

  790.         
    791. 

  791.         echo '<p>';
    792. 

  792.         foreach($frm_post_forms as $form){
    793. 

  793.             if($i != 1)
    794. 

  794.                 echo ' | ';
    795. 

  795.             
    796. 

  796.             $i++;
    797. 

  797.             echo '<a href="javascript:frm_create_post_entry('. $form->id .','. $post->ID .')">'. stripslashes(FrmAppHelper::truncate($form->name, 15)) .'</a>';
    798. 

  798.             unset($form);
    799. 

  799.         }
    800. 

  800.         unset($i);
    801. 

  801.         echo '</p>';
    802. 

  802.         
    803. 

  803.         
    804. 

  804.         echo "<script type='text/javascript'>function frm_create_post_entry(id,post_id){
    805. 

  805. jQuery('#frm_create_entry p').replaceWith('<img src=\"". FRM_IMAGES_URL ."/wpspin_light.gif\" alt=\"". __('Loading...', 'formidable') ."\" />');
    806. 

  806. jQuery.ajax({type:'POST',url:'{$frm_ajax_url}',data:'action=frm_create_post_entry&id='+id+'&post_id='+post_id,
    807. 

  807. success:function(msg){jQuery('#frm_create_entry').fadeOut('slow');}
    808. 

  808. });
    809. 

  809. };</script>";
    810. 

  810.     }
    811. 

  811.     
    812. 

  812.     function create_post_entry($id=false, $post_id=false){
    813. 

  813.         if(!$id)
    814. 

  814.             $id = $_POST['id'];
    815. 

  815.             
    816. 

  816.         if(!$post_id)
    817. 

  817.             $post_id = $_POST['post_id'];
    818. 

  818.         
    819. 

  819.         if(!is_numeric($id) or !is_numeric($post_id))
    820. 

  820.             return;
    821. 

  821.         
    822. 

  822.         $post = get_post($post_id);
    823. 

  823.         
    824. 

  824.         global $frmdb, $wpdb, $frm_field;
    825. 

  825.         $values = array(
    826. 

  826.             'description' => __('Copied from Post', 'formidable'),
    827. 

  827.             'form_id' => $id,
    828. 

  828.             'created_at' => $post->post_date_gmt,
    829. 

  829.             'name' => $post->post_title,
    830. 

  830.             'item_key' => FrmAppHelper::get_unique_key($post->post_name, $frmdb->entries, 'item_key'),
    831. 

  831.             'user_id' => $post->post_author,
    832. 

  832.             'post_id' => $post->ID
    833. 

  833.         );
    834. 

  834.         
    835. 

  835.         $results = $wpdb->insert( $frmdb->entries, $values );
    836. 

  836.         unset($values);
    837. 

  837.         
    838. 

  838.         if($results){
    839. 

  839.             $entry_id = $wpdb->insert_id;
    840. 

  840.             $user_id_field = $frm_field->getAll(array('fi.type' => 'user_id', 'fi.form_id' => $id), '', 1);
    841. 

  841.             if($user_id_field){
    842. 

  842.                 $new_values = array(
    843. 

  843.                     'meta_value' => $post->post_author,
    844. 

  844.                     'item_id' => $entry_id,
    845. 

  845.                     'field_id' => $user_id_field->id,
    846. 

  846.                     'created_at' => current_time('mysql', 1)
    847. 

  847.                 );
    848. 

  848.                 
    849. 

  849.                 $wpdb->insert( $frmdb->entry_metas, $new_values );
    850. 

  850.             }
    851. 

  851.             
    852. 

  852.             $display = FrmProDisplay::get_auto_custom_display(array('form_id' => $id, 'entry_id' => $entry_id));
    853. 

  853.             if($display)
    854. 

  854.                 update_post_meta($post->ID, 'frm_display_id', $display->ID);
    855. 

  855.         }
    856. 

  856.         die();
    857. 

  857.     }
    858. 

  858. 

  859.     /* Export to CSV */
    860. 

  860.     function csv($form_id, $search = '', $fid = ''){
    861. 

  861.         if(!current_user_can('frm_view_entries')){
    862. 

  862.             global $frm_settings;
    863. 

  863.             wp_die($frm_settings->admin_permission);
    864. 

  864.         }
    865. 

  865. 

  866.         if( !ini_get('safe_mode') ){
    867. 

  867.             set_time_limit(0); //Remove time limit to execute this function
    868. 

  868.             ini_set('memory_limit', '256M');
    869. 

  869.         }
    870. 

  870. 

  871.         global $current_user, $frm_form, $frm_field, $frm_entry, $frm_entry_meta, $wpdb, $frmpro_settings;
    872. 

  872.         
    873. 

  873.         $form = $frm_form->getOne($form_id);
    874. 

  874.         $form_name = sanitize_title_with_dashes($form->name);
    875. 

  875.         $form_cols = $frm_field->getAll("fi.type not in ('divider', 'captcha', 'break', 'html') and fi.form_id=".$form->id, 'field_order ASC');
    876. 

  876.         $item_id = FrmAppHelper::get_param('item_id', false);
    877. 

  877.         $where_clause = "it.form_id=". (int)$form_id;
    878. 

  878.         
    879. 

  879.         if($item_id){
    880. 

  880. 

  881.             $where_clause .= " and it.id in (";
    882. 

  882.             $item_ids = explode(',', $item_id);
    883. 

  883.             foreach((array)$item_ids as $k => $it){
    884. 

  884.                 if($k)
    885. 

  885.                     $where_clause .= ",";
    886. 

  886.                 $where_clause .= $it;
    887. 

  887.                 unset($k);
    888. 

  888.                 unset($it);
    889. 

  889.             }
    890. 

  890. 

  891.             $where_clause .= ")";
    892. 

  892.         }else if(!empty($search)){
    893. 

  893.             $where_clause = $this->get_search_str($where_clause, $search, $form_id, $fid);
    894. 

  894.         }
    895. 

  895.           
    896. 

  896.         $where_clause = apply_filters('frm_csv_where', $where_clause, compact('form_id'));
    897. 

  897. 

  898.         $entries = $frm_entry->getAll($where_clause, '', '', true, false);
    899. 

  899. 

  900.         $filename = date("ymdHis",time()) . '_' . $form_name . '_formidable_entries.csv';
    901. 

  901.         $wp_date_format = apply_filters('frm_csv_date_format', 'Y-m-d H:i:s');
    902. 

  902.         $charset = get_option('blog_charset');
    903. 

  903.         
    904. 

  904.         $to_encoding = $frmpro_settings->csv_format;
    905. 

  905.         
    906. 

  906.         require(FRMPRO_VIEWS_PATH.'/frmpro-entries/csv.php');
    907. 

  907.     }
    908. 

  908. 

  909.     /* Display in Back End */
    910. 

  910.     
    911. 

  911.     function manage_columns($columns){
    912. 

  912.         global $frm_field, $frm_cols;
    913. 

  913.         $form_id = FrmProAppHelper::get_current_form_id();
    914. 

  914.         
    915. 

  915.         $columns['cb'] = '<input type="checkbox" />';
    916. 

  916.         $columns[$form_id .'_id'] = 'ID';
    917. 

  917.         $columns[$form_id .'_item_key'] = __('Entry Key', 'formidable');
    918. 

  918.         
    919. 

  919.         $form_cols = $frm_field->getAll("fi.type not in ('divider', 'captcha', 'break', 'html') and fi.form_id=". $form_id, 'field_order ASC');
    920. 

  920.         foreach($form_cols as $form_col)
    921. 

  921.             $columns[$form_id .'_'. $form_col->field_key] = FrmAppHelper::truncate(stripslashes($form_col->name), 35);
    922. 

  922. 

  923.         $columns[$form_id .'_post_id'] = __('Post', 'formidable');
    924. 

  924.         $columns[$form_id .'_created_at'] = __('Entry creation date', 'formidable');
    925. 

  925.         $columns[$form_id .'_updated_at'] = __('Entry update date', 'formidable');
    926. 

  926.         $columns[$form_id .'_ip'] = 'IP';
    927. 

  927.         
    928. 

  928.         //TODO: allow custom order of columns
    929. 

  929.         
    930. 

  930.         $frm_cols = $columns;
    931. 

  931.         add_screen_option( 'per_page', array('label' => __('Entries', 'formidable'), 'default' => 20, 'option' => 'formidable_page_formidable_entries_per_page') );
    932. 

  932.         
    933. 

  933.         return $columns;
    934. 

  934.     }
    935. 

  935.     
    936. 

  936.     function check_hidden_cols($check, $object_id, $meta_key, $meta_value, $prev_value){
    937. 

  937.         global $frm_settings;
    938. 

  938.         if($meta_key != 'manage'.  sanitize_title($frm_settings->menu) .'_page_formidable-entriescolumnshidden' or $meta_value == $prev_value)
    939. 

  939.             return $check;
    940. 

  940.         
    941. 

  941.         if ( empty($prev_value) )
    942. 

  942.     		$prev_value = get_metadata('user', $object_id, $meta_key, true);
    943. 

  943.     		
    944. 

  944.         global $frm_prev_hidden_cols;
    945. 

  945.         $frm_prev_hidden_cols = ($frm_prev_hidden_cols) ? false : $prev_value; //add a check so we don't create a loop
    946. 

  946. 

  947.         return $check;
    948. 

  948.     }
    949. 

  949.     
    950. 

  950.     //add hidden columns back from other forms
    951. 

  951.     function update_hidden_cols($meta_id, $object_id, $meta_key, $meta_value ){
    952. 

  952.         global $frm_settings;
    953. 

  953. 

  954.         if($meta_key != 'manage'.  sanitize_title($frm_settings->menu) .'_page_formidable-entriescolumnshidden')
    955. 

  955.             return;
    956. 

  956.             
    957. 

  957.         global $frm_prev_hidden_cols;
    958. 

  958.         if(!$frm_prev_hidden_cols)
    959. 

  959.             return; //don't continue if there's no previous value
    960. 

  960.         
    961. 

  961.         foreach($meta_value as $mk => $mv){
    962. 

  962.             //remove blank values
    963. 

  963.             if(empty($mv))
    964. 

  964.                 unset($meta_value[$mk]);
    965. 

  965.         }
    966. 

  966.         
    967. 

  967.         $cur_form_prefix = reset($meta_value);
    968. 

  968.         $cur_form_prefix = explode('_', $cur_form_prefix);
    969. 

  969.         $cur_form_prefix = $cur_form_prefix[0];
    970. 

  970.         $save = false;
    971. 

  971. 

  972.         foreach($frm_prev_hidden_cols as $prev_hidden){
    973. 

  973.             if(empty($prev_hidden) or in_array($prev_hidden, $meta_value)) //don't add blank cols or process included cols
    974. 

  974.                 continue;
    975. 

  975.             
    976. 

  976.             $form_prefix = explode('_', $prev_hidden);
    977. 

  977.             $form_prefix = $form_prefix[0];
    978. 

  978.             if($form_prefix == $cur_form_prefix) //don't add back columns that are meant to be hidden
    979. 

  979.                 continue;
    980. 

  980.             
    981. 

  981.             $meta_value[] = $prev_hidden;
    982. 

  982.             $save = true;
    983. 

  983.             unset($form_prefix);
    984. 

  984.         }
    985. 

  985.         
    986. 

  986.         if($save){
    987. 

  987.             $user = wp_get_current_user();
    988. 

  988.             update_user_option($user->ID, 'manage'.  sanitize_title($frm_settings->menu) .'_page_formidable-entriescolumnshidden', $meta_value, true);
    989. 

  989.         }
    990. 

  990.     }
    991. 

  991.     
    992. 

  992.     function save_per_page($save, $option, $value){
    993. 

  993.         if($option == 'formidable_page_formidable_entries_per_page')
    994. 

  994.             $save = (int)$value;
    995. 

  995.         return $save;
    996. 

  996.     }
    997. 

  997.     
    998. 

  998.     function sortable_columns(){
    999. 

  999.         $form_id = FrmProAppHelper::get_current_form_id();
    1000. 

  1000.         return array(
    1001. 

  1001.             $form_id .'_id'         => 'id',
    1002. 

  1002.             $form_id .'_created_at' => 'created_at',
    1003. 

  1003.             $form_id .'_updated_at' => 'updated_at',
    1004. 

  1004.             $form_id .'_ip'         => 'ip',
    1005. 

  1005.             $form_id .'_item_key'   => 'item_key'
    1006. 

  1006.         );
    1007. 

  1007.     }
    1008. 

  1008.     
    1009. 

  1009.     function hidden_columns($result){
    1010. 

  1010.         global $frm_cols;
    1011. 

  1011. 

  1012.         $form_id = FrmProAppHelper::get_current_form_id();
    1013. 

  1013.         
    1014. 

  1014.         $return = false;
    1015. 

  1015.         foreach((array)$result as $r){
    1016. 

  1016.             if(!empty($r)){
    1017. 

  1017.                 $form_prefix = explode('_', $r);
    1018. 

  1018.                 $form_prefix = $form_prefix[0];
    1019. 

  1019.                 
    1020. 

  1020.                 if((int)$form_prefix == (int)$form_id){
    1021. 

  1021.                     $return = true;
    1022. 

  1022.                     break;
    1023. 

  1023.                 }
    1024. 

  1024.                 
    1025. 

  1025.                 unset($form_prefix);
    1026. 

  1026.             }
    1027. 

  1027.         }
    1028. 

  1028.         
    1029. 

  1029.         if($return)
    1030. 

  1030.             return $result;
    1031. 

  1031.  
    1032. 

  1032.         $i = count($frm_cols);
    1033. 

  1033.         $max_columns = 8;
    1034. 

  1034.         if($i > $max_columns){
    1035. 

  1035.             global $frm_current_form;
    1036. 

  1036.             if($frm_current_form)
    1037. 

  1037.                 $frm_current_form->options = maybe_unserialize($frm_current_form->options);
    1038. 

  1038.             if($frm_current_form and isset($frm_current_form->options['hidden_cols']) and !empty($frm_current_form->options['hidden_cols'])){
    1039. 

  1039.                 $result = $frm_current_form->options['hidden_cols'];
    1040. 

  1040.             }else{
    1041. 

  1041.                 $cols = $frm_cols;
    1042. 

  1042.                 $cols = array_reverse($cols, true);
    1043. 

  1043. 

  1044.                 $result[] = $form_id .'_id';
    1045. 

  1045.                 $i--;
    1046. 

  1046.                 
    1047. 

  1047.                 $result[] = $form_id .'_item_key';
    1048. 

  1048.                 $i--;
    1049. 

  1049.                 
    1050. 

  1050.                 foreach($cols as $col_key => $col){
    1051. 

  1051.                     if($i > $max_columns)
    1052. 

  1052.                         $result[] = $col_key; //remove some columns by default
    1053. 

  1053.                     $i--;
    1054. 

  1054.                 }
    1055. 

  1055.             }
    1056. 

  1056.         }
    1057. 

  1057.         
    1058. 

  1058.         return $result;
    1059. 

  1059.     }
    1060. 

  1060.     
    1061. 

  1061.     function display_list($params=false, $message='', $page_params_ov = false, $current_page_ov = false, $errors = array()){
    1062. 

  1062.         global $wpdb, $frmdb, $frm_app_helper, $frm_form, $frm_entry, $frm_entry_meta, $frm_page_size, $frm_field, $frm_current_form;
    1063. 

  1063.         
    1064. 

  1064.         if(!$params)
    1065. 

  1065.             $params = $this->get_params();
    1066. 

  1066.    
    1067. 

  1067.         $errors = array();
    1068. 

  1068.         
    1069. 

  1069.         $form_select = $frm_form->getAll("is_template=0 AND (status is NULL OR status = '' OR status = 'published')", ' ORDER BY name');
    1070. 

  1070. 

  1071.         if($params['form'])
    1072. 

  1072.             $form = $frm_form->getOne($params['form']);
    1073. 

  1073.         else
    1074. 

  1074.             $form = (isset($form_select[0])) ? $form_select[0] : 0;
    1075. 

  1075.         
    1076. 

  1076.         if($form){
    1077. 

  1077.             $params['form'] = $form->id;
    1078. 

  1078.             $frm_current_form = $form;
    1079. 

  1079. 	        $where_clause = " it.form_id=$form->id";
    1080. 

  1080.         }else{
    1081. 

  1081.             $where_clause = '';
    1082. 

  1082. 		}
    1083. 

  1083.         
    1084. 

  1084.         $page_params = "&action=0&frm_action=0&form=";
    1085. 

  1085.         $page_params .= ($form) ? $form->id : 0;
    1086. 

  1086.         
    1087. 

  1087.         if ( ! empty( $_REQUEST['s'] ) )
    1088. 

  1088.             $page_params .= '&s='. urlencode($_REQUEST['s']);
    1089. 

  1089.         
    1090. 

  1090.         if ( ! empty( $_REQUEST['search'] ) )
    1091. 

  1091.             $page_params .= '&search='. urlencode($_REQUEST['search']);
    1092. 

  1092. 

  1093.     	if ( ! empty( $_REQUEST['fid'] ) )
    1094. 

  1094.     	    $page_params .= '&fid='. $_REQUEST['fid'];
    1095. 

  1095.         
    1096. 

  1096.         if(class_exists('WP_List_Table')){
    1097. 

  1097.             require_once(FRMPRO_PATH .'/classes/helpers/FrmProListHelper.php');
    1098. 

  1098. 

  1099.             $wp_list_table = new FrmProListHelper(array('singular' => 'entry', 'plural' => 'entries', 'table_name' => $frmdb->entries, 'page_name' => 'entries', 'params' => $params));
    1100. 

  1100. 

  1101.             $pagenum = $wp_list_table->get_pagenum();
    1102. 

  1102. 

  1103.             $wp_list_table->prepare_items();
    1104. 

  1104. 

  1105.             $total_pages = $wp_list_table->get_pagination_arg( 'total_pages' );
    1106. 

  1106.             if ( $pagenum > $total_pages && $total_pages > 0 ) {
    1107. 

  1107.             	wp_redirect( add_query_arg( 'paged', $total_pages ) );
    1108. 

  1108.             	exit;
    1109. 

  1109.             }
    1110. 

  1110.         }else{
    1111. 

  1111.             $item_vars = $this->get_sort_vars($params, $where_clause);
    1112. 

  1112.     		$page_params .= ($page_params_ov) ? $page_params_ov : $item_vars['page_params'];
    1113. 

  1113.     		
    1114. 

  1114.             if($form){
    1115. 

  1115.     			$form_cols = $frm_field->getAll("fi.type not in ('divider', 'captcha', 'break', 'html') and fi.form_id=". (int)$form->id, 'field_order ASC', ' LIMIT 7');
    1116. 

  1116.     	        $record_where = ($item_vars['where_clause'] == " it.form_id=$form->id") ? $form->id : $item_vars['where_clause'];
    1117. 

  1117.     	    }else{
    1118. 

  1118.     	        $form_cols = array();
    1119. 

  1119.     	        $record_where = $item_vars['where_clause'];
    1120. 

  1120.     	    }
    1121. 

  1121.     	    
    1122. 

  1122.             $current_page = ($current_page_ov) ? $current_page_ov: $params['paged'];
    1123. 

  1123.             
    1124. 

  1124.             $sort_str = $item_vars['sort_str'];
    1125. 

  1125.             $sdir_str = $item_vars['sdir_str'];
    1126. 

  1126.             $search_str = $item_vars['search_str'];
    1127. 

  1127.             $fid = $item_vars['fid'];
    1128. 

  1128.               
    1129. 

  1129.             $record_count = $frm_entry->getRecordCount($record_where);
    1130. 

  1130.             $page_count = $frm_entry->getPageCount($frm_page_size, $record_count);
    1131. 

  1131.             $items = $frm_entry->getPage($current_page, $frm_page_size, $item_vars['where_clause'], $item_vars['order_by']);
    1132. 

  1132.             $page_last_record = $frm_app_helper->getLastRecordNum($record_count, $current_page, $frm_page_size);
    1133. 

  1133.             $page_first_record = $frm_app_helper->getFirstRecordNum($record_count, $current_page, $frm_page_size);
    1134. 

  1134.         }
    1135. 

  1135. 

  1136.         require_once(FRMPRO_VIEWS_PATH.'/frmpro-entries/list.php');
    1137. 

  1137.     }
    1138. 

  1138.     
    1139. 

  1139.     function get_sort_vars($params=false, $where_clause = ''){
    1140. 

  1140.         global $frm_entry_meta, $frm_current_form;
    1141. 

  1141.         
    1142. 

  1142.         if(!$params)
    1143. 

  1143.             $params = $this->get_params($frm_current_form);
    1144. 

  1144.  
    1145. 

  1145.         $order_by = '';
    1146. 

  1146.         $page_params = '';
    1147. 

  1147. 

  1148.         // These will have to work with both get and post
    1149. 

  1149.         $sort_str = $params['sort'];
    1150. 

  1150.         $sdir_str = $params['sdir'];
    1151. 

  1151.         $search_str = $params['search'];
    1152. 

  1152.         $fid = $params['fid'];
    1153. 

  1153. 

  1154.         // make sure page params stay correct
    1155. 

  1155.         if(!empty($sort_str))
    1156. 

  1156.             $page_params .="&sort=$sort_str";
    1157. 

  1157. 

  1158.         if(!empty($sdir_str))
    1159. 

  1159.             $page_params .= "&sdir=$sdir_str";
    1160. 

  1160. 

  1161.         if(!empty($search_str)){
    1162. 

  1162.             $where_clause = $this->get_search_str($where_clause, $search_str, $params['form'], $fid);
    1163. 

  1163.             $page_params .= "&search=$search_str";
    1164. 

  1164.             if(is_numeric($fid))
    1165. 

  1165.                 $page_params .= "&fid=$fid";
    1166. 

  1166.         }
    1167. 

  1167. 

  1168.         // Add order by clause
    1169. 

  1169.         if(is_numeric($sort_str))
    1170. 

  1170.             $order_by .= " ORDER BY ID"; //update this to order by item meta
    1171. 

  1171.         else if ($sort_str == "item_key")
    1172. 

  1172.             $order_by .= " ORDER BY item_key";
    1173. 

  1173.         else
    1174. 

  1174.             $order_by .= " ORDER BY ID";
    1175. 

  1175. 

  1176. 

  1177.         // Toggle ascending / descending
    1178. 

  1178.         if((empty($sort_str) and empty($sdir_str)) or $sdir_str == 'desc'){
    1179. 

  1179.             $order_by .= ' DESC';
    1180. 

  1180.             $sdir_str = 'desc';
    1181. 

  1181.         }else{
    1182. 

  1182.             $order_by .= ' ASC';
    1183. 

  1183.             $sdir_str = 'asc';
    1184. 

  1184.         }
    1185. 

  1185.         
    1186. 

  1186.         return compact('order_by', 'sort_str', 'sdir_str', 'fid', 'search_str', 'where_clause', 'page_params');
    1187. 

  1187.     }
    1188. 

  1188.     
    1189. 

  1189.     function get_search_str($where_clause='', $search_str, $form_id=false, $fid=false){
    1190. 

  1190.         global $frm_entry_meta;
    1191. 

  1191.         
    1192. 

  1192.         $where_item = '';
    1193. 

  1193.         $join = ' (';
    1194. 

  1194.         if(!is_array($search_str))
    1195. 

  1195.             $search_str = explode(" ", $search_str);
    1196. 

  1196.         
    1197. 

  1197.         foreach($search_str as $search_param){
    1198. 

  1198.             $search_param = esc_sql( like_escape( $search_param ) );
    1199. 

  1199. 			
    1200. 

  1200.             if(!is_numeric($fid)){
    1201. 

  1201.                 $where_item .= (empty($where_item)) ? ' (' : ' OR';
    1202. 

  1202.                     
    1203. 

  1203.                 if(in_array($fid, array('created_at', 'user_id', 'updated_at'))){
    1204. 

  1204.                     if($fid == 'user_id' and !is_numeric($search_param))
    1205. 

  1205.                         $search_param = FrmProAppHelper::get_user_id_param($search_param);
    1206. 

  1206.                     
    1207. 

  1207.                     $where_item .= " it.{$fid} like '%$search_param%'";
    1208. 

  1208.                 }else{
    1209. 

  1209.                     $where_item .= " it.name like '%$search_param%' OR it.item_key like '%$search_param%' OR it.description like '%$search_param%' OR it.created_at like '%$search_param%'";
    1210. 

  1210.                 }
    1211. 

  1211.             }
    1212. 

  1212.             
    1213. 

  1213.             if(empty($fid) or is_numeric($fid)){
    1214. 

  1214.                 $where_entries = "(meta_value LIKE '%$search_param%'";
    1215. 

  1215.                 if($data_fields = FrmProForm::has_field('data', $form_id, false)){
    1216. 

  1216.                     $df_form_ids = array();
    1217. 

  1217. 

  1218.                     //search the joined entry too
    1219. 

  1219.                     foreach((array)$data_fields as $df){
    1220. 

  1220.                         $df->field_options = maybe_unserialize($df->field_options);
    1221. 

  1221.                         if (is_numeric($df->field_options['form_select']))
    1222. 

  1222.                             $df_form_ids[] = $df->field_options['form_select'];
    1223. 

  1223. 

  1224.                         unset($df);
    1225. 

  1225.                     }
    1226. 

  1226.                     
    1227. 

  1227.                     unset($data_fields);
    1228. 

  1228. 

  1229.                     global $wpdb, $frmdb;
    1230. 

  1230.                     $data_form_ids = $wpdb->get_col("SELECT form_id FROM $frmdb->fields WHERE id in (". implode(',', $df_form_ids).")");
    1231. 

  1231.                     unset($df_form_ids);
    1232. 

  1232. 

  1233.                     if($data_form_ids){
    1234. 

  1234.                         $data_entry_ids = $frm_entry_meta->getEntryIds("fi.form_id in (". implode(',', $data_form_ids).") and meta_value LIKE '%". $search_param ."%'");
    1235. 

  1235.                         if(!empty($data_entry_ids))
    1236. 

  1236.                             $where_entries .= " OR meta_value in (".implode(',', $data_entry_ids).")";
    1237. 

  1237.                     }
    1238. 

  1238. 

  1239.                     unset($data_form_ids);
    1240. 

  1240.                 }
    1241. 

  1241.                 
    1242. 

  1242.                 $where_entries .= ")";
    1243. 

  1243. 

  1244.                 if(is_numeric($fid))
    1245. 

  1245.                     $where_entries .= " AND fi.id=$fid";
    1246. 

  1246. 

  1247.                 $meta_ids = $frm_entry_meta->getEntryIds($where_entries);
    1248. 

  1248.                 if (!empty($meta_ids)){
    1249. 

  1249.                     if(!empty($where_clause)){
    1250. 

  1250.                         $where_clause .= " AND" . $join;
    1251. 

  1251.                         if(!empty($join)) $join = '';
    1252. 

  1252.                     }
    1253. 

  1253.                     $where_clause .= " it.id in (".implode(',', $meta_ids).")";
    1254. 

  1254.                 }else{
    1255. 

  1255.                     if(!empty($where_clause)){
    1256. 

  1256.                         $where_clause .= " AND" . $join;
    1257. 

  1257.                         if(!empty($join)) $join = '';
    1258. 

  1258.                     }
    1259. 

  1259.                     $where_clause .= " it.id=0";
    1260. 

  1260.                 }
    1261. 

  1261.             }
    1262. 

  1262.         }
    1263. 

  1263.         
    1264. 

  1264.         if(!empty($where_item)){
    1265. 

  1265.             $where_item .= ')';
    1266. 

  1266.             if(!empty($where_clause))
    1267. 

  1267.                 $where_clause .= empty($fid) ? ' OR' : ' AND';
    1268. 

  1268.             $where_clause .= $where_item;
    1269. 

  1269.             if(empty($join))
    1270. 

  1270.                 $where_clause .= ')';
    1271. 

  1271.         }else{
    1272. 

  1272.             if(empty($join))
    1273. 

  1273.                 $where_clause .= ')';
    1274. 

  1274.         }
    1275. 

  1275. 

  1276.         return $where_clause;
    1277. 

  1277.     }
    1278. 

  1278. 

  1279.     function get_new_vars($errors = '', $form = '',$message = ''){
    1280. 

  1280.         global $frm_form, $frm_field, $frm_entry, $frm_settings, $frm_next_page;
    1281. 

  1281.         $title = true;
    1282. 

  1282.         $description = true;
    1283. 

  1283.         $fields = FrmFieldsHelper::get_form_fields($form->id, !empty($errors));
    1284. 

  1284.         $values = FrmEntriesHelper::setup_new_vars($fields, $form);
    1285. 

  1285.         $submit = (isset($frm_next_page[$form->id])) ? $frm_next_page[$form->id] : (isset($values['submit_value']) ? $values['submit_value'] : $frm_settings->submit_value);  
    1286. 

  1286.         require_once(FRMPRO_VIEWS_PATH.'/frmpro-entries/new.php');
    1287. 

  1287.     }
    1288. 

  1288. 

  1289.     function get_edit_vars($id, $errors = '', $message= ''){
    1290. 

  1290.         if(!current_user_can('frm_edit_entries'))
    1291. 

  1291.             return $this->show($id);
    1292. 

  1292. 

  1293.         global $frm_form, $frm_entry, $frm_field, $frm_next_page, $frmpro_settings, $frm_editing_entry;
    1294. 

  1294.         $title = $description = true;
    1295. 

  1295.         $record = $frm_entry->getOne( $id, true );
    1296. 

  1296.         $frm_editing_entry = $id;
    1297. 

  1297.         
    1298. 

  1298.         $form = $frm_form->getOne($record->form_id);
    1299. 

  1299.         $fields = FrmFieldsHelper::get_form_fields($form->id, !empty($errors));
    1300. 

  1300.         $values = FrmAppHelper::setup_edit_vars($record, 'entries', $fields);
    1301. 

  1301. 

  1302.         $submit = (isset($frm_next_page[$form->id])) ? $frm_next_page[$form->id] : (isset($values['edit_value']) ? $values['edit_value'] : $frmpro_settings->update_value); 
    1303. 

  1303.         require(FRMPRO_VIEWS_PATH.'/frmpro-entries/edit.php');
    1304. 

  1304.     }
    1305. 

  1305.     
    1306. 

  1306.     function get_params($form=null){
    1307. 

  1307.         global $frm_form;
    1308. 

  1308. 

  1309.         if(!$form)
    1310. 

  1310.             $form = $frm_form->getAll("is_template=0 AND (status is NULL OR status = '' OR status = 'published')", ' ORDER BY name', ' LIMIT 1');
    1311. 

  1311.         
    1312. 

  1312.         $values = array();
    1313. 

  1313.         foreach (array('id' => '', 'form_name' => '', 'paged' => 1, 'form' => (($form) ? $form->id : 0), 'field_id' => '', 'search' => '', 'sort' => '', 'sdir' => '', 'fid' => '') as $var => $default)
    1314. 

  1314.             $values[$var] = FrmAppHelper::get_param($var, $default);
    1315. 

  1315. 

  1316.         return $values;
    1317. 

  1317.     }
    1318. 

  1318.     
    1319. 

  1319.     function &filter_shortcode_value($value, $tag, $atts, $field){
    1320. 

  1320.         if(isset($atts['show']) and $atts['show'] == 'value')
    1321. 

  1321.             return $value;
    1322. 

  1322.             
    1323. 

  1323.         $value = $this->filter_display_value($value, $field);
    1324. 

  1324.         return $value;
    1325. 

  1325.     }
    1326. 

  1326.     
    1327. 

  1327.     function &filter_display_value($value, $field){
    1328. 

  1328.         global $frm_entries_controller;
    1329. 

  1329.         $value = $frm_entries_controller->filter_display_value($value, $field);
    1330. 

  1330.         return $value;
    1331. 

  1331.     }
    1332. 

  1332. 

  1333.     function route(){
    1334. 

  1334.         $action = FrmAppHelper::get_param('frm_action');
    1335. 

  1335.             
    1336. 

  1336.         if($action == 'show')
    1337. 

  1337.             return $this->show();
    1338. 

  1338.         else if($action == 'new')
    1339. 

  1339.             return $this->new_entry();
    1340. 

  1340.         else if($action == 'create')
    1341. 

  1341.             return $this->create();
    1342. 

  1342.         else if($action == 'edit')
    1343. 

  1343.             return $this->edit();
    1344. 

  1344.         else if($action == 'update')
    1345. 

  1345.             return $this->update();
    1346. 

  1346.         else if($action == 'import')
    1347. 

  1347.             return $this->import();
    1348. 

  1348.         else if($action == 'duplicate')
    1349. 

  1349.             return $this->duplicate();
    1350. 

  1350.         else if($action == 'destroy')
    1351. 

  1351.             return $this->destroy();
    1352. 

  1352.         else if($action == 'destroy_all')
    1353. 

  1353.             return $this->destroy_all();
    1354. 

  1354.         else if($action == 'list-form')
    1355. 

  1355.             return $this->bulk_actions($action);
    1356. 

  1356.         else{
    1357. 

  1357.             $action = FrmAppHelper::get_param('action');
    1358. 

  1358.             if($action == -1)
    1359. 

  1359.                 $action = FrmAppHelper::get_param('action2');
    1360. 

  1360.             
    1361. 

  1361.             if(strpos($action, 'bulk_') === 0){
    1362. 

  1362.                 if(isset($_GET) and isset($_GET['action']))
    1363. 

  1363.                     $_SERVER['REQUEST_URI'] = str_replace('&action='.$_GET['action'], '', $_SERVER['REQUEST_URI']);
    1364. 

  1364.                 if(isset($_GET) and isset($_GET['action2']))
    1365. 

  1365.                     $_SERVER['REQUEST_URI'] = str_replace('&action='.$_GET['action2'], '', $_SERVER['REQUEST_URI']);
    1366. 

  1366.                     
    1367. 

  1367.                 return $this->bulk_actions($action);
    1368. 

  1368.             }else{
    1369. 

  1369.                 return $this->display_list();
    1370. 

  1370.             }
    1371. 

  1371.         }
    1372. 

  1372.     }
    1373. 

  1373.     
    1374. 

  1374.     function get_form_results($atts){
    1375. 

  1375.         extract(shortcode_atts(array('id' => false, 'cols' => 99, 'style' => true, 'no_entries' => __('No Entries Found', 'formidable'), 'fields' => false, 'clickable' => false, 'user_id' => false, 'google' => false, 'pagesize' => 20, 'sort' => true, 'edit_link' => false, 'page_id' => false), $atts));
    1376. 

  1376.         if (!$id) return;
    1377. 

  1377.         
    1378. 

  1378.         global $frm_form, $frm_field, $frm_entry, $frm_entry_meta, $frmpro_settings;
    1379. 

  1379.         $form = $frm_form->getOne($id);
    1380. 

  1380.         if (!$form) return;
    1381. 

  1381.         $where = "fi.type not in ('divider', 'captcha', 'break', 'html') and fi.form_id=". (int)$form->id;
    1382. 

  1382.         if($fields){
    1383. 

  1383.             $fields = explode(',', $fields);
    1384. 

  1384.             $f_list = array();
    1385. 

  1385.             foreach($fields as $k => $f){
    1386. 

  1386.                 $f = trim($f);
    1387. 

  1387.                 $fields[$k] = $f;
    1388. 

  1388.                 $f_list[] = esc_sql(like_escape($f)); 
    1389. 

  1389.                 unset($k);
    1390. 

  1390.                 unset($f);
    1391. 

  1391.             }
    1392. 

  1392.             if(count($fields) == 1 and in_array('id', $fields))
    1393. 

  1393.                 $where .= ''; //don't search fields if only field id
    1394. 

  1394.             else
    1395. 

  1395.                 $where .= " and (fi.id in ('". implode("','", $f_list)  ."') or fi.field_key in ('". implode("','", $f_list) ."'))";
    1396. 

  1396.             
    1397. 

  1397.         }
    1398. 

  1398.         $fields = (array)$fields;
    1399. 

  1399.         
    1400. 

  1400.         $form_cols = $frm_field->getAll($where, 'field_order ASC', $cols);
    1401. 

  1401.         unset($where);
    1402. 

  1402.         
    1403. 

  1403.         $where = 'it.form_id='. (int)$form->id;
    1404. 

  1404.         if($user_id)
    1405. 

  1405.             $where .= ' AND user_id='. (int)FrmProAppHelper::get_user_id_param($user_id);
    1406. 

  1406.             
    1407. 

  1407.         $s = FrmAppHelper::get_param('frm_search', false);
    1408. 

  1408.         if ($s){
    1409. 

  1409.             $new_ids = FrmProEntriesHelper::get_search_ids($s, $form->id);
    1410. 

  1410.             $where .= ' AND it.id in ('. implode(',', $new_ids) .')';
    1411. 

  1411.         }
    1412. 

  1412.         
    1413. 

  1413.         if(isset($new_ids) and empty($new_ids))
    1414. 

  1414.             $entries = false;
    1415. 

  1415.         else
    1416. 

  1416.             $entries = $frm_entry->getAll($where, '', '', true, false);
    1417. 

  1417.         
    1418. 

  1418.         if($edit_link){
    1419. 

  1419.             $anchor = '';
    1420. 

  1420.             if(!$page_id){
    1421. 

  1421.                 global $post;
    1422. 

  1422.                 $page_id = $post->ID;
    1423. 

  1423.                 $anchor = '#form_'. $form->form_key;
    1424. 

  1424.             }
    1425. 

  1425.             if($edit_link === '1')
    1426. 

  1426.                 $edit_link = __('Edit', 'formidable');
    1427. 

  1427.                 
    1428. 

  1428.             $permalink = get_permalink($page_id);
    1429. 

  1429.         }
    1430. 

  1430.         
    1431. 

  1431.         if($style){
    1432. 

  1432.             global $frm_load_css;
    1433. 

  1433.             $frm_load_css = true;
    1434. 

  1434.         }
    1435. 

  1435.         
    1436. 

  1436.         $filename = 'table';
    1437. 

  1437.         if($google){
    1438. 

  1438.             global $frm_google_chart;
    1439. 

  1439.             $filename = 'google_table';
    1440. 

  1440.             $options = array();
    1441. 

  1441.             
    1442. 

  1442.             if($pagesize)
    1443. 

  1443.                 $options = array('page' => 'enable', 'pageSize' => (int)$pagesize);
    1444. 

  1444.                 
    1445. 

  1445.             $options['allowHtml'] = true;
    1446. 

  1446.             $options['sort'] = ($sort) ? 'enable' : 'disable';
    1447. 

  1447.             
    1448. 

  1448.             if($style)
    1449. 

  1449.                 $options['cssClassNames'] = array('oddTableRow' => 'frm_even');
    1450. 

  1450.         }
    1451. 

  1451.         
    1452. 

  1452.         ob_start();
    1453. 

  1453.         include(FRMPRO_VIEWS_PATH .'/frmpro-entries/'. $filename .'.php');
    1454. 

  1454.         $contents = ob_get_contents();
    1455. 

  1455.         ob_end_clean();
    1456. 

  1456.         
    1457. 

  1457.         if(!$google and $clickable)
    1458. 

  1458.             $contents = make_clickable($contents);
    1459. 

  1459.         return $contents;
    1460. 

  1460.     }
    1461. 

  1461.     
    1462. 

  1462.     function get_search($atts){
    1463. 

  1463.         extract(shortcode_atts(array('id' => false, 'post_id' => '', 'label' => __('Search', 'formidable')), $atts));
    1464. 

  1464.         //if (!$id) return;
    1465. 

  1465.         if($post_id == ''){
    1466. 

  1466.             global $post;
    1467. 

  1467.             if($post)
    1468. 

  1468.                 $post_id = $post->ID;
    1469. 

  1469.         }
    1470. 

  1470.         
    1471. 

  1471.         if($post_id != '')
    1472. 

  1472.             $action_link = get_permalink($post_id);
    1473. 

  1473.         else
    1474. 

  1474.             $action_link = '';
    1475. 

  1475.         
    1476. 

  1476.         ob_start();
    1477. 

  1477.         include(FRMPRO_VIEWS_PATH .'/frmpro-entries/search.php');
    1478. 

  1478.         $contents = ob_get_contents();
    1479. 

  1479.         ob_end_clean();
    1480. 

  1480.         return $contents;
    1481. 

  1481.     }
    1482. 

  1482.     
    1483. 

  1483.     function entry_link_shortcode($atts){
    1484. 

  1484.         global $user_ID, $frm_entry, $frm_entry_meta, $post;
    1485. 

  1485.         extract(shortcode_atts(array('id' => false, 'field_key' => 'created_at', 'type' => 'list', 'logged_in' => true, 'edit' => true, 'class' => '', 'link_type' => 'page', 'blank_label' => '', 'param_name' => 'entry', 'param_value' => 'key', 'page_id' => false, 'show_delete' => false), $atts));
    1486. 

  1486.         
    1487. 

  1487.         if (!$id or ($logged_in && !$user_ID)) return;
    1488. 

  1488.         $id = (int)$id;
    1489. 

  1489.         if($show_delete === 1) $show_delete = __('Delete', 'formidable');
    1490. 

  1490.         $s = FrmAppHelper::get_param('frm_search', false);
    1491. 

  1491. 

  1492.         if($s)
    1493. 

  1493.             $entry_ids = FrmProEntriesHelper::get_search_ids($s, $id);
    1494. 

  1494.         else
    1495. 

  1495.             $entry_ids = $frm_entry_meta->getEntryIds("fi.form_id='$id'");
    1496. 

  1496.         
    1497. 

  1497.         if ($entry_ids){
    1498. 

  1498.             $id_list = implode(',', $entry_ids);
    1499. 

  1499.             $order = ($type == 'collapse') ? ' ORDER BY it.created_at DESC' : '';
    1500. 

  1500.             
    1501. 

  1501.             $where = "it.id in ($id_list)";
    1502. 

  1502.             if ($logged_in)
    1503. 

  1503.                 $where .= " and it.form_id='". $id ."' and it.user_id='". (int)$user_ID ."'";
    1504. 

  1504.             
    1505. 

  1505.             $entries = $frm_entry->getAll($where, $order, '', true);
    1506. 

  1506.         }
    1507. 

  1507. 

  1508.         if (!empty($entries)){
    1509. 

  1509.             if ($type == 'list'){
    1510. 

  1510.                 $content = "<ul class='frm_entry_ul $class'>\n";
    1511. 

  1511.             }else if($type == 'collapse'){
    1512. 

  1512.                 $content = '<div class="frm_collapse">';
    1513. 

  1513.                 $year = $month = '';
    1514. 

  1514.                 $prev_year = $prev_month = false;
    1515. 

  1515.             }else{
    1516. 

  1516.                 $content = "<select id='frm_select_form_$id' name='frm_select_form_$id' class='$class' onchange='location=this.options[this.selectedIndex].value;'>\n <option value='".get_permalink($post->ID)."'>$blank_label</option>\n";
    1517. 

  1517.             }
    1518. 

  1518.             
    1519. 

  1519.             global $frm_field;
    1520. 

  1520.             if($field_key != 'created_at')
    1521. 

  1521.                 $field = $frm_field->getOne($field_key);
    1522. 

  1522.             
    1523. 

  1523.             foreach ($entries as $entry){
    1524. 

  1524.                 $action = (isset($_GET) and isset($_GET['frm_action'])) ? 'frm_action' : 'action';
    1525. 

  1525.                 if(isset($_GET) and isset($_GET[$action]) and $_GET[$action] == 'destroy'){
    1526. 

  1526.                     if(isset($_GET['entry']) and ($_GET['entry'] == $entry->item_key or $_GET['entry'] == $entry->id))
    1527. 

  1527.                         continue;
    1528. 

  1528.                 }
    1529. 

  1529.                 
    1530. 

  1530.                 if($entry->post_id){
    1531. 

  1531.                     global $wpdb;
    1532. 

  1532.                     $post_status = $wpdb->get_var("SELECT post_status FROM $wpdb->posts WHERE ID=".$entry->post_id);
    1533. 

  1533.                     if($post_status != 'publish')
    1534. 

  1534.                         continue;
    1535. 

  1535.                 }
    1536. 

  1536.                 $value = '';
    1537. 

  1537.                 $meta = false;
    1538. 

  1538.                 if ($field_key && $field_key != 'created_at'){
    1539. 

  1539.                     if($entry->post_id and (($field and $field->field_options['post_field']) or $field->type == 'tag'))
    1540. 

  1540.                         $value = FrmProEntryMetaHelper::get_post_value($entry->post_id, $field->field_options['post_field'], $field->field_options['custom_field'], array('type' => $field->type, 'form_id' => $field->form_id, 'field' => $field));
    1541. 

  1541.                     else
    1542. 

  1542.                         $meta = isset($entry->metas[$field_key]) ? $entry->metas[$field_key] : '';
    1543. 

  1543.                 }else
    1544. 

  1544.                     $meta = reset($entry->metas);
    1545. 

  1545.                 
    1546. 

  1546.                 $value = ($field_key == 'created_at' or !isset($meta) or !$meta) ? $value : (is_object($meta) ? $meta->meta_value : $meta);
    1547. 

  1547.                 
    1548. 

  1548.                 if(empty($value))
    1549. 

  1549.                     $value = date_i18n(get_option('date_format'), strtotime($entry->created_at));
    1550. 

  1550.                 else
    1551. 

  1551.                     $value = FrmProEntryMetaHelper::display_value($value, $field, array('type' => $field->type, 'show_filename' => false));
    1552. 

  1552.                 
    1553. 

  1553.                 if($param_value == 'key')
    1554. 

  1554.                     $args = array($param_name => $entry->item_key);
    1555. 

  1555.                 else
    1556. 

  1556.                     $args = array($param_name => $entry->id);
    1557. 

  1557.                     
    1558. 

  1558.                 if ($edit)
    1559. 

  1559.                     $args['frm_action'] = 'edit';
    1560. 

  1560.                 
    1561. 

  1561.                 if ($link_type == 'scroll'){
    1562. 

  1562.                     $link = '#'.$entry->item_key;
    1563. 

  1563.                 }else if ($link_type == 'admin'){
    1564. 

  1564.                     $link = add_query_arg($args, $_SERVER['REQUEST_URI']);
    1565. 

  1565.                 }else{
    1566. 

  1566.                     if($page_id)
    1567. 

  1567.                         $permalink = get_permalink($page_id);
    1568. 

  1568.                     else
    1569. 

  1569.                         $permalink = get_permalink($post->ID);
    1570. 

  1570.                     $link = add_query_arg($args, $permalink);
    1571. 

  1571.                 }
    1572. 

  1572.                 
    1573. 

  1573.                 unset($args);
    1574. 

  1574.                 
    1575. 

  1575.                 $current = (isset($_GET['entry']) && $_GET['entry'] == $entry->item_key) ? true : false;
    1576. 

  1576.                 if ($type == 'list'){
    1577. 

  1577.                     $content .= "<li><a href='$link'>".stripslashes($value)."</a>";
    1578. 

  1578.                     if($show_delete and isset($permalink) and FrmProEntriesHelper::allow_delete($entry))
    1579. 

  1579.                         $content .= " <a href='". add_query_arg(array('frm_action' => 'destroy', 'entry' => $entry->id), $permalink) ."' class='frm_delete_list'>$show_delete</a>\n";
    1580. 

  1580.                     $content .= "</li>\n";
    1581. 

  1581.                 }else if($type == 'collapse'){
    1582. 

  1582.                     $new_year = strftime('%G', strtotime($entry->created_at));
    1583. 

  1583.                     $new_month = strftime('%B', strtotime($entry->created_at));
    1584. 

  1584.                     if ($new_year != $year){
    1585. 

  1585.                         if($prev_year){
    1586. 

  1586.                             if($prev_month) $content .= '</ul></div>';
    1587. 

  1587.                             $content .= '</div>';
    1588. 

  1588.                             $prev_month = false;
    1589. 

  1589.                         }
    1590. 

  1590.                         $style = ($prev_year) ? " style='display:none'" : '';
    1591. 

  1591.                         $triangle = ($prev_year) ? "e" : "s";
    1592. 

  1592.                         $content .= "\n<div class='frm_year_heading frm_year_heading_$id'>
    1593. 

  1593.                             <span class='ui-icon ui-icon-triangle-1-$triangle'></span>\n
    1594. 

  1594.                             <a>$new_year</a></div>\n
    1595. 

  1595.                             <div class='frm_toggle_container' $style>\n";
    1596. 

  1596.                         $prev_year = true;
    1597. 

  1597.                     }
    1598. 

  1598.                     if ($new_month != $month){
    1599. 

  1599.                         if($prev_month)
    1600. 

  1600.                             $content .= '</ul></div>';
    1601. 

  1601.                         $style = ($prev_month) ? " style='display:none'" : '';
    1602. 

  1602.                         $triangle = ($prev_month) ? "e" : "s";
    1603. 

  1603.                         $content .= "<div class='frm_month_heading frm_month_heading_$id'>
    1604. 

  1604.                             <span class='ui-icon ui-icon-triangle-1-$triangle'></span>\n
    1605. 

  1605.                             <a>$new_month</a>\n</div>\n
    1606. 

  1606.                             <div class='frm_toggle_container frm_month_listing' $style><ul>\n";
    1607. 

  1607.                         $prev_month = true;
    1608. 

  1608.                     }
    1609. 

  1609.                     $content .= "<li><a href='$link'>".stripslashes($value)."</a></li>";
    1610. 

  1610.                     $year = $new_year;
    1611. 

  1611.                     $month = $new_month;
    1612. 

  1612.                 }else{
    1613. 

  1613.                     $selected = $current ? ' selected="selected"' : '';
    1614. 

  1614.                     $content .= "<option value='$link'$selected>" .stripslashes($value) . "</option>\n";
    1615. 

  1615.                 }
    1616. 

  1616.             }
    1617. 

  1617. 

  1618.             if ($type == 'list')
    1619. 

  1619.                 $content .= "</ul>\n";
    1620. 

  1620.             else if($type == 'collapse'){
    1621. 

  1621.                 if($prev_year) $content .= '</div>';
    1622. 

  1622.                 if($prev_month) $content .= '</ul></div>';
    1623. 

  1623.                 $content .= '</div>';
    1624. 

  1624.                 $content .= "<script type='text/javascript'>jQuery(document).ready(function($){ $('.frm_month_heading_". $id . ", .frm_year_heading_". $id ."').toggle(function(){ $(this).children('.ui-icon-triangle-1-e').addClass('ui-icon-triangle-1-s'); $(this).children('.ui-icon-triangle-1-s').removeClass('ui-icon-triangle-1-e'); $(this).next('.frm_toggle_container').fadeIn('slow');},function(){ $(this).children('.ui-icon-triangle-1-s').addClass('ui-icon-triangle-1-e'); $(this).children('.ui-icon-triangle-1-e').removeClass('ui-icon-triangle-1-s'); $(this).next('.frm_toggle_container').hide();});})</script>\n";
    1625. 

  1625.             }else{
    1626. 

  1626.                 $content .= "</select>\n";
    1627. 

  1627.                 if($show_delete and isset($_GET) and isset($_GET['entry']) and $_GET['entry'])
    1628. 

  1628.                     $content .= " <a href='".add_query_arg(array('frm_action' => 'destroy', 'entry' => $_GET['entry']), $permalink) ."' class='frm_delete_list'>$show_delete</a>\n";
    1629. 

  1629.             }
    1630. 

  1630.             
    1631. 

  1631.         }else
    1632. 

  1632.             $content = '';
    1633. 

  1633.         
    1634. 

  1634.         return $content;
    1635. 

  1635.     }
    1636. 

  1636.     
    1637. 

  1637.     function entry_edit_link($atts){
    1638. 

  1638.         global $frm_editing_entry, $post, $frm_forms_loaded;
    1639. 

  1639.         extract(shortcode_atts(array(
    1640. 

  1640.             'id' => $frm_editing_entry, 'label' => __('Edit', 'formidable'), 'cancel' => __('Cancel', 'formidable'), 
    1641. 

  1641.             'class' => '', 'page_id' => (($post) ? $post->ID : 0), 'html_id' => false,
    1642. 

  1642.             'prefix' => '', 'form_id' => false
    1643. 

  1643.         ), $atts));
    1644. 

  1644. 

  1645.         $link = '';
    1646. 

  1646.         $entry_id = ($id and is_numeric($id)) ? $id : FrmAppHelper::get_param('entry', false);
    1647. 

  1647.             
    1648. 

  1648.         if($entry_id and !empty($entry_id)){
    1649. 

  1649.             if(!$form_id){
    1650. 

  1650.                 global $frmdb;
    1651. 

  1651.                 $form_id = (int)$frmdb->get_var($frmdb->entries, array('id' => $entry_id), 'form_id');
    1652. 

  1652.             }
    1653. 

  1653.             
    1654. 

  1654.             //if user is not allowed to edit, then don't show the link
    1655. 

  1655.             if(!FrmProEntry::user_can_edit($entry_id, $form_id))
    1656. 

  1656.                 return $link;
    1657. 

  1657.                 
    1658. 

  1658.             if(empty($prefix)){
    1659. 

  1659.                $link = add_query_arg(array('frm_action' => 'edit', 'entry' => $entry_id), get_permalink($page_id));
    1660. 

  1660.                
    1661. 

  1661.                if($label)
    1662. 

  1662.                    $link = '<a href="'. $link .'" class="'. $class.'">'. $label .'</a>';
    1663. 

  1663.                    
    1664. 

  1664.                return $link;
    1665. 

  1665.             }
    1666. 

  1666.             
    1667. 

  1667.             $action = (isset($_POST) && isset($_POST['frm_action'])) ? 'frm_action' : 'action';
    1668. 

  1668.             if (isset($_POST) and isset($_POST[$action]) and ($_POST[$action] =='update') and isset($_POST['form_id']) and ($_POST['form_id'] == $form_id) and isset($_POST['id']) and ($_POST['id'] == $entry_id)){
    1669. 

  1669.                 global $frm_created_entry;
    1670. 

  1670.                 $errors = $frm_created_entry[$form_id]['errors'];
    1671. 

  1671.                 
    1672. 

  1672.                 if($errors)
    1673. 

  1673.                     return FrmAppController::get_form_shortcode(array('id' => $form_id, 'entry_id' => $entry_id));
    1674. 

  1674.                 
    1675. 

  1675.                 $link .= "<script type='text/javascript'>window.onload= function(){var frm_pos=jQuery('#". $prefix . $entry_id ."').offset();window.scrollTo(frm_pos.left,frm_pos.top);}</script>";
    1676. 

  1676.             }
    1677. 

  1677. 

  1678.                 
    1679. 

  1679.             if(!$html_id)
    1680. 

  1680.                 $html_id = "frm_edit_{$entry_id}";
    1681. 

  1681.               
    1682. 

  1682.             $frm_forms_loaded[] = true;  
    1683. 

  1683.             $link .= "<a href='javascript:frmEditEntry($entry_id,\"". FRM_SCRIPT_URL."\",\"$prefix\",$page_id,$form_id,\"$cancel\",\"$class\")' class='frm_edit_link $class' id='$html_id'>$label</a>\n";
    1684. 

  1684.         }
    1685. 

  1685. 

  1686.         return $link;
    1687. 

  1687.     }
    1688. 

  1688.     
    1689. 

  1689.     function entry_update_field($atts){
    1690. 

  1690.         global $frm_editing_entry, $post, $frmdb;
    1691. 

  1691.         
    1692. 

  1692.         extract(shortcode_atts(array(
    1693. 

  1693.             'id' => $frm_editing_entry, 'field_id' => false, 'form_id' => false, 
    1694. 

  1694.             'label' => 'Update', 'class' => '', 'value' => '', 'message' => ''
    1695. 

  1695.         ), $atts));
    1696. 

  1696.         
    1697. 

  1697.         $link = '';
    1698. 

  1698.         $entry_id = (int)($id and is_numeric($id)) ? $id : FrmAppHelper::get_param('entry', false);
    1699. 

  1699.         
    1700. 

  1700.         if(!$entry_id or empty($entry_id))
    1701. 

  1701.             return $link;
    1702. 

  1702.             
    1703. 

  1703.         if(!$form_id)
    1704. 

  1704.             $form_id = (int)$frmdb->get_var($frmdb->entries, array('id' => $entry_id), 'form_id');
    1705. 

  1705.         
    1706. 

  1706.         if(!FrmProEntry::user_can_edit($entry_id, $form_id))
    1707. 

  1707.             return $link;
    1708. 

  1708.         
    1709. 

  1709.         if(!is_numeric($field_id))
    1710. 

  1710.             $field_id = $frmdb->get_var($frmdb->fields, array('field_key' => $field_id));
    1711. 

  1711.         
    1712. 

  1712.         if(!$field_id)
    1713. 

  1713.             return 'no field'. $link;
    1714. 

  1714.         
    1715. 

  1715.         $link = '<a href="#" onclick="frmUpdateField('. $entry_id .','. $field_id .',\''. $value .'\',\''. $message .'\',\''. FRM_SCRIPT_URL.'\');return false;" id="frm_update_field_'. $entry_id .'_'. $field_id .'" class="frm_update_field_link '. $class .'">'. $label .'</a>';
    1716. 

  1716.         
    1717. 

  1717.         return $link;
    1718. 

  1718.     }
    1719. 

  1719.     
    1720. 

  1720.     function entry_delete_link($atts){
    1721. 

  1721.         global $frm_editing_entry, $post, $frm_forms_loaded;
    1722. 

  1722.         extract(shortcode_atts(array(
    1723. 

  1723.             'id' => $frm_editing_entry, 'label' => 'Delete', 
    1724. 

  1724.             'confirm' => __('Are you sure you want to delete that entry?', 'formidable'), 
    1725. 

  1725.             'class' => '', 'page_id' => (($post) ? $post->ID : 0), 'html_id' => false, 'prefix' => ''
    1726. 

  1726.         ), $atts));
    1727. 

  1727.         
    1728. 

  1728.         $frm_forms_loaded[] = true;
    1729. 

  1729.             
    1730. 

  1730.         $link = '';
    1731. 

  1731.         $entry_id = ($id and is_numeric($id)) ? $id : (is_admin() ? FrmAppHelper::get_param('id', false) : FrmAppHelper::get_param('entry', false));
    1732. 

  1732. 

  1733.         if($entry_id and !empty($entry_id)){
    1734. 

  1734.             if(empty($prefix)){
    1735. 

  1735.                 $action = FrmAppHelper::get_param('frm_action');
    1736. 

  1736.                 if($action == 'destroy'){
    1737. 

  1737.                     $entry_key = FrmAppHelper::get_param('entry');
    1738. 

  1738.                     if(is_numeric($entry_key) and $entry_key == $entry_id){
    1739. 

  1739.                         $link = FrmProEntriesController::ajax_destroy(false, false, false);
    1740. 

  1740.                         if(!empty($link)){
    1741. 

  1741.                             $new_link = '<div class="frm_message">'. $link .'</div>';
    1742. 

  1742.                             if($link == __('Your entry was successfully deleted', 'formidable'))    
    1743. 

  1743.                                 return $new_link;
    1744. 

  1744.                             else
    1745. 

  1745.                                 $link = $new_link;
    1746. 

  1746.                                 
    1747. 

  1747.                             unset($new_link);
    1748. 

  1748.                         }
    1749. 

  1749.                     }
    1750. 

  1750.                 }
    1751. 

  1751.                     
    1752. 

  1752.                 $link .= "<a href='". add_query_arg(array('frm_action' => 'destroy', 'entry' => $entry_id), get_permalink($page_id)) ."' class='$class' onclick='return confirm(\"". $confirm ."\")'>$label</a>\n";
    1753. 

  1753.             }else{
    1754. 

  1754.                 if(!$html_id)
    1755. 

  1755.                     $html_id = "frm_delete_{$entry_id}";
    1756. 

  1756.               
    1757. 

  1757.                 $link = "<a href='javascript:frmDeleteEntry($entry_id,\"". FRM_SCRIPT_URL."\",\"$prefix\")' class='frm_delete_link $class' id='$html_id' onclick='return confirm(\"". $confirm ."\")'>$label</a>\n";
    1758. 

  1758.             }
    1759. 

  1759.         }
    1760. 

  1760.             
    1761. 

  1761.         return $link;
    1762. 

  1762.     }
    1763. 

  1763.     
    1764. 

  1764.     function get_field_value_shortcode($atts){
    1765. 

  1765.         extract(shortcode_atts(array('entry_id' => false, 'field_id' => false, 'user_id' => false, 'ip' => false), $atts));
    1766. 

  1766.         if(!$field_id  or (!$entry_id and !$user_id and !$ip))
    1767. 

  1767.             return __('You are missing options in your shortcode. field_id and either user_id, entry_id, or ip are required.', 'formidable');
    1768. 

  1768.             
    1769. 

  1769.         global $frm_field, $wpdb, $frmdb;
    1770. 

  1770.         
    1771. 

  1771.         $field = $frm_field->getOne($field_id);
    1772. 

  1772.         
    1773. 

  1773.         $query = "SELECT post_id, id FROM $frmdb->entries WHERE form_id=$field->form_id and ";
    1774. 

  1774.         if($user_id)
    1775. 

  1775.             $query .= "user_id=". (int)FrmProAppHelper::get_user_id_param($user_id);
    1776. 

  1776.         if($entry_id)
    1777. 

  1777.             $query .= "id=". (int)$entry_id;
    1778. 

  1778.         if($ip)
    1779. 

  1779.             $query .= "ip='". (($ip == true) ? $_SERVER['REMOTE_ADDR'] : $ip) ."'";
    1780. 

  1780.         $query .= " ORDER BY created_at DESC LIMIT 1";
    1781. 

  1781.         $entry = $wpdb->get_row($query);
    1782. 

  1782.         if(!$entry)
    1783. 

  1783.             return;
    1784. 

  1784.             
    1785. 

  1785.         $atts = array();
    1786. 

  1786.         $value = FrmProEntryMetaHelper::get_post_or_meta_value($entry, $field, $atts);
    1787. 

  1787.         
    1788. 

  1788.         $value = FrmProEntryMetaHelper::display_value($value, $field, 
    1789. 

  1789.             array('type' => $field->type, 'post_id' => $entry->post_id, 'entry_id' => $entry->id)
    1790. 

  1790.         );
    1791. 

  1791.         
    1792. 

  1792.         return $value;
    1793. 

  1793.     }
    1794. 

  1794.     
    1795. 

  1795.     function show_entry_shortcode($atts){
    1796. 

  1796.         extract(shortcode_atts(array(
    1797. 

  1797.             'id' => false, 'entry' => false, 'fields' => false, 'plain_text' => false,
    1798. 

  1798.             'user_info' => false, 'include_blank' => false
    1799. 

  1799.         ), $atts));
    1800. 

  1800.         
    1801. 

  1801.         global $frmpro_settings, $frm_entry;
    1802. 

  1802.         
    1803. 

  1803.         if(!$entry or !is_object($entry)){
    1804. 

  1804.             if(!$id)
    1805. 

  1805.                 return '';
    1806. 

  1806.             
    1807. 

  1807.             $entry = $frm_entry->getOne($id, true);
    1808. 

  1808.         }
    1809. 

  1809.         
    1810. 

  1810.         if(!$fields or !is_array($fields)){
    1811. 

  1811.             global $frm_field;
    1812. 

  1812.             $fields = $frm_field->getAll(array('fi.form_id' => $entry->form_id), 'field_order');
    1813. 

  1813.         }
    1814. 

  1814.         
    1815. 

  1815.         $content = '';
    1816. 

  1816.         $odd = true;
    1817. 

  1817.             
    1818. 

  1818.         if(!$plain_text){
    1819. 

  1819.             $content .= "<table cellspacing='0' style='font-size:12px;line-height:135%; border-bottom:{$frmpro_settings->field_border_width} solid #{$frmpro_settings->border_color};'><tbody>\r\n";
    1820. 

  1820.             $bg_color = " style='background-color:#{$frmpro_settings->bg_color};'";
    1821. 

  1821.             $bg_color_alt = " style='background-color:#{$frmpro_settings->bg_color_active};'";
    1822. 

  1822.         }
    1823. 

  1823.         
    1824. 

  1824.         foreach($fields as $f){
    1825. 

  1825.             if(!isset($entry->metas[$f->id])){
    1826. 

  1826.                 if(!$include_blank)
    1827. 

  1827.                     continue;
    1828. 

  1828.                     
    1829. 

  1829.                 $entry->metas[$f->id] = '';
    1830. 

  1830.             }
    1831. 

  1831.             
    1832. 

  1832.             $prev_val = maybe_unserialize($entry->metas[$f->id]);
    1833. 

  1833.             $meta = array('item_id' => $entry->id, 'field_id' => $f->id, 'meta_value' => $prev_val, 'field_type' => $f->type);
    1834. 

  1834.             $val = apply_filters('frm_email_value', $prev_val, (object)$meta, $entry);
    1835. 

  1835. 

  1836.             if($f->type == 'textarea' and !$plain_text)
    1837. 

  1837.                 $val = str_replace(array("\r\n", "\r", "\n"), ' <br/>', $val);
    1838. 

  1838.             
    1839. 

  1839.             if (is_array($val))
    1840. 

  1840.                 $val = implode(', ', $val);
    1841. 

  1841.                 
    1842. 

  1842.             if($plain_text){
    1843. 

  1843.                 $content .= $f->name . ': ' . $val . "\r\n\r\n";
    1844. 

  1844.             }else{
    1845. 

  1845.                 $row_style = "valign='top' style='text-align:left;color:#{$frmpro_settings->text_color};padding:7px 9px;border-top:{$frmpro_settings->field_border_width} solid #{$frmpro_settings->border_color}'";
    1846. 

  1846.                 $content .= "<tr".(($odd) ? $bg_color : $bg_color_alt)."><th $row_style>$f->name</th><td $row_style>$val</td></tr>\r\n";
    1847. 

  1847.                 $odd = ($odd) ? false : true;
    1848. 

  1848.             }
    1849. 

  1849.             
    1850. 

  1850.             unset($f);
    1851. 

  1851.         }
    1852. 

  1852.         
    1853. 

  1853.         if($user_info){
    1854. 

  1854.             $data = maybe_unserialize($entry->description);
    1855. 

  1855.             if($plain_text){
    1856. 

  1856.                 $content .= "\r\n\r\n" . __('User Information', 'formidable') ."\r\n";
    1857. 

  1857.                 $content .= __('IP Address', 'formidable') . ": ". $entry->ip ."\r\n";
    1858. 

  1858.                 $content .= __('User-Agent (Browser/OS)', 'formidable') . ": ". $data['browser']."\r\n";
    1859. 

  1859.                 $content .= __('Referrer', 'formidable') . ": ". $data['referrer']."\r\n";
    1860. 

  1860.             }else{
    1861. 

  1861.                 $content .= "<tr".(($odd) ? $bg_color : $bg_color_alt)."><th $row_style>". __('IP Address', 'formidable') . "</th><td $row_style>". $entry->ip ."</td></tr>\r\n";
    1862. 

  1862.                 $odd = ($odd) ? false : true;
    1863. 

  1863.                 $content .= "<tr".(($odd) ? $bg_color : $bg_color_alt)."><th $row_style>".__('User-Agent (Browser/OS)', 'formidable') . "</th><td $row_style>". $data['browser']."</td></tr>\r\n";
    1864. 

  1864.                 $odd = ($odd) ? false : true;
    1865. 

  1865.                 $content .= "<tr".(($odd) ? $bg_color : $bg_color_alt)."><th $row_style>".__('Referrer', 'formidable') . "</th><td $row_style>". str_replace("\r\n", '<br/>', $data['referrer']) ."</td></tr>\r\n";
    1866. 

  1866.             }
    1867. 

  1867.         }
    1868. 

  1868. 

  1869.         if(!$plain_text)
    1870. 

  1870.             $content .= "</tbody></table>";
    1871. 

  1871.         
    1872. 

  1872.         return $content;
    1873. 

  1873.     }
    1874. 

  1874.     
    1875. 

  1875.     /* AJAX */
    1876. 

  1876.     function set_cookie($entry_id, $form_id){
    1877. 

  1877.         global $frm_form;
    1878. 

  1878.         $form = $frm_form->getOne($form_id);
    1879. 

  1879.         $form->options = maybe_unserialize($form->options);
    1880. 

  1880.         $expiration = (isset($form->options['cookie_expiration'])) ? ((float)$form->options['cookie_expiration'] *60*60) : 30000000; 
    1881. 

  1881.         $expiration = apply_filters('frm_cookie_expiration', $expiration, $form_id, $entry_id);
    1882. 

  1882.         setcookie('frm_form'.$form_id.'_' . COOKIEHASH, current_time('mysql', 1), time() + $expiration, COOKIEPATH, COOKIE_DOMAIN);
    1883. 

  1883.     }
    1884. 

  1884.     
    1885. 

  1885.     function ajax_create(){
    1886. 

  1886.         global $frm_entry;
    1887. 

  1887.         
    1888. 

  1888.         $errors = $frm_entry->validate($_POST, array('file','rte','captcha'));
    1889. 

  1889.         if(empty($errors)){
    1890. 

  1890.             echo false;
    1891. 

  1891.         }else{
    1892. 

  1892.             $errors = str_replace('"', '&quot;', stripslashes_deep($errors));
    1893. 

  1893.             $obj = array();
    1894. 

  1894.             foreach($errors as $field => $error){
    1895. 

  1895.                 $field_id = str_replace('field', '', $field);
    1896. 

  1896.                 $obj[$field_id] = $error;
    1897. 

  1897.             }
    1898. 

  1898.             echo json_encode($obj);
    1899. 

  1899.         }
    1900. 

  1900.         
    1901. 

  1901.         die();
    1902. 

  1902.     }
    1903. 

  1903.     
    1904. 

  1904.     function ajax_update(){
    1905. 

  1905.         return $this->ajax_create();
    1906. 

  1906.     }
    1907. 

  1907.     
    1908. 

  1908.     function ajax_destroy($form_id=false, $ajax=true, $echo=true){
    1909. 

  1909.         global $user_ID, $frmdb, $frm_entry, $frm_deleted_entries;
    1910. 

  1910.         
    1911. 

  1911.         $entry_key = FrmAppHelper::get_param('entry');
    1912. 

  1912.         if(!$form_id)
    1913. 

  1913.             $form_id = FrmAppHelper::get_param('form_id');
    1914. 

  1914.         
    1915. 

  1915.         if(!$entry_key)
    1916. 

  1916.             return;
    1917. 

  1917.             
    1918. 

  1918.         if(is_array($frm_deleted_entries) and in_array($entry_key, $frm_deleted_entries))
    1919. 

  1919.             return;
    1920. 

  1920.             
    1921. 

  1921.         $where = array();
    1922. 

  1922.         if(!current_user_can('frm_delete_entries'))
    1923. 

  1923.             $where['user_id'] = $user_ID;
    1924. 

  1924.             
    1925. 

  1925.         if(is_numeric($entry_key))
    1926. 

  1926.             $where['id'] = $entry_key;
    1927. 

  1927.         else
    1928. 

  1928.             $where['item_key'] = $entry_key;
    1929. 

  1929.         
    1930. 

  1930.         $entry = $frmdb->get_one_record( $frmdb->entries, $where, 'id, form_id' );
    1931. 

  1931. 

  1932.         if($form_id and $entry and $entry->form_id != (int)$form_id)
    1933. 

  1933.             return;
    1934. 

  1934.             
    1935. 

  1935.         $entry_id = $entry->id;
    1936. 

  1936.         
    1937. 

  1937.         $entry_id = apply_filters('frm_allow_delete', $entry_id, $entry_key, $form_id);
    1938. 

  1938. 

  1939.         if(!$entry_id){
    1940. 

  1940.             $message = __('There was an error deleting that entry', 'formidable');
    1941. 

  1941.             if($echo)
    1942. 

  1942.                 echo '<div class="frm_message">'. $message .'</div>';
    1943. 

  1943.         }else{
    1944. 

  1944.             $frm_entry->destroy( $entry_id );
    1945. 

  1945.             if(!$frm_deleted_entries)
    1946. 

  1946.                 $frm_deleted_entries = array();
    1947. 

  1947.             $frm_deleted_entries[] = $entry_id;
    1948. 

  1948.             
    1949. 

  1949.             if($ajax){
    1950. 

  1950.                 if($echo)
    1951. 

  1951.                     echo $message = 'success';
    1952. 

  1952.             }else{
    1953. 

  1953.                 $message = __('Your entry was successfully deleted', 'formidable');
    1954. 

  1954.                 
    1955. 

  1955.                 if($echo)
    1956. 

  1956.                     echo '<div class="frm_message">'. $message .'</div>';
    1957. 

  1957.             }
    1958. 

  1958.         }
    1959. 

  1959.         
    1960. 

  1960.         return $message;
    1961. 

  1961.     }
    1962. 

  1962.     
    1963. 

  1963.     function edit_entry_ajax($id, $entry_id=false, $post_id=false){
    1964. 

  1964.         global $frm_ajax_edit;
    1965. 

  1965.         $frm_ajax_edit = ($entry_id) ? $entry_id : true;
    1966. 

  1966. 

  1967.         if($post_id and is_numeric($post_id)){
    1968. 

  1968.             global $post;
    1969. 

  1969.             if(!$post)
    1970. 

  1970.                 $post = get_post($post_id);
    1971. 

  1971.         }
    1972. 

  1972. 

  1973.         
    1974. 

  1974.         global $wp_scripts;
    1975. 

  1975.         $wp_scripts->do_items( array('formidable') );
    1976. 

  1976.         echo "<script type='text/javascript'>
    1977. 

  1977. //<![CDATA[
    1978. 

  1978. jQuery(document).ready(function($){
    1979. 

  1979. $('#frm_form_". $id ."_container .frm-show-form').submit(function(e){e.preventDefault();window.frmGetFormErrors(this,'". FRM_SCRIPT_URL ."');});
    1980. 

  1980. });
    1981. 

  1981. //]]>
    1982. 

  1982. </script>";
    1983. 

  1983.         echo FrmAppController::get_form_shortcode(compact('id', 'entry_id'));
    1984. 

  1984. 

  1985.         $frm_ajax_edit = false;
    1986. 

  1986.         //if(!isset($_POST) or (!isset($_POST['action']) and !isset($_POST['frm_action])))
    1987. 

  1987.         //    echo FrmProEntriesController::footer_js();
    1988. 

  1988.         
    1989. 

  1989.         die();
    1990. 

  1990.     }
    1991. 

  1991.     
    1992. 

  1992.     function update_field_ajax($entry_id, $field_id, $value){
    1993. 

  1993.         global $frmdb, $wpdb, $frm_field;
    1994. 

  1994.         
    1995. 

  1995.         $entry_id = (int)$entry_id;
    1996. 

  1996.         
    1997. 

  1997.         if(!$entry_id)
    1998. 

  1998.             return false;
    1999. 

  1999.            
    2000. 

  2000.         $where = '';
    2001. 

  2001.         if(is_numeric($field_id))
    2002. 

  2002.             $where .= "fi.id=$field_id";
    2003. 

  2003.         else
    2004. 

  2004.             $where .= "field_key='$field_id'";
    2005. 

  2005.             
    2006. 

  2006.         $field = $frm_field->getAll($where, '', ' LIMIT 1');
    2007. 

  2007.     
    2008. 

  2008.         if(!$field or !FrmProEntry::user_can_edit($entry_id, $field->form_id))
    2009. 

  2009.             return false;
    2010. 

  2010.         
    2011. 

  2011.         $post_id = false;
    2012. 

  2012.         
    2013. 

  2013.         $field->field_options = maybe_unserialize($field->field_options);
    2014. 

  2014.         if(isset($field->field_options['post_field']) and !empty($field->field_options['post_field']))
    2015. 

  2015.             $post_id = $frmdb->get_var($frmdb->entries, array('id' => $entry_id), 'post_id');
    2016. 

  2016.             
    2017. 

  2017.         if(!$post_id){
    2018. 

  2018.             $updated = $wpdb->update( $frmdb->entry_metas, 
    2019. 

  2019.                 array('meta_value' => $value), 
    2020. 

  2020.                 array('item_id' => $entry_id, 'field_id' => $field_id) 
    2021. 

  2021.             );
    2022. 

  2022. 

  2023.             if(!$updated){
    2024. 

  2024.                 $wpdb->query($wpdb->prepare("DELETE FROM $frmdb->entry_metas WHERE item_id = %d and field_id = %d", $entry_id, $field_id));
    2025. 

  2025.                 $updated = FrmEntryMeta::add_entry_meta($entry_id, $field_id, '', $value);
    2026. 

  2026.             }
    2027. 

  2027.             wp_cache_delete( $entry_id, 'frm_entry');
    2028. 

  2028.         }else{
    2029. 

  2029.             switch($field->field_options['post_field']){
    2030. 

  2030.                 case 'post_custom':
    2031. 

  2031.                     $updated = update_post_meta($post_id, $field->field_options['post_custom'], maybe_serialize($value));
    2032. 

  2032.                 break;
    2033. 

  2033.                 case 'post_category':
    2034. 

  2034.                     $taxonomy = (isset($field->field_options['taxonomy']) and !empty($field->field_options['taxonomy'])) ? $field->field_options['taxonomy'] : 'category';
    2035. 

  2035.                     $updated = wp_set_post_terms( $post_id, $value, $taxonomy );
    2036. 

  2036.                 break;
    2037. 

  2037.                 default:
    2038. 

  2038.                     $post = get_post($post_id, ARRAY_A);
    2039. 

  2039.                     $post[$field->field_options['post_field']] = maybe_serialize($value);
    2040. 

  2040.                     $updated = wp_insert_post( $post );
    2041. 

  2041.             }
    2042. 

  2042.         }
    2043. 

  2043.         do_action('frm_after_update_field', compact('entry_id', 'field_id', 'value'));
    2044. 

  2044.         return $updated;
    2045. 

  2045.     }
    2046. 

  2046.     
    2047. 

  2047.     function send_email($entry_id, $form_id, $type){
    2048. 

  2048.         if(current_user_can('frm_view_forms') or current_user_can('frm_edit_forms') or current_user_can('frm_edit_entries')){
    2049. 

  2049.             global $frmpro_notification;
    2050. 

  2050.             if($type=='autoresponder')
    2051. 

  2051.                 $sent_to = $frmpro_notification->autoresponder($entry_id, $form_id);
    2052. 

  2052.             else
    2053. 

  2053.                 $sent_to = $frmpro_notification->entry_created($entry_id, $form_id);
    2054. 

  2054.             
    2055. 

  2055.             if(is_array($sent_to))
    2056. 

  2056.                 echo implode(', ', $sent_to);
    2057. 

  2057.             else
    2058. 

  2058.                 echo $sent_to;
    2059. 

  2059.         }else{
    2060. 

  2060.             _e('No one! You do not have permission', 'formidable');
    2061. 

  2061.         }
    2062. 

  2062.     }
    2063. 

  2063.     
    2064. 

  2064. }
    2065. 

  2065. 

  2066. ?>
    2067.