function cp_form_layouts() { global $options_new_form, $wpdb, $current_user; $current_user = wp_get_current_user(); // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['action'])) { $theswitch = $_GET['action']; } else { $theswitch = ''; } ?> <script type="text/javascript"> /* <![CDATA[ */ /* initialize the form validation */ jQuery(document).ready(function($) { $("#mainform").validate({errorClass: "invalid"}); }); /* ]]> */ </script> <?php switch ($theswitch) { case 'addform': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('New Form Layout', APP_TD); ?> </h2> <?php cp_admin_info_box(); ?> <?php // check and make sure the form was submitted and the hidden fcheck id matches the cookie fcheck id if (isset($_POST['submitted'])) { if (!isset($_POST['post_category'])) { wp_die('<p style="color:red;">' . __("Error: Please select at least one category. <a href='#' onclick='history.go(-1);return false;'>Go back</a>", APP_TD) . '</p>'); } $data = array('form_name' => appthemes_clean(cp_make_custom_name($_POST['form_label'])), 'form_label' => appthemes_clean($_POST['form_label']), 'form_desc' => appthemes_clean($_POST['form_desc']), 'form_cats' => serialize($_POST['post_category']), 'form_status' => appthemes_clean($_POST['form_status']), 'form_owner' => appthemes_clean($_POST['form_owner']), 'form_created' => gmdate('Y-m-d H:i:s')); $insert = $wpdb->insert($wpdb->cp_ad_forms, $data); if ($insert) { ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Creating your form.....', APP_TD); ?> <br /><br /><img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php } // end $insert } else { ?> <form method="post" id="mainform" action=""> <?php echo cp_admin_fields($options_new_form); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Create New Form', APP_TD); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', APP_TD); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } // end isset $_POST ?> </div><!-- end wrap --> <?php break; case 'editform': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('Edit Form Properties', APP_TD); ?> </h2> <?php if (isset($_POST['submitted']) && $_POST['submitted'] == 'yes') { if (!isset($_POST['post_category'])) { wp_die('<p style="color:red;">' . __("Error: Please select at least one category. <a href='#' onclick='history.go(-1);return false;'>Go back</a>", APP_TD) . '</p>'); } $data = array('form_label' => appthemes_clean($_POST['form_label']), 'form_desc' => appthemes_clean($_POST['form_desc']), 'form_cats' => serialize($_POST['post_category']), 'form_status' => appthemes_clean($_POST['form_status']), 'form_owner' => appthemes_clean($_POST['form_owner']), 'form_modified' => gmdate('Y-m-d H:i:s', time() + get_option('gmt_offset') * 3600)); $wpdb->update($wpdb->cp_ad_forms, $data, array('id' => $_GET['id'])); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Saving your changes.....', APP_TD); ?> <br /><br /><img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php } else { ?> <form method="post" id="mainform" action=""> <?php echo cp_admin_db_fields($options_new_form, 'cp_ad_forms', 'id'); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Save changes', APP_TD); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', APP_TD); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } // end isset $_POST ?> </div><!-- end wrap --> <?php break; /** * Form Builder Page * Where fields are added to form layouts */ /** * Form Builder Page * Where fields are added to form layouts */ case 'formbuilder': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('Edit Form Layout', APP_TD); ?> </h2> <?php cp_admin_info_box(); ?> <?php // add fields to page layout on left side if (isset($_POST['field_id'])) { // take selected checkbox array and loop through ids foreach ($_POST['field_id'] as $value) { $data = array('form_id' => appthemes_clean($_POST['form_id']), 'field_id' => appthemes_clean($value)); $insert = $wpdb->insert($wpdb->cp_ad_meta, $data); } // end foreach } // end $_POST // update form layout positions and required fields on left side. if (isset($_POST['formlayout'])) { // loop through the post array and update the required checkbox and field position foreach ($_POST as $key => $value) { // since there's some $_POST values we don't want to process, only give us the // numeric ones which means it contains a meta_id and we want to update it if (is_numeric($key)) { // quick hack to prevent php "notice: undefined index:" msg when php strict warnings is on if (!isset($value['field_req'])) { $value['field_req'] = ''; } if (!isset($value['field_search'])) { $value['field_search'] = ''; } $data = array('field_req' => appthemes_clean($value['field_req']), 'field_search' => appthemes_clean($value['field_search'])); $wpdb->update($wpdb->cp_ad_meta, $data, array('meta_id' => $key)); } // end if_numeric } // end for each echo '<p class="info">' . __('Your changes have been saved.', APP_TD) . '</p>'; } // end isset $_POST // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['del_id'])) { $theswitch = $_GET['del_id']; } else { $theswitch = ''; } // Remove items from form layout if ($theswitch) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->cp_ad_meta} WHERE meta_id = %s", $_GET['del_id'])); } //update the forms modified date $data = array('form_modified' => gmdate('Y-m-d H:i:s', time() + get_option('gmt_offset') * 3600)); $wpdb->update($wpdb->cp_ad_forms, $data, array('id' => $_GET['id'])); ?> <table> <tr style="vertical-align:top;"> <td style="width:800px;padding:0 20px 0 0;"> <h3><?php _e('Form Name', APP_TD); ?> - <?php echo ucfirst(urldecode($_GET['title'])); ?> <span id="loading"></span></h3> <form method="post" id="mainform" action=""> <table class="widefat"> <thead> <tr> <th scope="col" colspan="2"><?php _e('Form Preview', APP_TD); ?> </th> <th scope="col" style="width:75px;text-align:center;" title="<?php _e('Show field in the category refine search sidebar', APP_TD); ?> "><?php _e('Advanced Search', APP_TD); ?> </th> <th scope="col" style="width:75px;text-align:center;"><?php _e('Required', APP_TD); ?> </th> <th scope="col" style="width:75px;text-align:center;"><?php _e('Remove', APP_TD); ?> </th> </tr> </thead> <tbody class="sortable"> <?php // If this is the first time this form is being customized then auto // create the core fields and put in cp_meta db table echo cp_add_core_fields($_GET['id']); // Then go back and select all the fields assigned to this // table which now includes the added core fields. $sql = $wpdb->prepare("SELECT f.field_label, f.field_name, f.field_type, f.field_values, f.field_perm, m.meta_id, m.field_pos, m.field_search, m.field_req, m.form_id " . "FROM {$wpdb->cp_ad_fields} f " . "INNER JOIN {$wpdb->cp_ad_meta} m " . "ON f.field_id = m.field_id " . "WHERE m.form_id = %s " . "ORDER BY m.field_pos asc", $_GET['id']); $results = $wpdb->get_results($sql); if ($results) { echo cp_admin_formbuilder($results); } else { ?> <tr> <td colspan="5" style="text-align: center;"><p><br /><?php _e('No fields have been added to this form layout yet.', APP_TD); ?> <br /><br /></p></td> </tr> <?php } // end $results ?> </tbody> </table> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="<?php _e('Save Changes', APP_TD); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', APP_TD); ?> " /> <input name="formlayout" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php $current_user->user_login; ?> " /> </p> </form> </td> <td> <h3><?php _e('Available Fields', APP_TD); ?> </h3> <form method="post" id="mainform" action=""> <div class="fields-panel"> <table class="widefat"> <thead> <tr> <th style="" class="manage-column column-cb check-column" id="cb" scope="col"><input type="checkbox"/></th> <th scope="col"><?php _e('Field Name', APP_TD); ?> </th> <th scope="col"><?php _e('Type', APP_TD); ?> </th> </tr> </thead> <tbody> <?php // Select all available fields not currently on the form layout. // Also exclude any core fields since they cannot be removed from the layout. $sql = $wpdb->prepare("SELECT f.field_id,f.field_label,f.field_type " . "FROM {$wpdb->cp_ad_fields} f " . "WHERE f.field_id " . "NOT IN (SELECT m.field_id " . "FROM {$wpdb->cp_ad_meta} m " . "WHERE m.form_id = %s) " . "AND f.field_perm <> '1'", $_GET['id']); $results = $wpdb->get_results($sql); if ($results) { foreach ($results as $result) { ?> <tr class="even"> <th class="check-column" scope="row"><input type="checkbox" value="<?php echo $result->field_id; ?> " name="field_id[]"/></th> <td><?php echo esc_html(translate($result->field_label, APP_TD)); ?> </td> <td><?php echo $result->field_type; ?> </td> </tr> <?php } // end foreach } else { ?> <tr> <td colspan="4" style="text-align: center;"><p><br /><?php _e('No fields are available.', APP_TD); ?> <br /><br /></p></td> </tr> <?php } // end $results ?> </tbody> </table> </div> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Add Fields to Form Layout', APP_TD); ?> " /></p> <input name="form_id" type="hidden" value="<?php echo $_GET['id']; ?> " /> <input name="submitted" type="hidden" value="yes" /> </form> </td> </tr> </table> </div><!-- /wrap --> <?php break; case 'delete': // delete the form based on the form id cp_delete_form($_GET['id']); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Deleting form layout.....', APP_TD); ?> <br /><br /><img src="<?php bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php break; default: $results = $wpdb->get_results("SELECT * FROM {$wpdb->cp_ad_forms} ORDER BY id desc"); ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('Form Layouts', APP_TD); ?> <a class="button add-new-h2" href="?page=layouts&action=addform"><?php _e('Add New', APP_TD); ?> </a></h2> <?php cp_admin_info_box(); ?> <p class="admin-msg"><?php _e('Form layouts allow you to create your own custom ad submission forms. Each form is essentially a container for your fields and can be applied to one or all of your categories. If you do not create any form layouts, the default one will be used. To change the default form, create a new form layout and apply it to all categories.', APP_TD); ?> </p> <table id="tblspacer" class="widefat fixed"> <thead> <tr> <th scope="col" style="width:35px;"> </th> <th scope="col"><?php _e('Name', APP_TD); ?> </th> <th scope="col"><?php _e('Description', APP_TD); ?> </th> <th scope="col"><?php _e('Categories', APP_TD); ?> </th> <th scope="col" style="width:150px;"><?php _e('Modified', APP_TD); ?> </th> <th scope="col" style="width:75px;"><?php _e('Status', APP_TD); ?> </th> <th scope="col" style="text-align:center;width:100px;"><?php _e('Actions', APP_TD); ?> </th> </tr> </thead> <?php if ($results) { $rowclass = ''; $i = 1; ?> <tbody id="list"> <?php foreach ($results as $result) { $rowclass = 'even' == $rowclass ? 'alt' : 'even'; ?> <tr class="<?php echo $rowclass; ?> "> <td style="padding-left:10px;"><?php echo $i; ?> .</td> <td><a href="?page=layouts&action=editform&id=<?php echo $result->id; ?> "><strong><?php echo $result->form_label; ?> </strong></a></td> <td><?php echo $result->form_desc; ?> </td> <td><?php echo cp_match_cats(unserialize($result->form_cats)); ?> </td> <td><?php echo mysql2date(get_option('date_format') . ' ' . get_option('time_format'), $result->form_modified); ?> <?php _e('by', APP_TD); ?> <?php echo $result->form_owner; ?> </td> <td><?php echo cp_get_status_i18n($result->form_status); ?> </td> <td style="text-align:center"><a href="?page=layouts&action=formbuilder&id=<?php echo $result->id; ?> &title=<?php echo urlencode($result->form_label); ?> "><img src="<?php bloginfo('template_directory'); ?> /images/layout_add.png" alt="<?php _e('Edit form layout', APP_TD); ?> " title="<?php _e('Edit form layout', APP_TD); ?> " /></a> <a href="?page=layouts&action=editform&id=<?php echo $result->id; ?> "><img src="<?php bloginfo('template_directory'); ?> /images/edit.png" alt="<?php _e('Edit form properties', APP_TD); ?> " title="<?php _e('Edit form properties', APP_TD); ?> " /></a> <a onclick="return confirmBeforeDelete();" href="?page=layouts&action=delete&id=<?php echo $result->id; ?> "><img src="<?php bloginfo('template_directory'); ?> /images/cross.png" alt="<?php _e('Delete form layout', APP_TD); ?> " title="<?php _e('Delete form layout', APP_TD); ?> " /></a></td> </tr> <?php $i++; } // end for each ?> </tbody> <?php } else { ?> <tr> <td colspan="7"><?php _e('No form layouts found.', APP_TD); ?> </td> </tr> <?php } // end $results ?> </table> </div><!-- end wrap --> <?php } // end switch ?> <script type="text/javascript"> /* <![CDATA[ */ function confirmBeforeDelete() { return confirm("<?php _e('Are you sure you want to delete this?', APP_TD); ?> "); } function confirmBeforeRemove() { return confirm("<?php _e('Are you sure you want to remove this?', APP_TD); ?> "); } /* ]]> */ </script> <?php }
function cp_form_layouts() { global $options_new_form, $wpdb, $current_user; $current_user = wp_get_current_user(); // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['action'])) { $theswitch = $_GET['action']; } else { $theswitch = ''; } ?> <script type="text/javascript"> /* <![CDATA[ */ /* initialize the form validation */ jQuery(document).ready(function($) { $("#mainform").validate({errorClass: "invalid"}); }); /* ]]> */ </script> <?php switch ($theswitch) { // Adds new AV Form to DB case 'addform': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br/></div> <h2><?php _e('New Form Layout', 'appthemes'); ?> </h2> <?php cp_admin_info_box(); ?> <?php // check and make sure the form was submitted and the hidden fcheck id matches the cookie fcheck id if (isset($_POST['submitted'])) { if (!isset($_POST['post_category'])) { wp_die('<p style="color:red;">' . __("Error: Please select at least one category. <a href='#' onclick='history.go(-1);return false;'>Go back</a>", 'appthemes') . '</p>'); } // EKELEME (Form tablosuna cat id ekler) $cat_id = split('"', serialize($_POST['post_category'])); // @todo Change to Insert $insert = $wpdb->prepare("INSERT INTO {$wpdb->cp_ad_forms}" . " (form_name, form_label, form_desc, form_cats, form_status, form_owner, form_created, cat_id) " . "VALUES ( %s, %s, %s, %s, %s, %s, %s , %s)", appthemes_clean(cp_make_custom_name($_POST['form_label'])), appthemes_clean($_POST['form_label']), appthemes_clean($_POST['form_desc']), serialize($_POST['post_category']), appthemes_clean($_POST['form_status']), appthemes_clean($_POST['form_owner']), gmdate('Y-m-d H:i:s'), $cat_id[1]); // EKELEME BITIS $results = $wpdb->query($insert); if ($results) { ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Creating your form.....', 'appthemes'); ?> <br /><br /><img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php } // end $results } else { ?> <form method="post" id="mainform" action=""> <?php echo cp_admin_fields($options_new_form); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Create New Form', 'appthemes'); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', 'appthemes'); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } // end isset $_POST ?> </div><!-- end wrap --> <?php break; // Updates new AV Form from DB // Updates new AV Form from DB case 'editform': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br/></div> <h2><?php _e('Erisim Formu Ozelliklerini Duzenle', 'appthemes'); ?> </h2> <?php if (isset($_POST['submitted']) && $_POST['submitted'] == 'yes') { if (!isset($_POST['post_category'])) { wp_die('<p style="color:red;">' . __("Error: Please select at least one category. <a href='#' onclick='history.go(-1);return false;'>Go back</a>", 'appthemes') . '</p>'); } // @todo Change to Update // EKLEME (Form duzenleme sirasinda cat id update eder) $update_cat_id = split('"', serialize($_POST['post_category'])); $update = $wpdb->prepare("UPDATE {$wpdb->cp_ad_forms} SET" . " form_label = %s," . " form_desc = %s," . " form_cats = %s," . " form_status = %s," . " form_owner = %s," . " form_modified = %s," . " cat_id = %s" . " WHERE id = %s", appthemes_clean($_POST['form_label']), appthemes_clean($_POST['form_desc']), serialize($_POST['post_category']), appthemes_clean($_POST['form_status']), $_POST['form_owner'], gmdate('Y-m-d H:i:s', time() + get_option('gmt_offset') * 3600), $update_cat_id[1], $_GET['id']); // EKLEME BITIS $results = $wpdb->get_row($update); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Saving your changes.....', 'appthemes'); ?> <br /><br /><img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php } else { ?> <form method="post" id="mainform" action=""> <?php echo cp_admin_db_fields($options_new_form, 'cp_ad_forms', 'id'); ?> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Save changes', 'appthemes'); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', 'appthemes'); ?> " /></p> <input name="submitted" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php echo $current_user->user_login; ?> " /> </form> <?php } // end isset $_POST ?> </div><!-- end wrap --> <?php break; /** * Form Builder Page * Where fields are added to form layouts */ /** * Form Builder Page * Where fields are added to form layouts */ case 'formbuilder': ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br/></div> <h2><?php _e('Erisim Formu Duzenleme', 'appthemes'); ?> </h2> <?php cp_admin_info_box(); ?> <?php // add fields to page layout on left side if (isset($_POST['field_id'])) { // take selected checkbox array and loop through ids foreach ($_POST['field_id'] as $value) { // @todo Change to Insert $insert = $wpdb->prepare("INSERT INTO {$wpdb->cp_ad_meta}" . " (form_id, field_id) VALUES ( %s, %s)", appthemes_clean($_POST['form_id']), appthemes_clean($value)); $results = $wpdb->query($insert); } // end foreach } // end $_POST // update form layout positions and required fields on left side. if (isset($_POST['formlayout'])) { // loop through the post array and update the required checkbox and field position foreach ($_POST as $key => $value) { // since there's some $_POST values we don't want to process, only give us the // numeric ones which means it contains a meta_id and we want to update it if (is_numeric($key)) { // quick hack to prevent php "notice: undefined index:" msg when php strict warnings is on if (!isset($value['field_req'])) { $value['field_req'] = ''; } if (!isset($value['field_search'])) { $value['field_search'] = ''; } $update = "UPDATE {$wpdb->cp_ad_meta} SET " . "field_req = '" . $wpdb->escape(appthemes_clean($value['field_req'])) . "', " . "field_search = '" . $wpdb->escape(appthemes_clean($value['field_search'])) . "' " . "WHERE meta_id ='" . $wpdb->escape($key) . "'"; $wpdb->query($update); } // end if_numeric } // end for each echo '<p class="info">' . __('Your changes have been saved.', 'appthemes') . '</p>'; } // end isset $_POST // check to prevent php "notice: undefined index" msg when php strict warnings is on if (isset($_GET['del_id'])) { $theswitch = $_GET['del_id']; } else { $theswitch = ''; } // Remove items from form layout if ($theswitch) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->cp_ad_meta} WHERE meta_id = %s", $_GET['del_id'])); } // @todo Change to Update //update the forms modified date $update = $wpdb->prepare("UPDATE {$wpdb->cp_ad_forms} SET" . " form_modified = %s WHERE id = %s", gmdate('Y-m-d H:i:s', time() + get_option('gmt_offset') * 3600), $_GET['id']); $results = $wpdb->get_row($update); ?> <table> <tr style="vertical-align:top;"> <td style="width:800px;padding:0 20px 0 0;"> <h3><?php _e('Erisim Form Ismi', 'appthemes'); ?> - <?php echo ucfirst(urldecode($_GET['title'])); ?> <span id="loading"></span></h3> <form method="post" id="mainform" action=""> <table class="widefat"> <thead> <tr> <th scope="col" colspan="2"><?php _e('Erisim Formu Onizleme', 'appthemes'); ?> </th> <th scope="col" style="width:75px;text-align:center;" title="<?php _e('Show field in the category refine search sidebar', 'appthemes'); ?> "><?php _e('Gelismis Arama', 'appthemes'); ?> </th> <th scope="col" style="width:75px;text-align:center;"><?php _e('Gerekli Alan', 'appthemes'); ?> </th> <th scope="col" style="width:75px;text-align:center;"><?php _e('Kaldir', 'appthemes'); ?> </th> </tr> </thead> <tbody class="sortable"> <?php // If this is the first time this form is being customized then auto // create the core fields and put in cp_meta db table echo cp_add_core_fields($_GET['id']); // Then go back and select all the fields assigned to this // table which now includes the added core fields. $sql = $wpdb->prepare("SELECT f.field_label, f.field_name, f.field_type, f.field_values, f.field_perm, m.meta_id, m.field_pos, m.field_search, m.field_req, m.form_id " . "FROM {$wpdb->cp_ad_fields} f " . "INNER JOIN {$wpdb->cp_ad_meta} m " . "ON f.field_id = m.field_id " . "WHERE m.form_id = %s " . "ORDER BY m.field_pos asc", $_GET['id']); $results = $wpdb->get_results($sql); if ($results) { echo cp_admin_formbuilder($results); } else { ?> <tr> <td colspan="5" style="text-align: center;"><p><br/><?php _e('No fields have been added to this form layout yet.', 'appthemes'); ?> <br/><br/></p></td> </tr> <?php } // end $results ?> </tbody> </table> <p class="submit"> <input class="btn button-primary" name="save" type="submit" value="<?php _e('Save Changes', 'appthemes'); ?> " /> <input name="cancel" type="button" onClick="location.href='?page=layouts'" value="<?php _e('Cancel', 'appthemes'); ?> " /> <input name="formlayout" type="hidden" value="yes" /> <input name="form_owner" type="hidden" value="<?php $current_user->user_login; ?> " /> </p> </form> </td> <td> <h3><?php _e('Mevcut Erisim Alanlari', 'appthemes'); ?> </h3> <form method="post" id="mainform" action=""> <div class="fields-panel"> <table class="widefat"> <thead> <tr> <th style="" class="manage-column column-cb check-column" id="cb" scope="col"><input type="checkbox"/></th> <th scope="col"><?php _e('Alan Adi', 'appthemes'); ?> </th> <th scope="col"><?php _e('Alan Tipi', 'appthemes'); ?> </th> </tr> </thead> <tbody> <?php // Select all available fields not currently on the form layout. // Also exclude any core fields since they cannot be removed from the layout. $sql = $wpdb->prepare("SELECT f.field_id,f.field_label,f.field_type " . "FROM {$wpdb->cp_ad_fields} f " . "WHERE f.field_id " . "NOT IN (SELECT m.field_id " . "FROM {$wpdb->cp_ad_meta} m " . "WHERE m.form_id = %s) " . "AND f.field_perm <> '1'", $_GET['id']); $results = $wpdb->get_results($sql); if ($results) { foreach ($results as $result) { ?> <tr class="even"> <th class="check-column" scope="row"><input type="checkbox" value="<?php echo $result->field_id; ?> " name="field_id[]"/></th> <td><?php echo esc_html(translate($result->field_label, 'appthemes')); ?> </td> <td><?php echo $result->field_type; ?> </td> </tr> <?php } // end foreach } else { ?> <tr> <td colspan="4" style="text-align: center;"><p><br /><?php _e('No fields are available.', 'appthemes'); ?> <br /><br /></p></td> </tr> <?php } // end $results ?> </tbody> </table> </div> <p class="submit"><input class="btn button-primary" name="save" type="submit" value="<?php _e('Forma Alan Ekle', 'appthemes'); ?> " /></p> <input name="form_id" type="hidden" value="<?php echo $_GET['id']; ?> " /> <input name="submitted" type="hidden" value="yes" /> </form> </td> </tr> </table> </div><!-- /wrap --> <?php break; case 'delete': // delete the form based on the form id cp_delete_form($_GET['id']); ?> <p style="text-align:center;padding-top:50px;font-size:22px;"><?php _e('Deleting form layout.....', 'appthemes'); ?> <br /><br /><img src="<?php echo bloginfo('template_directory'); ?> /images/loader.gif" alt="" /></p> <meta http-equiv="refresh" content="0; URL=?page=layouts"> <?php break; default: $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->cp_ad_forms} ORDER BY id desc")); ?> <div class="wrap"> <div class="icon32" id="icon-themes"><br /></div> <h2><?php _e('Erisim Form Duzenlemesi', 'appthemes'); ?> <a class="button add-new-h2" href="?page=layouts&action=addform">Yeni Form Ekle</a></h2> <?php cp_admin_info_box(); ?> <p class="admin-msg"><?php _e('Formlar yeni bir Erisim Engeli eklenecegi sirada o Erisim Engelini olusturan alanlardan olusur. Her Erisim Kategorisine ozel Form ekleyebilirsiniz. Asagida tum Erisim Formlari listelenmektedir. Yeni bir Form ekleyebilir yada var olan Formu duzenleyebilirsiniz. Ayrica Formlara istediginiz alanlari ekleyebilirsiniz.', 'appthemes'); ?> </p> <table id="tblspacer" class="widefat fixed"> <thead> <tr> <th scope="col" style="width:35px;"> </th> <th scope="col"><?php _e('Form Ismi', 'appthemes'); ?> </th> <th scope="col"><?php _e('Form Aciklamasi', 'appthemes'); ?> </th> <th scope="col"><?php _e('Erisim Kategorileri', 'appthemes'); ?> </th> <th scope="col" style="width:150px;"><?php _e('Degistiren', 'appthemes'); ?> </th> <th scope="col" style="width:75px;"><?php _e('Durumu', 'appthemes'); ?> </th> <th scope="col" style="text-align:center;width:100px;"><?php _e('Aksiyonlar', 'appthemes'); ?> </th> </tr> </thead> <?php if ($results) { $rowclass = ''; $i = 1; ?> <tbody id="list"> <?php foreach ($results as $result) { $rowclass = 'even' == $rowclass ? 'alt' : 'even'; ?> <tr class="<?php echo $rowclass; ?> "> <td style="padding-left:10px;"><?php echo $i; ?> .</td> <td><a href="?page=layouts&action=editform&id=<?php echo $result->id; ?> "><strong><?php echo $result->form_label; ?> </strong></a></td> <td><?php echo $result->form_desc; ?> </td> <td><?php echo cp_match_cats(unserialize($result->form_cats)); ?> </td> <td><?php echo mysql2date(get_option('date_format') . ' ' . get_option('time_format'), $result->form_modified); ?> <?php _e('by', 'appthemes'); ?> <?php echo $result->form_owner; ?> </td> <td><?php echo ucfirst($result->form_status); ?> </td> <td style="text-align:center"><a href="?page=layouts&action=formbuilder&id=<?php echo $result->id; ?> &title=<?php echo urlencode($result->form_label); ?> "><img src="<?php echo bloginfo('template_directory'); ?> /images/layout_add.png" alt="<?php echo _e('Edit form layout', 'appthemes'); ?> " title="Formu Duzenle" /></a> <a href="?page=layouts&action=editform&id=<?php echo $result->id; ?> "><img src="<?php echo bloginfo('template_directory'); ?> /images/edit.png" alt="<?php echo _e('Edit form properties', 'appthemes'); ?> " title="Form Ozelliklerini Duzenle" /></a> <a onclick="return confirmBeforeDelete();" href="?page=layouts&action=delete&id=<?php echo $result->id; ?> "><img src="<?php echo bloginfo('template_directory'); ?> /images/cross.png" alt="<?php echo _e('Delete form layout', 'appthemes'); ?> " title="Formu Sil" /></a></td> </tr> <?php $i++; } // end for each ?> </tbody> <?php } else { ?> <tr> <td colspan="7"><?php _e('No form layouts found.', 'appthemes'); ?> </td> </tr> <?php } // end $results ?> </table> </div><!-- end wrap --> <?php } // end switch ?> <script type="text/javascript"> /* <![CDATA[ */ function confirmBeforeDelete() { return confirm("<?php _e('Are you sure you want to delete this?', 'appthemes'); ?> "); } function confirmBeforeRemove() { return confirm("<?php _e('Are you sure you want to remove this?', 'appthemes'); ?> "); } /* ]]> */ </script> <?php }