WordPress.org
Get WordPress

Plugin Directory

Changeset 1608660


Ignore:
Timestamp:
03/06/2017 12:14:30 PM (9 years ago)
Author:
accreteinfosolution
Message:

Version - 1.1

Location:
appointment-buddy-online-appointment-booking-by-accrete/trunk
Files:
9 edited

Legend:

Unmodified
Added
Removed

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-calendar.php

    r1605128 r1608660  
    7474            selectable: true,
    7575            selectHelper: true,
    76             editable: true,
     76            editable: false,
    7777            eventLimit: true,
    7878            eventRender: function(event, element, view) {

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-general-profile.php

    r1605128 r1608660  
    2929                <tr>
    3030                    <th scope="row"><label for="name">Name</label><span class="star-red"> * </span></th>
    31                     <td><input name="name" id="name" class="regular-text alphaNumeric" type="text" maxlength="50" placeholder="Full Name" value="<?php if($getGeneralProfileResult[0]['name'] != '') { echo stripTextContent($getGeneralProfileResult[0]['name']); } else { echo ''; }?>"></td>
     31                    <td><input name="name" id="name" class="regular-text alphaNumeric" type="text" maxlength="50" placeholder="Full Name" value="<?php if($getGeneralProfileResult[0]['name'] != '') { echo apbud_stripTextContent($getGeneralProfileResult[0]['name']); } else { echo ''; }?>"></td>
    3232                </tr>
    3333                <tr>
    3434                    <th scope="row"><label for="address">Address</label><span class="star-red"> * </span></th>
    3535                    <td>
    36                         <textarea name="address" id="address" class="regular-text" rows="5" cols="50" placeholder="Full Address...."><?php if($getGeneralProfileResult[0]['address'] != '') { echo stripTextContent($getGeneralProfileResult[0]['address']); } else { echo ''; }?></textarea>
     36                        <textarea name="address" id="address" class="regular-text" rows="5" cols="50" placeholder="Full Address...."><?php if($getGeneralProfileResult[0]['address'] != '') { echo apbud_stripTextContent($getGeneralProfileResult[0]['address']); } else { echo ''; }?></textarea>
    3737                    </td>
    3838                </tr>
    … …  
    7878                    <td>
    7979                        <select name="timeZoneValue" id="timeZoneValue" class="regular-text">
    80                         <?php foreach(timeZone_list() as $timeZone) { ?>
     80                        <?php foreach(apbud_timeZone_list() as $timeZone) { ?>
    8181                            <option value="<?php echo $timeZone['zone']; ?>" <?php if( $timeZone['zone'] == $abTimeZone ) { ?> selected="selected" <?php } ?>>
    8282                                <?php echo $timeZone['zone']; ?>

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-holiday.php

    r1605128 r1608660  
    6767                    <tr id="tag-1" onClick="Drow(this)" class="search-fade">
    6868                        <td class="name column-name has-row-actions column-primary" data-colname="Name">
    69                             <span><?php echo stripTextContent($trRes['holidayName']); ?></span>
     69                            <span><?php echo apbud_stripTextContent($trRes['holidayName']); ?></span>
    7070                        </td>
    7171                        <td class="description column-description" data-colname="Description">
    72                             <p><?php echo changeDateToReadableFormatWithoutTime($trRes['holidayDate']); ?></p>
     72                            <p><?php echo apbud_changeDateToReadableFormatWithoutTime($trRes['holidayDate']); ?></p>
    7373                        </td>
    7474                        <?php /*?><td class="edit" data-colname="Edit">

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-list-treatments.php

    r1605128 r1608660  
    4343                    <tr id="tag-1" onClick="Drow(this)" class="search-fade">
    4444                        <td class="name column-name has-row-actions column-primary" data-colname="Name">
    45                             <span><?php echo stripTextContent($trRes['serviceName']); ?></span>
     45                            <span><?php echo apbud_stripTextContent($trRes['serviceName']); ?></span>
    4646                        </td>
    4747                        <td class="description column-description" data-colname="Description">
    48                             <p><?php $content = stripTextContent($trRes['serviceDescription']); echo substr($content, 0, 55)."..."; ?></p>
     48                            <p><?php $content = apbud_stripTextContent($trRes['serviceDescription']); echo substr($content, 0, 55)."..."; ?></p>
    4949                        </td>
    5050                        <td class="edit" data-colname="Edit">

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-time-slot.php

    r1605128 r1608660  
    5858                         <tr class="slot-row" data-slot-id="">
    5959                            <td><strong></strong></td>
    60                             <td><input type="text" name="slotName_" class="inputTimeSlots alphaNumeric" value="<?php if(!empty($result["slotName"])){echo stripTextContent($result["slotName"]);}?>" id="slotName" data-msg="Please select Slot Name" maxlength="20" autocomplete="off"/></td>
     60                            <td><input type="text" name="slotName_" class="inputTimeSlots alphaNumeric" value="<?php if(!empty($result["slotName"])){echo apbud_stripTextContent($result["slotName"]);}?>" id="slotName" data-msg="Please select Slot Name" maxlength="20" autocomplete="off"/></td>
    6161                            <td><input type="text" class="timedropper validateStartTimeSlot inputTimeSlots" name="start_time_slot_" value="<?php if(!empty($result["slotStartTime"])){echo $result["slotStartTime"];}?>"  data-msg="Please select Start Time" autocomplete="off"></td>
    6262                            <td><input type="text" class="timedropper validateEndTimeSlot inputTimeSlots endTimeSlot" name="end_time_slot_" value="<?php if(!empty($result["slotEndTime"])){echo $result["slotEndTime"];}?>" data-msg="Please select End Time" autocomplete="off"></td>

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-treatments.php

    r1605128 r1608660  
    9494                        jQuery('html, body').animate({scrollTop : 0}, 800);
    9595                        setTimeout( function() {
    96                             //location.reload(true);
    97                             jQuery('#displayTreametents').load(document.URL +  ' #displayTreametents');
     96                            location.reload(true);
     97                            //jQuery('#displayTreametents').load(document.URL +  ' #displayTreametents');
    9898                            tabapi.switch(4);
    99                             jQuery('#treatmentsForm').trigger("reset");
    100                             jQuery('#serviceDesc').val('');
     99                            //jQuery('#treatmentsForm').trigger("reset");   
     100                            //jQuery('#serviceDesc').val('');
    101101                        }, 2000);
    102102                    }

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/admin-working-days.php

    r1605128 r1608660  
    6565                    ?>
    6666                    <tr>
    67                         <td><?php if(!empty($result["slotName"])){echo stripTextContent($result["slotName"]);}?>
     67                        <td><?php if(!empty($result["slotName"])){echo apbud_stripTextContent($result["slotName"]);}?>
    6868                        <input type="hidden" id="slotId" name="slotId" value="<?php if(!empty($result["slotId"])){echo $result["slotId"];}?>" data-id="<?php // $final = array_column($fetchWorkingDays,"slotId"); if(in_array($result["slotId"],$final)){echo "true";} ?>"  />
    6969                        </td>

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/admctrlfd/functions.php

    r1605128 r1608660  
    55<?php
    66//VALIDATION FUNCTION
    7 function validateTextarea($data)
     7function apbud_validateTextarea($data)
    88{
    99    global $wpdb;
    … …  
    1313}
    1414
    15 function stripContent($data)
     15function apbud_stripContent($data)
    1616{
    1717    $data=stripslashes(html_entity_decode(stripslashes($data)));
    … …  
    1919}
    2020
    21 function stripTextContent($data)
     21function apbud_stripTextContent($data)
    2222{
    2323    $data=stripslashes(wp_specialchars_decode(stripslashes($data)));
    … …  
    2525}
    2626
    27 function validateTextContent($data)
    28 {
    29     global $wpdb;
    30     $data=$wpdb->_real_escape(esc_attr(sanitize_text_field($data))); //wpdb::_real_escape(esc_attr(sanitize_text_field($data)));
     27function apbud_validateTextContent($data)
     28{
     29    $data=sanitize_text_field($data); //wpdb::_real_escape(esc_attr(sanitize_text_field($data)));
    3130    return $data;
    3231}
    3332
    3433//Date Validation Functions
    35 function changeTimeFormat($timefmt)
     34function apbud_changeTimeFormat($timefmt)
    3635{
    3736    $time = date("g:i a", strtotime($timefmt));
    … …  
    3938}
    4039
    41 function changeDateFormat($dateValue)
     40function apbud_changeDateFormat($dateValue)
    4241{
    4342    $date = date_create($dateValue);
    … …  
    4645}
    4746
    48 function changeDateToReadableFormat($dateValue)
     47function apbud_changeDateToReadableFormat($dateValue)
    4948{
    5049    $date = date_create($dateValue);
    … …  
    5352}
    5453
    55 function changeDateFormatWithoutTime($dateValue)
     54function apbud_changeDateFormatWithoutTime($dateValue)
    5655{   
    5756    $date = date_create($dateValue);
    … …  
    6059}
    6160
    62 function changeDateToReadableFormatWithoutTime($dateValue)
     61function apbud_changeDateToReadableFormatWithoutTime($dateValue)
    6362{
    6463    $date = date_create($dateValue);
    … …  
    6867
    6968//Get IP Address Function
    70 function getIp()
     69function apbud_getIp()
    7170{
    7271    $ip = "";
    … …  
    9392
    9493//function to get time zone
    95 function timeZone_list()
     94function apbud_timeZone_list()
    9695{
    9796    $zones_array = array();
    … …  
    116115    global $wpdb;
    117116   
     117   
    118118    $checkNonce = check_ajax_referer( 'apbud_add_general_profile', 'ajax_nonce' );
     119   
    119120    if($checkNonce)
    120121    { //if-1
    … …  
    122123        parse_str($_POST['stringValues'], $stringValueArray);
    123124       
    124         /*return print_r($stringValueArray);
    125         return print_r($_POST);
     125        /*return print_r($stringValueArray) ."<br>". print_r($_POST);
    126126        die();*/
     127       
    127128        $wp_abAdminProfileDetails = $wpdb->prefix .'abAdminProfileDetails';
    128129        $user = get_current_user_id();
    129         $ip = getIp();     
     130        $ip = apbud_getIp();       
    130131       
    131132        if($stringValueArray['name'] == '')
    … …  
    169170        { //if-2
    170171            //echo "11";
     172           
    171173            $generalProfileArray = array(
    172                 "name" => "".validateTextContent($stringValueArray['name'])."",
    173                 "address" => "".validateTextarea($stringValueArray['address'])."",
     174                "name" => "".apbud_validateTextContent($stringValueArray['name'])."",
     175                "address" => "".apbud_validateTextarea($stringValueArray['address'])."",
    174176                "emailId" => "".sanitize_email($stringValueArray['emailId'])."",
    175                 "mobileNo" => "".validateTextContent($stringValueArray['mobileNo'])."",
    176                 "officePhoneNo" => "".validateTextContent($stringValueArray['officePhoneNo'])."",
     177                "mobileNo" => "".apbud_validateTextContent($stringValueArray['mobileNo'])."",
     178                "officePhoneNo" => "".apbud_validateTextContent($stringValueArray['officePhoneNo'])."",
    177179                "websiteLink" => "".esc_url($stringValueArray['websiteLink'])."",
    178180                "facebookLink" => "".esc_url($stringValueArray['facebookLink'])."",
    … …  
    221223                   
    222224                    $generalProfileUpdateArray = array(
    223                         "name" => "".validateTextContent($stringValueArray['name'])."",
    224                         "address" => "".validateTextarea($stringValueArray['address'])."",
     225                        "name" => "".apbud_validateTextContent($stringValueArray['name'])."",
     226                        "address" => "".apbud_validateTextarea($stringValueArray['address'])."",
    225227                        "emailId" => "".sanitize_email($stringValueArray['emailId'])."",
    226                         "mobileNo" => "".validateTextContent($stringValueArray['mobileNo'])."",
    227                         "officePhoneNo" => "".validateTextContent($stringValueArray['officePhoneNo'])."",
     228                        "mobileNo" => "".apbud_validateTextContent($stringValueArray['mobileNo'])."",
     229                        "officePhoneNo" => "".apbud_validateTextContent($stringValueArray['officePhoneNo'])."",
    228230                        "websiteLink" => "".esc_url($stringValueArray['websiteLink'])."",
    229231                        "facebookLink" => "".esc_url($stringValueArray['facebookLink'])."",
    … …  
    280282        $wp_abServiceMst = $wpdb->prefix .'abServiceMst';   
    281283        $user = get_current_user_id();
    282         $ip = getIp();     
     284        $ip = apbud_getIp();       
    283285       
    284286        if($crudAction == 'addTreatments' || $crudAction == 'updateTreatments')
    … …  
    300302                { //if-2
    301303                    $serviceArray = array(
    302                         "serviceName" => "".validateTextContent($treatmentValueArray['serviceName'])."",
    303                         "serviceDescription" => "".validateTextarea($treatmentValueArray['serviceDesc'])."",
     304                        "serviceName" => "".apbud_validateTextContent($treatmentValueArray['serviceName'])."",
     305                        "serviceDescription" => "".apbud_validateTextarea($treatmentValueArray['serviceDesc'])."",
    304306                        "createdDate" => "".AB_CURRENT_TIMEZONE."",
    305307                        "createdBy" => "".$user."",
    … …  
    336338                           
    337339                            $updateServiceArray = array(
    338                                 "serviceName" => "".validateTextContent($treatmentValueArray['serviceName'])."",
    339                                 "serviceDescription" => "".validateTextarea($treatmentValueArray['serviceDesc'])."",
     340                                "serviceName" => "".apbud_validateTextContent($treatmentValueArray['serviceName'])."",
     341                                "serviceDescription" => "".apbud_validateTextarea($treatmentValueArray['serviceDesc'])."",
    340342                                "modifiedDate" => "".AB_CURRENT_TIMEZONE."",
    341343                                "modifiedBy" => "".$user."",
    … …  
    439441        $wp_abHolidayMst = $wpdb->prefix .'abHolidayMst';
    440442        $user = get_current_user_id();
    441         $ip = getIp();
     443        $ip = apbud_getIp();
    442444       
    443445       
    … …  
    453455            }
    454456               
    455             //echo "Select count(*) from ".$wp_abHolidayMst." where isDeleted=0 AND (holidayDate='".changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."' OR holidayName='".$holidayValueArray['holidayName']."')";
    456             $exists = $wpdb->get_var("Select count(*) from ".$wp_abHolidayMst." where isDeleted=0 AND (holidayDate='".changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."' OR holidayName='".sanitize_text_field($holidayValueArray['holidayName'])."')");
     457            //echo "Select count(*) from ".$wp_abHolidayMst." where isDeleted=0 AND (holidayDate='".apbud_changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."' OR holidayName='".$holidayValueArray['holidayName']."')";
     458            $exists = $wpdb->get_var("Select count(*) from ".$wp_abHolidayMst." where isDeleted=0 AND (holidayDate='".apbud_changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."' OR holidayName='".sanitize_text_field($holidayValueArray['holidayName'])."')");
    457459           
    458460            //echo $exists;
    … …  
    475477                { //if-2
    476478                    $holidayArray = array(
    477                         "holidayName" => "".validateTextContent($holidayValueArray['holidayName'])."",
    478                         "holidayDate" => "".changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."",
     479                        "holidayName" => "".apbud_validateTextContent($holidayValueArray['holidayName'])."",
     480                        "holidayDate" => "".apbud_changeDateFormatWithoutTime($holidayValueArray['holidayDate'])."",
    479481                        "createdDate" => "".AB_CURRENT_TIMEZONE."",
    480482                        "createdBy" => "".$user."",
    … …  
    562564        <tr id="tag-1" onClick="Drow(this)" class="search-fade">
    563565            <td class="name column-name has-row-actions column-primary" data-colname="Name">
    564                 <span><?php echo stripTextContent($trRes['holidayName']); ?></span>
     566                <span><?php echo apbud_stripTextContent($trRes['holidayName']); ?></span>
    565567            </td>
    566568            <td class="description column-description" data-colname="Description">
    567                 <p><?php echo changeDateToReadableFormatWithoutTime($trRes['holidayDate']); ?></p>
     569                <p><?php echo apbud_changeDateToReadableFormatWithoutTime($trRes['holidayDate']); ?></p>
    568570            </td>
    569571            <?php /*?><td class="edit" data-colname="Edit">
    … …  
    604606        $wp_abSlotMappingDetails = $wpdb->prefix .'abSlotMappingDetails';
    605607        $user = get_current_user_id();
    606         $ip = getIp();
     608        $ip = apbud_getIp();
    607609        $currDate = date("Y-m-d H:i:s");
    608610    /************************************************For Multiple Record *****************************************/
    … …  
    631633                $slotMaxApppointments=${"slot_max_appointments_".$i};               
    632634               
    633                 if(validateTextContent($slotName) == "")
     635                if(apbud_validateTextContent($slotName) == "")
    634636                {//if-3 starts
    635637                    return wp_send_json_error("Please enter Slot Name");
    … …  
    660662                        die();*/
    661663                       
    662                         $done = $wpdb->query("update ".$wp_abTimeSlotMst." set slotName='".validateTextContent($slotName)."',slotStartTime='".$startTime."', slotEndTime='".$endTime."',maxAppointmentsPerSlot=".absint($slotMaxApppointments).",modifiedBy='".$user."',modifiedDate='".$currDate."',ipAddress='".$ip."' where slotId=".$exists[0]['slotId']." and
    663 not exists (select slotName from (select * from ".$wp_abTimeSlotMst.") as timeSlotTable where SlotName='".validateTextContent($slotName)."' and slotId <>".$exists[0]['slotId']." and isDeleted=0)");
     664                        $done = $wpdb->query("update ".$wp_abTimeSlotMst." set slotName='".apbud_validateTextContent($slotName)."',slotStartTime='".$startTime."', slotEndTime='".$endTime."',maxAppointmentsPerSlot=".absint($slotMaxApppointments).",modifiedBy='".$user."',modifiedDate='".$currDate."',ipAddress='".$ip."' where slotId=".$exists[0]['slotId']." and
     665not exists (select slotName from (select * from ".$wp_abTimeSlotMst.") as timeSlotTable where SlotName='".apbud_validateTextContent($slotName)."' and slotId <>".$exists[0]['slotId']." and isDeleted=0)");
    664666                        //$lastId = $wpdb->insert_id;
    665667                            if($done==FALSE )
    … …  
    675677                { //Single Record Insert code   
    676678                        $insertArray1 = array(
    677                             'slotName'=>validateTextContent($slotName),
     679                            'slotName'=>apbud_validateTextContent($slotName),
    678680                            'slotStartTime'=>$startTime,
    679681                            'slotEndTime'=>$endTime,
    … …  
    791793        $one = 1;
    792794        $zero = 0;
    793         $ip = getIp();
     795        $ip = apbud_getIp();
    794796        $user = get_current_user_id();
    795797        $crTime = date("Y-m-d H:i:s");
    … …  
    906908        else
    907909        { //else-2
    908             //echo "SELECT smd.slotId, ts.slotName, DATE_FORMAT(ts.slotStartTime, '%H:%i') as slotStartTime, DATE_FORMAT(ts.slotEndTime, '%H:%i') as slotEndTime FROM ".$abSlotMappingDetails." smd INNER JOIN ".$abTimeSlotMst." ts on ts.slotId = smd.slotId And ts.isDeleted=0 where smd.workingDay=".medicinal_validateTextContent($appointmentDay)." And smd.isDeleted=0";
    909 
    910             $getTimeSlotResult = $wpdb->get_results("SELECT count(am.appointmentSlotMappingId) as tapp, am.appointmentDate, smd.workingDay, smd.slotId, smd.slotMappingId, ts.slotName, ts.maxAppointmentsPerSlot, DATE_FORMAT(ts.slotStartTime, '%H:%i') as slotStartTime, DATE_FORMAT(ts.slotEndTime, '%H:%i') as slotEndTime
    911 FROM ".$abSlotMappingDetails." smd
    912 inner join ".$abTimeSlotMst." ts on ts.slotId = smd.slotId And ts.isDeleted=0
    913 left join ".$abAppointmentMst." am on smd.slotId = am.appointmentSlotMappingId and am.appointmentDate = '".changeDateFormatWithoutTime($appointmentDate)."'
    914 where smd.workingDay=".validateTextContent($appointmentDay)." And smd.isDeleted=0
    915 group by am.appointmentDate, ts.slotId, smd.workingDay having tapp < ts.maxAppointmentsPerSlot", ARRAY_A);
    916 
    917             /*$getTimeSlotResult = $wpdb->get_results("SELECT count(am.appointmentSlotMappingId) as tapp, am.appointmentDate, smd.workingDay, smd.slotId, smd.slotMappingId, ts.slotName, ts.maxAppointmentsPerSlot, DATE_FORMAT(ts.slotStartTime, '%H:%i') as slotStartTime, DATE_FORMAT(ts.slotEndTime, '%H:%i') as slotEndTime
    918 FROM wp_abSlotMappingDetails smd
    919 inner join wp_abTimeSlotMst ts on ts.slotId = smd.slotId And ts.isDeleted=0
    920 left join wp_abAppointmentMst am on smd.slotId = am.appointmentSlotMappingId and am.appointmentDate = '".medicinal_changeDateFormatWithoutTime($appointmentDate)."'
    921 where smd.workingDay=".medicinal_validateTextContent($appointmentDay)." And smd.isDeleted=0
    922 group by am.appointmentDate, smd.slotId, smd.workingDay having tapp < ts.maxAppointmentsPerSlot", ARRAY_A);*/
    923            
     910           
     911            /*echo "SELECT am.appointmentDate, count(am.appointmentSlotMappingId) AS tapp, smd.workingDay, smd.slotId, smd.slotMappingId, ts.slotName, ts.maxAppointmentsPerSlot, DATE_FORMAT(ts.slotStartTime, '%H:%i') as slotStartTime, DATE_FORMAT(ts.slotEndTime, '%H:%i') as slotEndTime
     912from ".$abSlotMappingDetails." smd
     913inner join ".$abTimeSlotMst." ts on ts.slotId = smd.slotId and ts.isDeleted=0
     914left join ".$abAppointmentMst." am on am.appointmentSlotMappingId = smd.slotMappingId and am.appointmentDate = '".apbud_changeDateFormatWithoutTime($appointmentDate)."'
     915where smd.workingDay=".apbud_validateTextContent($appointmentDay)." and smd.isDeleted=0
     916group by am.appointmentDate, ts.slotId, smd.workingDay
     917having tapp < ts.maxAppointmentsPerSlot";
     918            die();*/
     919           
     920            $getTimeSlotResult = $wpdb->get_results("SELECT am.appointmentDate, count(am.appointmentSlotMappingId) AS tapp, smd.workingDay, smd.slotId, smd.slotMappingId, ts.slotName, ts.maxAppointmentsPerSlot, DATE_FORMAT(ts.slotStartTime, '%H:%i') as slotStartTime, DATE_FORMAT(ts.slotEndTime, '%H:%i') as slotEndTime
     921from ".$abSlotMappingDetails." smd
     922inner join ".$abTimeSlotMst." ts on ts.slotId = smd.slotId and ts.isDeleted=0
     923left join ".$abAppointmentMst." am on am.appointmentSlotMappingId = smd.slotMappingId and am.appointmentDate = '".apbud_changeDateFormatWithoutTime($appointmentDate)."'
     924where smd.workingDay=".apbud_validateTextContent($appointmentDay)." and smd.isDeleted=0
     925group by am.appointmentDate, ts.slotId, smd.workingDay
     926having tapp < ts.maxAppointmentsPerSlot", ARRAY_A);
     927
    924928            if(!$getTimeSlotResult)
    925929            {
    … …  
    986990        $abAdminProfileDetails = $wpdb->prefix .'abAdminProfileDetails';
    987991        $abHolidayMst = $wpdb->prefix .'abHolidayMst';
     992        $abSlotMappingDetails = $wpdb->prefix . "abSlotMappingDetails";
     993        $abTimeSlotMst = $wpdb->prefix . "abTimeSlotMst";
    988994       
    989995        $user = get_current_user_id();
    990         $ip = getIp();     
     996        $ip = apbud_getIp();       
    991997       
    992998        if($dataStringArray['appointmentDate'] == '')
    … …  
    10151021        }
    10161022       
    1017         $holidayResult = $wpdb->get_results("SELECT holidayName FROM ".$abHolidayMst." where holidayDate='".changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'");
     1023        $holidayResult = $wpdb->get_results("SELECT holidayName FROM ".$abHolidayMst." where holidayDate='".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'");
    10181024        if(!empty($holidayResult))
    10191025        {
    … …  
    10451051            }
    10461052        }
    1047     //  echo "SELECT count(appointmentId) FROM ".$abAppointmentMst." WHERE isDeleted=0 AND personEmailId = '".sanitize_email($dataStringArray['personEmailId'])."' AND personMobileNo = '".validateTextContent($dataStringArray['personMobileNo'])."' AND appointmentDate = '".changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'";
    1048            
    1049         $exists = $wpdb->get_var("SELECT count(appointmentId) FROM ".$abAppointmentMst." WHERE isDeleted=0 AND personEmailId = '".sanitize_email($dataStringArray['personEmailId'])."' AND personMobileNo = '".validateTextContent($dataStringArray['personMobileNo'])."' AND appointmentDate = '".changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'");
     1053           
     1054        $exists = $wpdb->get_var("SELECT count(appointmentId) FROM ".$abAppointmentMst." WHERE isDeleted=0 AND personEmailId = '".sanitize_email($dataStringArray['personEmailId'])."' AND personMobileNo = '".apbud_validateTextContent($dataStringArray['personMobileNo'])."' AND appointmentDate = '".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'");
     1055       
     1056        $getTimeSlotRes = $wpdb->get_results("SELECT count(am.appointmentSlotMappingId) AS tapp, ts.maxAppointmentsPerSlot, smd.slotMappingId
     1057from ".$abSlotMappingDetails." smd
     1058inner join ".$abTimeSlotMst." ts on ts.slotId = smd.slotId and ts.isDeleted=0
     1059left join ".$abAppointmentMst." am on am.appointmentSlotMappingId = smd.slotMappingId and am.appointmentDate = '".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'
     1060where smd.isDeleted=0 and smd.workingDay=DATE_FORMAT('".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."', '%w') and smd.slotMappingId = '".$dataStringArray['appointmentSlotMappingId']."'
     1061group by am.appointmentDate, ts.slotId
     1062having tapp < ts.maxAppointmentsPerSlot", ARRAY_A);
     1063
     1064        /*echo "SELECT count(am.appointmentSlotMappingId) AS tapp, ts.maxAppointmentsPerSlot, smd.slotMappingId
     1065from ".$abSlotMappingDetails." smd
     1066inner join ".$abTimeSlotMst." ts on ts.slotId = smd.slotId and ts.isDeleted=0
     1067left join ".$abAppointmentMst." am on am.appointmentSlotMappingId = smd.slotMappingId and am.appointmentDate = '".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."'
     1068where smd.isDeleted=0 and smd.workingDay=DATE_FORMAT('".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."', '%w') and smd.slotMappingId = '".$dataStringArray['appointmentSlotMappingId']."'
     1069group by am.appointmentDate, ts.slotId
     1070having tapp < ts.maxAppointmentsPerSlot";
     1071
     1072        die();*/
    10501073       
    10511074        if($exists > 0)
    10521075        { //if-5
    10531076            return wp_send_json_error("Sorry !! You have already booked appointment for ".$dataStringArray['appointmentDate']);
     1077        }
     1078        else if(!$getTimeSlotRes)
     1079        {
     1080            return wp_send_json_error("You have selected wrong time slot.");
    10541081        }
    10551082        else
    10561083        {   
    10571084            $appointmentArray = array(
    1058                 "personName" => "".validateTextContent($dataStringArray['personName'])."",
     1085                "personName" => "".apbud_validateTextContent($dataStringArray['personName'])."",
    10591086                "personEmailId" => "".sanitize_email($dataStringArray['personEmailId'])."",
    1060                 "personMobileNo" => "".validateTextContent($dataStringArray['personMobileNo'])."",
    1061                 "personAddress" => "".validateTextarea($dataStringArray['personAddress'])."",
     1087                "personMobileNo" => "".apbud_validateTextContent($dataStringArray['personMobileNo'])."",
     1088                "personAddress" => "".apbud_validateTextarea($dataStringArray['personAddress'])."",
    10621089                "serviceId" => "".sanitize_text_field($dataStringArray['serviceId'])."",
    1063                 "appointmentDate" => "".changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."",
     1090                "appointmentDate" => "".apbud_changeDateFormatWithoutTime($dataStringArray['appointmentDate'])."",
    10641091                "appointmentSlotMappingId" => "".sanitize_text_field($dataStringArray['appointmentSlotMappingId'])."",
    1065                 "remarks" => "".validateTextarea($dataStringArray['remarks'])."",
     1092                "remarks" => "".apbud_validateTextarea($dataStringArray['remarks'])."",
    10661093                "createdDate" => "".AB_CURRENT_TIMEZONE."",
    10671094                "createdBy" => "".$user."",

  • appointment-buddy-online-appointment-booking-by-accrete/trunk/includes/form.php

    r1605128 r1608660  
    2828if(!empty($minDate) && !empty($maxDate))
    2929{//if-2 starts
    30     $holidayResult = $wpdb->get_results("SELECT DATE_FORMAT(holidayDate,'%d-%m-%Y') as holidayDate FROM ".$abHolidayMst." WHERE holidayDate BETWEEN '".changeDateFormatWithoutTime($minDate)."' AND '".changeDateFormatWithoutTime($maxDate)."' AND isDeleted=0",ARRAY_A);
     30    $holidayResult = $wpdb->get_results("SELECT DATE_FORMAT(holidayDate,'%d-%m-%Y') as holidayDate FROM ".$abHolidayMst." WHERE holidayDate BETWEEN '".apbud_changeDateFormatWithoutTime($minDate)."' AND '".apbud_changeDateFormatWithoutTime($maxDate)."' AND isDeleted=0",ARRAY_A);
    3131    $holidayArray=array();
    3232        if($holidayResult)
    … …  
    167167        var newDate=appointDate2[1]+","+appointDate2[0]+","+appointDate2[2];
    168168        var getSelectedDay = new Date(newDate).getDay();
    169         console.log(getSelectedDay);
    170         console.log(appointDate);
     169        //console.log(getSelectedDay);
     170        //console.log(appointDate);
    171171        //alert(getSelectedDay);
    172172       
    … …  
    280280            }, 
    281281            submitHandler:function(){
     282               
    282283                jQuery.ajax({
    283                 type: "post",
    284                 url:'<?php echo apbud_AJAX_URL; ?>',
    285                 data: {
    286                     action: 'apbud_add_appointments',
    287                     dataString: jQuery('#bookingForm').serialize() ,
    288                     ajax_nonce: '<?php echo wp_create_nonce('apbud_add_appointments'); ?>'
    289                 },
    290                 dataType: 'html',
    291                 success: function(response){ //so, if data is retrieved, store it in html
    292                 /*  var result=JSON.parse(response); */
    293                 //  alert(response);
    294                     //alert(JSON.stringify(response));
    295                     if(jQuery.parseJSON(response).success === false)
    296                     {
    297                         abAlertMessage(response);
     284                    type: "post",
     285                    url:'<?php echo apbud_AJAX_URL; ?>',
     286                    data: {
     287                        action: 'apbud_add_appointments',
     288                        dataString: jQuery('#bookingForm').serialize() ,
     289                        ajax_nonce: '<?php echo wp_create_nonce('apbud_add_appointments'); ?>'
     290                    },
     291                    dataType: 'html',
     292                    success: function(response){ //so, if data is retrieved, store it in html
     293                    /*  var result=JSON.parse(response); */
     294                    //  alert(response);
     295                        //alert(JSON.stringify(response));
     296                        if(jQuery.parseJSON(response).success === false)
     297                        {
     298                            abAlertMessage(response);
     299                        }
     300                        else
     301                        {
     302                            abAlertMessage(response);
     303                            setTimeout(function() {
     304                                //window.location.reload(true);
     305                                jQuery("#bookingForm").trigger('reset');
     306                            }, 2000);
     307                        }
    298308                    }
    299                     else
    300                     {
    301                         abAlertMessage(response);
    302                         setTimeout(function() {
    303                             //window.location.reload(true);
    304                             jQuery("#bookingForm").trigger('reset');
    305                         }, 2000);
    306                     }
    307                 }
    308             }); //close jQuery.ajax
     309                }); //close jQuery.ajax
    309310            }
    310311    });
Note: See TracChangeset for help on using the changeset viewer.