} } } } $i = 1; ?> <div id="wizard" class="tab-content-bdr-0"> <?php if ((int) $show_payment_tab > 0) { echo "<script>var show_payment_tab=1;</script>"; } else { echo "<script>var show_payment_tab=0;</script>"; } if (!empty($myvar)) { foreach ($myvar as $key => $value) { if (is_user_company_billing() && !is_user_company_admin()) { if (strtolower($key) == 'payments') { if (strtolower($key) == 'payments') { if ((int) $show_payment_tab > 0) { ?> <h2><?php echo $key; ?> </h2> <section> <?php echo $myvar[$key]; ?> </section> <?php } else {
<?php global $wpdb, $per_page, $resulttotal, $current_user; $total = 'select count(*) as total from ' . $wpdb->prefix . 'application_data where status = "modified" and deleted_on is null;'; $resulttotal = $wpdb->get_results($total); $resulttotal = $resulttotal[0]->total; if (isset($_GET['paged'])) { $sql = "select * from " . $wpdb->prefix . "application_data where status = 'modified' and deleted_on is null limit " . $start_from . "," . $per_page; } else { $sql = "select * from " . $wpdb->prefix . "application_data where status = 'modified' and deleted_on is null limit " . $start_from . "," . $per_page; } $resultfromdb = $wpdb->get_results($sql); $roles = get_user_meta(get_current_user_id(), "wp_capabilities"); $company_admin = is_user_company_admin(); if (user_can($current_user, "customer") && $company_admin == 1) { $sql = "select `id`, `name`, `doc_id` from " . $wpdb->prefix . "applications "; $new_accreditation = $wpdb->get_results($sql); ?> <script> $(document).ready(function() { $('#apply_for_new_accreditation_table').DataTable( { "searching": false, "processing": true, "bPaginate":false, "aoColumnDefs": [ { 'bSortable': false, 'aTargets': [ 1,2 ] } ] } ); jQuery(".colorbox-inline-70").colorbox({ overlayClose: false, inline:true,
function get_application_by_certificate_crm_id() { global $current_user, $wpdb; $result = array(); $third_party_array = array(2, 7, 10); if (isset($_REQUEST['id']) && !empty($_REQUEST['id'])) { $crm_id = $_REQUEST['id']; $app_data = $wpdb->get_results("SELECT ad.id as app_id,ad.application_name,ad.certificate_status,ad.certificate_url,ad.status,ad.certificate_name,ad.new_application_id,ad.program_id,p.name as program_name,c.name as company, ad.crm_id from " . $wpdb->prefix . "application_data as ad left join " . $wpdb->prefix . "programs as p on p.id = ad.program_id left join " . $wpdb->prefix . "company as c on c.id = ad.company_id and c.id=ad.company_id where certificate_crm_id ='" . $crm_id . "'"); //echo "SELECT ad.id as app_id,ad.application_name,p.name as program_name,c.name from " . $wpdb->prefix . "application_data as ad join " . $wpdb->prefix . "programs as p join " . $wpdb->prefix . "company as c on p.id = ad.program_id and c.id=ad.company_id where certificate_crm_id ='".$crm_id."'";die; if (count($app_data) > 0) { foreach ($app_data as $ad) { $opr = ''; $temp = array(); $temp['app_id'] = $ad->app_id; $temp['app_name'] = $ad->application_name; $temp['program_name'] = $ad->program_name; $temp['company'] = $ad->company; $temp['status'] = $ad->status; if (user_can($current_user, "staff")) { //$opr .= '<a href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=true" title="View Application"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-eye-open"></span></a>'; if (strtolower($ad->status) == 'new' || strtolower($ad->status) == 'modified' || strtolower($ad->status) == 'draft') { $request_url = get_admin_url() . 'admin-post.php?action=approve-application-form&id=' . base64_encode($ad->app_id) . '&is_ajax=true'; $redirect_url = site_url() . '/index.php/listings?page=application-form-register&view=approved'; if ($ad->status == 'modified') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a title="View Difference From Last Update" href="#app_diff" class="colorbox-inline" onclick="getAppDiff(\'' . $ad->app_id . '\',\'app\', \'' . $ad->company . '\', \'' . get_admin_url() . 'admin-post.php?action=approve-application-form&id=' . base64_encode($ad->app_id) . '\', \'' . $ad->certificate_name . '\', \'' . $redirect_url . '\' );getAppDocDiff(\'' . $ad->app_id . '\', \'doc\', \'' . $ad->company . '\')" ><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-random"></span></li></a>'; } if (!empty($ad->certificate_name) && !in_array($ad->program_id, $third_party_array)) { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a href="#" onclick="application_push_to_crm(\'' . $request_url . '\', \'' . $redirect_url . '\')" class="approveLink" value="" title="Push To CRM"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-okglyphicon glyphicon-ok"></span></li></a>'; } else { $certificate_name = isset($ad->certificate_name) && $ad->certificate_name != '' ? $ad->certificate_name : ''; $new_inspectionagencycert = isset($json->new_application->_linked->new_certificate->new_inspectionagencycert) ? $json->new_application->_linked->new_certificate->new_inspectionagencycert : ''; $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a href="#app_certification_popup" id="approve-link-' . $ad->app_id . '" onclick="return openCertificatePopUp(\'' . $ad->app_id . '\',\'' . $ad->program_id . '\',\'' . $new_inspectionagencycert . '\',\'' . $ad->certificate_name . '\')" data-href="' . $request_url . '" redirect-href="' . $redirect_url . '" class="colorbox-inline" value="" title="Push To CRM"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-ok"></span></li></a>'; } } if (empty($ad->certificate_url)) { if (strtolower($ad->status) != 'completed') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a class="icon-3" href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=true" title="View Application"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-eye-open"></span></li></a>'; } if (strtolower($ad->status) == 'new' || strtolower($ad->status) == 'modified' || strtolower($ad->status) == 'draft') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a title="Edit Application" class="icon-3" href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=false"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-edit"></span></li></a>'; } } } else { if ((user_can($current_user, "customer") || is_user_company_admin()) && empty($ad->certificate_url)) { if (strtolower($ad->status) != 'completed') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a class="icon-3" href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=true" title="View Application"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-eye-open"></span></li></a>'; } if ($ad->new_application_id == 0 && strtolower($ad->status) != 'completed') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a title="Edit Application" class="icon-3" href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=false"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-edit"></span></li></a>'; } } else { if (user_can($current_user, "assessor") && empty($ad->certificate_url) && strtolower($ad->status) != 'completed') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a class="icon-3" href="' . site_url() . '/index.php/listings/?page=create-form-register&id=' . base64_encode($ad->app_id) . '&view=true" title="View Application"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-eye-open"></span></li></a>'; } } } if (is_user_company_admin() && empty($ad->crm_id) && strtolower($ad->status) != 'completed') { $opr .= '<li style="float: left;list-style-type: none; margin-right: 5px;"><a title="Delete Application" class="icon-3" href="' . get_admin_url() . 'admin-post.php?action=delete-application-form&id=' . base64_encode($ad->app_id) . '" onclick="return confirm(\'Are you sure you want to delete this application ?\');"><span style="font-size: 20px;" aria-hidden="true" class="glyphicon glyphicon-trash">' . $ad->crm_id . '</span></li></a>'; } $temp['act'] = $opr; $result[$ad->app_id] = $temp; } } } echo json_encode($result); die; }