function completed_orders_shortcode()
{
global $wpdb;
global $gfpdf;
$output = '';
$leads = $wpdb->get_results($wpdb->prepare("SELECT wp_tpl_docs.file_url, wp_rg_lead.unique_id, wp_rg_form_meta.display_meta, wp_rg_lead.orderStatus, wp_rg_lead.date_created, wp_rg_lead.id, wp_rg_lead.form_id, wp_rg_form.title, wp_rg_lead.eco_ref, wp_rg_lead.asic_status FROM wp_rg_lead LEFT JOIN wp_rg_form ON wp_rg_lead.form_id = wp_rg_form.id LEFT JOIN wp_tpl_docs ON wp_rg_lead.id = wp_tpl_docs.lead_id LEFT JOIN wp_rg_form_meta ON wp_rg_lead.form_id = wp_rg_form_meta.form_id WHERE wp_rg_lead.created_by = %d AND wp_rg_lead.orderStatus = 'complete' ORDER BY wp_rg_lead.id DESC", wp_get_current_user()->ID));
$form_id_excluded = array(3, 4, 5, 60, 66, 68, 71);
foreach ($leads as $lead) {
if ($lead->form_id == "11" || $lead->form_id == "58" and $lead->eco_ref != "") {
//is a company incorporation
switch ($lead->asic_status) {
case "Order complete":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Download</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu multi-level" style="min-width: 107px;">
<li class="dropdown-submenu">
<a tabindex="-1" class="btn-xs"href="#"><i class="fa fa-book fa-fw"></i> Documents</a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getDocs.php?orderid=' . $lead->eco_ref . '">Direct Download</a></li>
<li><a href="https://app.thesmsfacademy.com.au/corp/getDocs.php?orderid=' . $lead->eco_ref . '" class="dropbox-saver" data-filename="' . $lead->eco_ref . '.pdf">Save</a></li>
<li><div class="g-savetodrive" data-filename="' . $lead->eco_ref . '.pdf" data-sitename="TSA Campus" data-src="https://app.thesmsfacademy.com.au/corp/getDocs.php?orderid=' . $lead->eco_ref . '"></div></li>
</ul>
</li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getCert.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-certificate fa-fw"></i> Certificate</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getCasFile.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-briefcase fa-fw"></i> CAS File</a></tr></li>
</ul></div></tr></form>';
break;
case "complete":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Download</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getDocs.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-book fa-fw"></i> Documents</a></li>
<li><a href="https://app.thesmsfacademy.com.au/corp/getDocs.php?orderid=' . $lead->eco_ref . '" class="dropbox-saver"></a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getCert.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-certificate fa-fw"></i> Certificate</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/corp/getCasFile.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-briefcase fa-fw"></i> CAS File</a></tr></li>
</ul></div></tr></form>';
break;
case "Submitted to ASIC Temporarily reserved subject to ASIC decision":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td><i class="fa fa-refresh fa-spin"></i> Processing</tr></form>';
break;
case "Submitted to ASIC":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td><i class="fa fa-refresh fa-spin"></i> Processing</tr></form>';
break;
case "Checks":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td></tr></form>';
break;
case "Rejected":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td><button class="btn-danger default btn-xs" style="width: 102px; text-align: left; border:none;" onclick="SetHiddenFormSettingsTPO(' . $lead->id . ', \'update\',\'' . get_action_link($lead->form_id, $lead->id, $wpdb) . '\')"><i class="fa fa-edit"></i> Amend</button></tr></form>';
break;
case "Failed ASIC validation":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td><button class="btn-danger default btn-xs" style="width: 102px; text-align: left; border:none;" onclick="SetHiddenFormSettingsTPO(' . $lead->id . ', \'update\',\'' . get_action_link($lead->form_id, $lead->id, $wpdb) . '\')"><i class="fa fa-edit"></i> Amend</button></tr></form>';
break;
case "Incomplete":
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td><button class="btn default btn-xs purple" style="width: 102px; text-align: left; border:none;" onclick="SetHiddenFormSettingsTPO(' . $lead->id . ', \'update\',\'' . get_action_link($lead->form_id, $lead->id, $wpdb) . '\')"><i class="fa fa-play"></i> Resume</button></tr></form>';
break;
default:
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->asic_status . '</td><td></tr></form>';
}
} elseif ($lead->form_id == "52" or $lead->form_id == "6") {
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->orderStatus . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Actions</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" target="_blank" href="' . $lead->file_url . '"><i class="fa fa-book fa-fw"></i> Get Documents</a></li>
<li><a class="btn-xs" href="http://abn.thesmsfacademy.com.au/ABRWeb?uid=' . $lead->unique_id . '" target="_blank"><i class="fa fa-laptop fa-fw"></i> Apply for ABN</a></li>
</ul></div></tr></form>';
} elseif ($lead->form_id == "15") {
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->orderStatus . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Actions</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/?gf_pdf=1&fid=' . $lead->form_id . '&lid=' . $lead->id . '&download=1&template=abp_resolutions.php"><i class="fa fa-book fa-fw"></i> Get Resolutions</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/?gf_pdf=1&fid=' . $lead->form_id . '&lid=' . $lead->id . '&download=1&template=abp-pds.php"><i class="fa fa-book fa-fw"></i> Get PDS</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/save-time/?fid=' . $lead->form_id . '"><i class="fa fa-book fa-fw"></i> Reuse Data</a></li>
</ul></div></tr></form>';
} elseif ($lead->form_id == "43") {
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->orderStatus . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Actions</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/?gf_pdf=1&fid=' . $lead->form_id . '&lid=' . $lead->id . '&download=1&template=inv-strategy.php"><i class="fa fa-book fa-fw"></i> Documents</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/save-time/?fid=' . $lead->form_id . '"><i class="fa fa-book fa-fw"></i> Reuse Data</a></li>
</ul></div></tr></form>';
} elseif ($lead->form_id == "56" || $lead->form_id == "53" || $lead->form_id == "65") {
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->orderStatus . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Actions</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="' . get_sit_doc_link($lead->form_id, $lead->id, $wpdb) . '" target="_blank"><i class="fa fa-book fa-fw"></i> Documents</a></li>
</ul></div></tr></form>';
} elseif ($lead->form_id == "60") {
//Do nothing so that we exclude the ABR.GOV.AU Form
} else {
if (!in_array($lead->form_id, $form_id_excluded)) {
$output .= '<tr><td>' . $lead->form_id . $lead->id . '</td><td>' . get_reference($lead->form_id, $lead->id, $wpdb) . '</td><td>' . get_name($lead->form_id, $lead->id, $wpdb) . '</td><td>' . $lead->title . '</td><td>' . date("d/m/Y", strtotime($lead->date_created)) . '</td><td>' . $lead->orderStatus . '</td><td>
<div class="btn-group">
<a class="btn-xs btn-primary " style="float: left; background-color: #4b8df8;" href="#"><i class="fa fa-download fa-fw"></i> Actions</a>
<a class="btn-xs btn-primary dropdown-toggle" style="float: left; background-color: #4b8df8;" data-toggle="dropdown" href="#">
<span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu" style="min-width: 107px;">
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/?gf_pdf=1&fid=' . $lead->form_id . '&lid=' . $lead->id . '&download=1&template=' . $gfpdf->get_template($lead->form_id) . '"><i class="fa fa-book fa-fw"></i> Get Documents</a></li>
<li><a class="btn-xs" href="https://app.thesmsfacademy.com.au/save-time/?fid=' . $lead->form_id . '"><i class="fa fa-book fa-fw"></i> Reuse Data</a></li>
</ul></div></tr></form>';
}
}
}
$output = '<script src="/scripts/sorttable.js"></script><table class="table table-striped table-bordered table-advance table-hover sortable" style="width:80%!important;"><thead><tr><th>Order ID</th><th>Reference</th><th>Entity</th><th>Type</th><th>Date</th><th>Status</th><th>Actions</th></tr></thead>' . $output . '</table>';
$output = $output . '<form name="gravitylist" action="' . get_action_link($lead->form_id, $lead->id, $wpdb) . '" method="post">
<input type="hidden" id="gform_edit_id" name="gform_edit_id" value="" />
<input type="hidden" id="gform_edit_mode" name="gform_edit_mode" value="" /></form>';
return $output;
}
public static function get_certificates($id)
{
$lead = TemplateData::get_entry_by_lead($id);
$lead = $lead[0];
$lead = json_decode(json_encode($lead), FALSE);
$output = "";
if ($lead->form_id == TemplateData::companyform_id() && $lead->eco_ref != "") {
//is a company incorporation
switch ($lead->asic_status) {
case "Order complete":
$output .= '
<ul class="dropdown-menu" style="min-width: 107px; margin:0 0 0 14px;padding:0 !important">
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getDocs.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-book fa-fw"></i> Documents</a></li>
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getCert.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-certificate fa-fw"></i> Certificate</a></li>
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getCasFile.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-briefcase fa-fw"></i> CAS File</a></tr></li>
</ul>';
break;
case "complete":
$output .= '
<ul class="dropdown-menu" style="min-width: 107px; margin:0 0 0 14px;padding:0 !important;">
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getDocs.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-book fa-fw"></i> Documents</a></li>
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getCert.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-certificate fa-fw"></i> Certificate</a></li>
<li><a class="btn-xs" target="_blank" href="' . site_url() . '/corp/getCasFile.php?orderid=' . $lead->eco_ref . '"><i class="fa fa-briefcase fa-fw"></i> CAS File</a></tr></li>
</ul></form>';
break;
case "Submitted to ASIC Temporarily reserved subject to ASIC decision":
$output .= '<i class="fa fa-refresh fa-spin"></i> ' . $lead->asic_status . ' Processing';
break;
case "Submitted to ASIC":
$output .= '<i class="fa fa-refresh fa-spin"></i> ' . $lead->asic_status . ' Processing';
break;
case "Checks":
//$output .= $lead->asic_status;
$output .= "Processing";
break;
case "Rejected":
$output .= '<button class="btn-danger default btn-xs" style="width: 102px; text-align: left; border:none;" onclick="SetHiddenFormSettingsTPO(' . $lead->id . ', \'update\',\'' . get_action_link($lead->form_id, $lead->id, $wpdb) . '\')"><i class="fa fa-edit"></i> Amend</button>';
break;
case "Failed ASIC validation":
$output .= '<button class="btn-danger default btn-xs" style="width: 102px; text-align: left; border:none;" onclick="SetHiddenFormSettingsTPO(' . $lead->id . ', \'update\',\'' . get_action_link($lead->form_id, $lead->id, $wpdb) . '\')"><i class="fa fa-edit"></i> Amend</button>';
break;
default:
$output .= $lead->asic_status;
}
}
return $output;
}
