Skip to content

Instantly share code, notes, and snippets.

@bungard
Created February 25, 2015 04:40
Show Gist options
  • Save bungard/c8bba9e052c3c24c43f5 to your computer and use it in GitHub Desktop.
Save bungard/c8bba9e052c3c24c43f5 to your computer and use it in GitHub Desktop.
$query_select = "select lead.id ";
$query_from = "";
$query_where = " where lead.form_id = $form_id";
$query_order = "";
if(!empty($orderby_field))
$query_order = " ORDER BY " . preg_replace("([^0-9A-Za-z_])","",$orderby_field[0]["label"]) . ".value desc ";
$query_from .= " from wp_rg_lead lead
INNER JOIN wp_rg_lead_detail approval on lead.form_id = approval.form_id and lead.id = approval.lead_id
and CAST(approval.field_number as DECIMAL(5,1)) = " . $approval_field[0]["column"] . " and approval.value = 'Approved' ";
foreach($header_fields as $field)
{
$field_name = preg_replace("([^0-9A-Za-z_])","",$field["label"]);
$query_select .= "," . $field_name . ".value as " . $field_name . " ";
$query_from .= " LEFT JOIN wp_rg_lead_detail " . $field_name . " on lead.form_id = $field_name.form_id and lead.id = $field_name.lead_id and $field_name.field_number = " . $field["id"];
}
$query = $query_select . " " . $query_from . " " . $query_where . " " . $query_order;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment