Changeset 2029178
- Timestamp:
- 02/12/2019 11:24:35 AM (7 years ago)
- Location:
- callsheet
- Files:
-
- 5 edited
-
tags/1.0.1/admin/js/callsheet-admin.js (modified) (8 diffs)
-
tags/1.0.1/callsheet.php (modified) (6 diffs)
-
trunk/admin/js/callsheet-admin.js (modified) (8 diffs)
-
trunk/admin/partials/callsheet-values.php (modified) (1 diff)
-
trunk/callsheet.php (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
callsheet/tags/1.0.1/admin/js/callsheet-admin.js
r2018320 r2029178 621 621 cur_url = updateQueryStringParameter(cur_url, 'client_id', client_id); 622 622 */ 623 623 624 var client_id = control_vars.client_id; 624 625 625 626 //jQuery('#on_air_title').suggest(control_vars.admin_url +'?action=get_on_air_names&name='+name+'&client_id='+client_id); 626 627 jQuery('#on_air_title').autocomplete({ 627 628 search: function (event,ui) {629 window.pageIndex = 0;630 631 },632 response: function(data,ui){633 /*jQuery('#on_air_role').removeAttr('disabled');634 jQuery('#on_air_director').removeAttr('disabled');635 jQuery('#on_air_channel').removeAttr('disabled'); */636 },637 628 source: function(name, response) { 629 638 630 jQuery.ajax({ 639 640 data: {action:'get_on_air_names',name:name ,client_id:client_id},631 url: control_vars.admin_url, 632 data: {action:'get_on_air_names',name:name.term,client_id:client_id}, 641 633 type: 'post', 642 url: control_vars.admin_url,643 634 success: function(data) { 644 635 response(JSON.parse(data)); … … 694 685 jQuery.ajax({ 695 686 696 data: {action:'get_on_air_names',name:name ,client_id:client_id},687 data: {action:'get_on_air_names',name:name.term,client_id:client_id}, 697 688 type: 'post', 698 689 url: control_vars.admin_url, … … 919 910 jQuery.ajax({ 920 911 921 data: {action:'get_listing_names',name:name ,client_id:client_id},912 data: {action:'get_listing_names',name:name.term,client_id:client_id}, 922 913 type: 'post', 923 914 url: control_vars.admin_url, … … 1006 997 jQuery.ajax({ 1007 998 1008 data: {action:'get_listing_names',name:name ,client_id:client_id},999 data: {action:'get_listing_names',name:name.term,client_id:client_id}, 1009 1000 type: 'post', 1010 1001 url: control_vars.admin_url, … … 1244 1235 jQuery.ajax({ 1245 1236 1246 data: {action:'get_on_stage_names',name:name ,client_id:client_id},1237 data: {action:'get_on_stage_names',name:name.term,client_id:client_id}, 1247 1238 type: 'post', 1248 1239 url: control_vars.admin_url, … … 1296 1287 jQuery.ajax({ 1297 1288 1298 data: {action:'get_on_stage_names',name:name ,client_id:client_id},1289 data: {action:'get_on_stage_names',name:name.term,client_id:client_id}, 1299 1290 type: 'post', 1300 1291 url: control_vars.admin_url, … … 1646 1637 jQuery.ajax({ 1647 1638 1648 data: {action:'get_at_fest_names',name:name ,client_id:client_id},1639 data: {action:'get_at_fest_names',name:name.term,client_id:client_id}, 1649 1640 type: 'post', 1650 1641 url: control_vars.admin_url, … … 1703 1694 jQuery.ajax({ 1704 1695 1705 data: {action:'get_at_fest_names',name:name ,client_id:client_id},1696 data: {action:'get_at_fest_names',name:name.term,client_id:client_id}, 1706 1697 type: 'post', 1707 1698 url: control_vars.admin_url, -
callsheet/tags/1.0.1/callsheet.php
r2021017 r2029178 3760 3760 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3761 3761 3762 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3762 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3763 3763 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); 3764 3764 global $wpdb; 3765 3765 $tv_master = $wpdb->prefix.'call_sheet_tv'; 3766 3767 $qry_str = $wpdb->prepare("SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%'); 3766 $film_master = $wpdb->prefix.'call_sheet_film'; 3767 $qry_str = $wpdb->prepare("SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s 3768 UNION ALL 3769 SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s",$client_id,'%'.$termarr.'%',$client_id,'%'.$termarr.'%'); 3768 3770 $get_data = $wpdb->get_results($qry_str); 3769 3771 $a_json = array(); … … 3787 3789 //autocomplete of on-screen, on-air 3788 3790 function callsheet_get_on_air_names() { 3791 global $wpdb; 3789 3792 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3790 3791 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3793 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3792 3794 3793 3795 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); 3794 global $wpdb;3795 3796 $film_master = $wpdb->prefix.'call_sheet_film'; 3796 3797 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s",$client_id,'%'.$term.'%'); 3797 $tv_master = $wpdb->prefix.'call_sheet_tv'; 3798 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s 3799 UNION ALL 3800 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$termarr .'%',$client_id,'%'.$termarr.'%'); 3801 3798 3802 $get_data = $wpdb->get_results($qry_str); 3803 3799 3804 $a_json = array(); 3800 3805 $a_json_row = array(); … … 3820 3825 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3821 3826 3822 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3827 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3823 3828 3824 3829 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); … … 3826 3831 $theater_master = $wpdb->prefix.'call_sheet_theater'; 3827 3832 3828 $qry_str = $wpdb->prepare("SELECT client_id,title as name,role,director,theater FROM $theater_master WHERE client_id=%d and title LIKE %s",$client_id,'%'.$term .'%');3833 $qry_str = $wpdb->prepare("SELECT client_id,title as name,role,director,theater FROM $theater_master WHERE client_id=%d and title LIKE %s",$client_id,'%'.$termarr.'%'); 3829 3834 $get_data = $wpdb->get_results($qry_str); 3830 3835 $a_json = array(); … … 3850 3855 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3851 3856 3852 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3857 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3853 3858 3854 3859 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); … … 3859 3864 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s 3860 3865 UNION ALL 3861 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%',$client_id,'%'.$term .'%');3866 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%',$client_id,'%'.$termarr.'%'); 3862 3867 $get_data = $wpdb->get_results($qry_str); 3863 3868 $foods = array(); -
callsheet/trunk/admin/js/callsheet-admin.js
r2018320 r2029178 621 621 cur_url = updateQueryStringParameter(cur_url, 'client_id', client_id); 622 622 */ 623 623 624 var client_id = control_vars.client_id; 624 625 625 626 //jQuery('#on_air_title').suggest(control_vars.admin_url +'?action=get_on_air_names&name='+name+'&client_id='+client_id); 626 627 jQuery('#on_air_title').autocomplete({ 627 628 search: function (event,ui) {629 window.pageIndex = 0;630 631 },632 response: function(data,ui){633 /*jQuery('#on_air_role').removeAttr('disabled');634 jQuery('#on_air_director').removeAttr('disabled');635 jQuery('#on_air_channel').removeAttr('disabled'); */636 },637 628 source: function(name, response) { 629 638 630 jQuery.ajax({ 639 640 data: {action:'get_on_air_names',name:name ,client_id:client_id},631 url: control_vars.admin_url, 632 data: {action:'get_on_air_names',name:name.term,client_id:client_id}, 641 633 type: 'post', 642 url: control_vars.admin_url,643 634 success: function(data) { 644 635 response(JSON.parse(data)); … … 694 685 jQuery.ajax({ 695 686 696 data: {action:'get_on_air_names',name:name ,client_id:client_id},687 data: {action:'get_on_air_names',name:name.term,client_id:client_id}, 697 688 type: 'post', 698 689 url: control_vars.admin_url, … … 919 910 jQuery.ajax({ 920 911 921 data: {action:'get_listing_names',name:name ,client_id:client_id},912 data: {action:'get_listing_names',name:name.term,client_id:client_id}, 922 913 type: 'post', 923 914 url: control_vars.admin_url, … … 1006 997 jQuery.ajax({ 1007 998 1008 data: {action:'get_listing_names',name:name ,client_id:client_id},999 data: {action:'get_listing_names',name:name.term,client_id:client_id}, 1009 1000 type: 'post', 1010 1001 url: control_vars.admin_url, … … 1244 1235 jQuery.ajax({ 1245 1236 1246 data: {action:'get_on_stage_names',name:name ,client_id:client_id},1237 data: {action:'get_on_stage_names',name:name.term,client_id:client_id}, 1247 1238 type: 'post', 1248 1239 url: control_vars.admin_url, … … 1296 1287 jQuery.ajax({ 1297 1288 1298 data: {action:'get_on_stage_names',name:name ,client_id:client_id},1289 data: {action:'get_on_stage_names',name:name.term,client_id:client_id}, 1299 1290 type: 'post', 1300 1291 url: control_vars.admin_url, … … 1646 1637 jQuery.ajax({ 1647 1638 1648 data: {action:'get_at_fest_names',name:name ,client_id:client_id},1639 data: {action:'get_at_fest_names',name:name.term,client_id:client_id}, 1649 1640 type: 'post', 1650 1641 url: control_vars.admin_url, … … 1703 1694 jQuery.ajax({ 1704 1695 1705 data: {action:'get_at_fest_names',name:name ,client_id:client_id},1696 data: {action:'get_at_fest_names',name:name.term,client_id:client_id}, 1706 1697 type: 'post', 1707 1698 url: control_vars.admin_url, -
callsheet/trunk/admin/partials/callsheet-values.php
r2021610 r2029178 1 1 <?php 2 echo 'test'; die;3 2 global $wpdb; 4 3 $tags_master = $wpdb->prefix.'call_sheet_tags_master'; -
callsheet/trunk/callsheet.php
r2021017 r2029178 3760 3760 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3761 3761 3762 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3762 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3763 3763 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); 3764 3764 global $wpdb; 3765 3765 $tv_master = $wpdb->prefix.'call_sheet_tv'; 3766 3767 $qry_str = $wpdb->prepare("SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%'); 3766 $film_master = $wpdb->prefix.'call_sheet_film'; 3767 $qry_str = $wpdb->prepare("SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s 3768 UNION ALL 3769 SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s",$client_id,'%'.$termarr.'%',$client_id,'%'.$termarr.'%'); 3768 3770 $get_data = $wpdb->get_results($qry_str); 3769 3771 $a_json = array(); … … 3787 3789 //autocomplete of on-screen, on-air 3788 3790 function callsheet_get_on_air_names() { 3791 global $wpdb; 3789 3792 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3790 3791 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3793 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3792 3794 3793 3795 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); 3794 global $wpdb;3795 3796 $film_master = $wpdb->prefix.'call_sheet_film'; 3796 3797 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s",$client_id,'%'.$term.'%'); 3797 $tv_master = $wpdb->prefix.'call_sheet_tv'; 3798 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s 3799 UNION ALL 3800 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$termarr .'%',$client_id,'%'.$termarr.'%'); 3801 3798 3802 $get_data = $wpdb->get_results($qry_str); 3803 3799 3804 $a_json = array(); 3800 3805 $a_json_row = array(); … … 3820 3825 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3821 3826 3822 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3827 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3823 3828 3824 3829 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); … … 3826 3831 $theater_master = $wpdb->prefix.'call_sheet_theater'; 3827 3832 3828 $qry_str = $wpdb->prepare("SELECT client_id,title as name,role,director,theater FROM $theater_master WHERE client_id=%d and title LIKE %s",$client_id,'%'.$term .'%');3833 $qry_str = $wpdb->prepare("SELECT client_id,title as name,role,director,theater FROM $theater_master WHERE client_id=%d and title LIKE %s",$client_id,'%'.$termarr.'%'); 3829 3834 $get_data = $wpdb->get_results($qry_str); 3830 3835 $a_json = array(); … … 3850 3855 $termarr = filter_var($_POST['name'],FILTER_SANITIZE_STRING); 3851 3856 3852 $term = filter_var($termarr['term'], FILTER_SANITIZE_STRING);3857 //$term = filter_var($termarr['term'], FILTER_SANITIZE_STRING); 3853 3858 3854 3859 $client_id = filter_var($_POST['client_id'],FILTER_VALIDATE_INT); … … 3859 3864 $qry_str = $wpdb->prepare("SELECT client_id,film as name,role,director,channel FROM $film_master WHERE client_id=%d and film LIKE %s 3860 3865 UNION ALL 3861 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%',$client_id,'%'.$term .'%');3866 SELECT client_id,tv as name,role,director,channel FROM $tv_master WHERE client_id=%d and tv LIKE %s",$client_id,'%'.$term.'%',$client_id,'%'.$termarr.'%'); 3862 3867 $get_data = $wpdb->get_results($qry_str); 3863 3868 $foods = array();
Note: See TracChangeset
for help on using the changeset viewer.