<?php global $wpdb; global $current_user; // Use global get_currentuserinfo(); // Make sure global is set, if not set it. $company_id = $current_user->company_id; $company_name = $current_user->company_name; //In case of generating application from quotation then show payment tab for showing quotation amount in application tabs $show_payment_tab = isset($_REQUEST['show_payment_tab']) && !empty($_REQUEST['show_payment_tab']) ? $_REQUEST['show_payment_tab'] : 0; $new_application_id = 0; if (isset($_GET['appid'])) { $appid = base64_decode($_GET['appid']); $CrmOperationsobj = new CrmOperations(); $resultsfromcrm = $CrmOperationsobj->getCrmEntityDetails('new_application', array('type' => 'and', 'conditions' => array(array('attribute' => 'new_applicationid', 'operator' => 'eq', 'value' => $appid))), 'list'); //echo "<pre>";print_r($resultsfromcrm);die; } if (!isset($appid) && isset($_GET['id'])) { $appid = base64_decode($_GET['id']); } $status = ''; if (isset($_GET['id']) || isset($_GET['crmid'])) { if (user_can($current_user, "staff") || user_can($current_user, "assessor")) { $sql = 'select * from ' . $wpdb->prefix . 'application_data where id=' . base64_decode($_GET['id']) . " AND status!='Draft'"; } else { if (user_can($current_user, "contact")) { $sql = 'select * from ' . $wpdb->prefix . 'application_data left join ' . $wpdb->prefix . 'application_user_roles on ' . $wpdb->prefix . 'application_user_roles.application_id=' . $wpdb->prefix . 'application_data.id where ' . $wpdb->prefix . 'application_data.id=' . base64_decode($_GET['id']); } else { $sql = 'select * from ' . $wpdb->prefix . 'application_data where id=' . base64_decode($_GET['id']) . " AND user_id=" . get_current_user_id(); }
function get_invoice_from_crm() { $CrmOperationsobj = new CrmOperations(); $resultsfromcrm = $CrmOperationsobj->getCrmEntityDetails('invoice', array('type' => 'and', 'conditions' => array(array('attribute' => 'new_applicationid', 'operator' => 'eq', 'value' => $_POST['app_id']))), 'list'); // echo "<pre>";print_r($resultsfromcrm); $resulttotal = $resultsfromcrm->TotalRecordCount; foreach ($resultsfromcrm->Entities as $result) { } echo $result->name . "~" . $result->totalamount->FormattedValue; }
<?php global $wpdb, $per_page, $resulttotal; global $current_user; // Use global get_currentuserinfo(); // Make sure global is set, if not set it. //include(WP_PLUGIN_DIR.'crm-connector/CrmOperations.php'); $CrmOperationsobj = new CrmOperations(); $resultsfromcrm = $CrmOperationsobj->getCrmEntityDetails('new_application', array('type' => 'and', 'conditions' => array(array('entityname' => 'new_certificate', 'operator' => 'null', 'attribute' => "new_certificateid", 'value' => ''))), 'list', '', $page, $per_page, false); //echo "<pre>";print_r($resultsfromcrm); $resulttotal = $resultsfromcrm->TotalRecordCount; $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, "sDom": '<"head-controls"l<"app-filter">f>t<"foot-controls"ip>', "bPaginate":false, "aoColumnDefs": [ { 'bSortable': false, 'aTargets': [ 1,2 ] } ] } ); jQuery(".colorbox-inline-70").colorbox({ overlayClose: false,
<th>Status</th> <th>Amount Due</th> <th>Pay</th> </tr> </thead> <tbody> <?php if (isset($_GET['crmid'])) { $crmid = base64_decode($_GET['crmid']); $CrmOperationsobj = new CrmOperations(); $resultsfromcrm = $CrmOperationsobj->getCrmEntityDetails('invoice', array('type' => 'and', 'conditions' => array(array('attribute' => 'customerid', 'operator' => 'eq', 'value' => $crmid))), 'list', '', $page, $per_page); // echo "<pre>";print_r($resultsfromcrm); $resulttotal = $resultsfromcrm->TotalRecordCount; foreach ($resultsfromcrm->Entities as $result) { ?> <tr> <td><?php echo isset($result->new_applicationid->Id) ? $result->new_applicationid->Id : ""; ?> </td> <td><?php echo isset($result->statuscode->FormattedValue) ? $result->statuscode->FormattedValue : ""; ?> </td> <td><?php echo isset($result->totalamount->FormattedValue) ? $result->totalamount->FormattedValue : "";