Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function buildorprojects_ajax(){
- global $wpdb;
- $sendingclienturn_js = $_POST['sendingclienturn_js'];
- $query_buildsorprojects = $wpdb->get_results(
- "
- SELECT *
- FROM wp_crm_bplist
- WHERE clienturn = '$sendingclienturn_js'
- AND deleted <> '1'
- ORDER BY buildorproject, recorddateandtime DESC
- "
- );
- if($query_buildsorprojects===FALSE){
- echo "Error";
- }
- else {
- foreach ( $query_buildsorprojects as $query_buildorproject ) {
- $aaa= '<option class="filterable_option" value="'.$query_buildorproject->recordurn.'" data-clienturn="'.$query_buildorproject->clienturn.'">'.$query_buildorproject->buildprojecturn.' - '.$query_buildorproject->buildorproject.' ('.$query_buildorproject->buildorprojecttype.')</option>';
- }
- }
- ////////////////////////////////////////////////////////////////
- $query_penultimateratings = $wpdb->get_results(
- "
- SELECT *
- FROM wp_crm_aclist
- WHERE clienturn='$sendingclienturn_js'
- AND deleted <> 1
- ORDER BY recorddateandtime DESC
- LIMIT 1
- "
- );
- if($query_penultimateratings===FALSE){
- echo "Error";
- }
- else {
- foreach ( $query_penultimateratings as $query_penultimaterating ){
- $bbb = $query_penultimaterating->prospectstrength;
- }
- }
- $aaabbb=array($aaa,$bbb);
- return $aaabbb;
- ////////////////////////////////////////////////////////////////
- die();
- }
- add_action('wp_ajax_buildorprojects_ajax', 'buildorprojects_ajax');
- add_action('wp_ajax_nopriv_buildorprojects_ajax', 'buildorprojects_ajax');
Advertisement
Add Comment
Please, Sign In to add comment