functions.php

<?php
/*
 WARNING: DO NOT edit this file under any circumstances.
 Please do all PHP modifications via the Custom Code admin menu.
*/

/**
 * This file calls the init.php file for both Genesis and Prose.
 *
 * It initializes the Genesis framework, and loads the Prose library as well.
 *
 * This file is a core Prose file and should not be edited.
 *
 * @author   StudioPress
 * @license  http://www.opensource.org/licenses/gpl-license.php GPL v2.0 (or later)
 * @link     http://www.studiopress.com/themes/genesis
 */

/** Start the engine */
require_once( get_template_directory() . '/lib/init.php' );
require_once( get_stylesheet_directory() . '/lib/init.php' );

prose_create_custom_php();

if (!current_user_can('delete_others_pages'))
{
    show_admin_bar(false);
}

/* Sent Quiz Results */
add_filter( 'qmn_end_results', 'sendQuizResults', 10, 3 );
function sendQuizResults( $content, $options, $results )
{
    if($results["quiz_id"] == 2 && $results["total_score"] >= 80)
    {
        // MySQL Server Setup
        $servername = "127.0.0.1";
        $username = "root";
        $password = "admin4sql!";
        $databasename = "employee_database";

        //Create a connection to the server
        $conn = new mysqli($servername, $username, $password, $databasename);

        //Check Connection
        if($conn->connect_error)
        {
            die("Connection Failed: " . $conn->connect_error);
        }

        //Get the User Object
        $curUser = get_userdata($results["user_id"]);

        //Get Employee ID Number
        $sql = "SELECT employeeID from employees WHERE username='$curUser->user_login'";
        $result = $conn->query($sql);
        $row = $result->fetch_assoc();
        $empID = $row['employeeID'];
        $totalScore = $results["total_score"];

        $sql = "INSERT INTO employee_quizes (empID, quizID, totalScore) VALUES ('$empID', 1, '$totalScore'); ";
        $result = $conn->query($sql);
    }

return $content;

}


/* Remove Termination Entry Data */
add_action( 'gform_after_submission_60', 'remove_form_entry' );
function remove_form_entry( $entry )
{
    if(strcasecmp($entry['3'], 'Termination') == 0)
    {
        GFAPI::delete_entry($entry['id']);
    }
}

/* Update Provider Wait Time */
add_action('gform_after_submission_27', 'importTrainingCertificates', 10, 2);
function importTrainingCertificates($entry, $form)
{
    //$postURL = 'http://requestb.in/19x8l3r1';
    $postURL = 'http://intranet/employeedb/importTrainingCertificates.php';

    $body = array(
        'email' => $entry['5'],
        'trainingType' => $entry['2']);

    $request = new WP_Http();
    $response = $request->post($postURL, array('body' => $body));
}

/* Send MDM Email Upon Approval */
add_action('gravityflow_workflow_complete', 'mdmAgreementComplete', 10, 3);
function mdmAgreementComplete( $entry_id, $form, $final_status )
{
    $entry = GFAPI::get_entry( $entry_id );
    if(7 == $form['id'] && strcasecmp($final_status, 'approved') == 0)
    {
        $method = rgar($entry, '13');

        if(strcasecmp($method, 'E-Mail') == 0)
        {
            /* Grab Data From From */
            $email = rgar($entry, '14');

            /* Configure Recipient Settings */
            $to = $email;
            $subject = 'SacENT MDM';
            $headers = 'From: Helpdesk <support@sacent.com>' . "\r\n";
            $headers .= 'Content-type: text/html;';

            /* Build Message to send */
            $message = "http://sacent.co/MDMEnroll <br />";
        }
        else
        {
            /* Sanatize Cell Phone Number*/
            $cellPhone = rgar($entry, '7');
            $cellPhone = str_replace('(', '', $cellPhone);
            $cellPhone = str_replace(')', '', $cellPhone);
            $cellPhone = str_replace(' ', '', $cellPhone);
            $cellPhone = str_replace('-', '', $cellPhone);

            /* Get Mobile Carrier Information */
            $mobileCarrier = rgar($entry, '5');
            if(strcasecmp($mobileCarrier, 'other') == 0)
            {
                $mobileCarrier = rgar($entry, '9');
                /* Remove any unwanted characters */
                $mobileCarrier = str_replace('@', '', $mobileCarrier);
                $mobileCarrier = str_replace('0', '', $mobileCarrier);
                $mobileCarrier = str_replace('1', '', $mobileCarrier);
                $mobileCarrier = str_replace('2', '', $mobileCarrier);
                $mobileCarrier = str_replace('3', '', $mobileCarrier);
                $mobileCarrier = str_replace('4', '', $mobileCarrier);
                $mobileCarrier = str_replace('5', '', $mobileCarrier);
                $mobileCarrier = str_replace('6', '', $mobileCarrier);
                $mobileCarrier = str_replace('7', '', $mobileCarrier);
                $mobileCarrier = str_replace('8', '', $mobileCarrier);
                $mobileCarrier = str_replace('9', '', $mobileCarrier);
            }

            /* Configure Recipient Settings */
            $to = $cellPhone . '@' . $mobileCarrier;
            $subject = 'SacENT MDM';
            $headers = 'From: Helpdesk <support@sacent.com>' . "\r\n";
            $headers .= 'Content-type: text/html;';

            /* Build Message to send */
            //$message = "THIS TEST";
            $message = "http://www.sacent.co/MDMEnroll      ";
            //$message = "Cell Phone: " . $cellPhone . "<br />";
            //$message .= "Mobile Carrier: " . $mobileCarrier . "<br />";
        }

        mail($to, $subject, $message, $headers);
    }
}

/* Send Order Info*/
add_action('gform_after_submission_52', 'storeOrderInfo', 10, 2);
function storeOrderInfo($entry, $form)
{
    $firstName = $entry['1.3'];
    $lastName = $entry['1.6'];
    $email = $entry['3'];
    $vendor = $entry['5'];
    $location = $entry['8'];
    $items = $entry['4'];
    $orderNum = $entry['15'];
    $otherVendor = $entry['6'];
    $otherVendorWeb = $entry['9'];

    //$postURL = 'https://hookb.in/KlOM3B4l';
    $postURL = 'http://intranet/employeedb/poReqForm.php';
    $body = array(
        'firstName' => $firstName,
        'lastName' => $lastName,
        'email' => $email,
        'vendor' => $vendor,
        'location' => $location,
        'items' => $items,
        'orderNum' => $orderNum,
        'otherVendor' => $otherVendor,
        'otherVendorWeb' => $otherVendorWeb);

    $request = new WP_Http();
    $response = $request->post($postURL, array('body' => $body));
}

add_filter( 'gform_pre_render_52', 'populateVendors' );
add_filter( 'gform_pre_validation_52', 'populateVendors' );
add_filter( 'gform_pre_submission_filter_52', 'populateVendors' );
add_filter( 'gform_admin_pre_render_52', 'populateVendors' );
function populateVendors( $form )
{

    foreach ( $form['fields'] as &$field )
    {
        if ($field->id == 5)
        {
            /* MySQL Server Setup */
            $servername = "127.0.0.1";
            $username = "root";
            $password = "admin4sql!";
            $databasename = "sent_purchaseorders";

            /* Create a connection to the server */
            $conn = new mysqli($servername, $username, $password, $databasename);

            /* Check Connection */
            if($conn->connect_error)
            {
                die("Connection Failed: " . $conn->connect_error);
            }

            $sql = "SELECT * FROM vendors;";
            $result = $conn->query($sql);
            $choices = array();
            if($result->num_rows > 0)
            {
                while($row = $result->fetch_assoc())
                {
                    if(strcasecmp($row['id'], '3') == 0)
                    {
                        continue;
                    }
                    $choices[] = array('text' => $row['name'], 'value' => $row['id']);
                }
            }

            $choices[] = array('text' => 'Other', 'value' => '3');
            $field->placeholder = 'Select a Vendor';
            $field->choices = $choices;
        }
    }

    return $form;
}

/* Update PO Number */
add_action('gravityflow_step_complete', 'poReqForm', 10, 4);
function poReqForm($step_id, $entry_id, $form_id, $status)
{
    $entry = GFAPI::get_entry( $entry_id );

    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_purchaseorders";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }

    if($step_id == 135)
    {
        $orderNum = $entry['15'];
        $poNum = $entry['16'];

        $sql = "UPDATE orders SET purchaseOrder='$poNum' WHERE orderID='$orderNum';";
        $conn->query($sql);
    }
    elseif($step_id == 134)
    {
        if(strcasecmp($status, 'approved') == 0)
        {
            $orderStatus = 2;
        }
        else
        {
            $orderStatus = 1;
        }

        $orderNum = $entry['15'];

        $sql = "UPDATE orders SET status='$orderStatus' WHERE orderID='$orderNum';";
        $conn->query($sql);
    }
}

/* Update Provider Wait Time */
add_action('gform_after_submission_46', 'update_provider_waittime', 10, 2);
function update_provider_waittime($entry, $form)
{
    $office = $entry['1'];
    $doctorExpoUS = $entry['2'];
    $doctorExpoDS = $entry['3'];
    $doctorFAO = $entry['4'];
    $doctorFOL = $entry['5'];
    $doctorLOD = $entry['6'];
    $doctorROS = $entry['7'];
    $doctorRSA = $entry['8'];
    $doctorSCK = $entry['9'];
    $status = $entry['10'];

    //$postURL = 'http://requestb.in/1huoz1c1';
    $postURL = 'http://intranet/employeedb/schedule/updateDocsWebhook.php';

    $body = array(
        'office' => $office,
        'doctorExpoUS' => $doctorExpoUS,
        'doctorExpoDS' => $doctorExpoDS,
        'doctorFAO' => $doctorFAO,
        'doctorFOL' => $doctorFOL,
        'doctorLOD' => $doctorLOD,
        'doctorROS' => $doctorROS,
        'doctorRSA' => $doctorRSA,
        'doctorSCK' => $doctorSCK,
        'status' => $status);

    $request = new WP_Http();
    $response = $request->post($postURL, array('body' => $body));
}

/* Update Indemand SOP Table */
add_action('gform_after_submission_50', 'updateIndemandSOP', 10, 2);
function updateIndemandSOP($entry, $form)
{
    $current_user = wp_get_current_user();

    //$postURL = 'http://requestb.in/1fubc671';
    $postURL = 'http://intranet/employeedb/updateSOP.php';

    $body = array(
        'email' => $current_user->user_email,
        'sopID' => '1');

    $request = new WP_Http();
    $response = $request->post($postURL, array('body' => $body));
}

add_action('gform_confirmation_65', 'updateCallReminderSOP', 10, 4);
function updateCallReminderSOP($confirmation, $form, $entry, $ajax)
{
    $current_user = wp_get_current_user();

    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "employee_database";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }

    $sqlSelect = "SELECT employeeID FROM employees WHERE email='$current_user->user_email';";
    $result = $conn->query($sqlSelect);

    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            $employeeID = $row['employeeID'];
        }

        $sqlInsert = "INSERT INTO employee_sops (sop_id, emp_id) VALUES (5, $employeeID);";
        $result = $conn->query($sqlInsert);
    }

    return $confirmation;
}

/* Block Forms From Fake Users */
add_filter( "gform_pre_render", "block_user_render_form", 100, 1 );
function block_user_render_form($form)
{
    $user = wp_get_current_user();
    if(!current_user_can('ckeditor_ckfinder_access'))
    {
        echo '<p> You are logged in as ' . $user->display_name . '. Please use the TS Line or a Fat Client to access this form.';
        return null;
    }

    return $form;
}

/* Change Webhook Keys */
add_filter( 'gravityflow_webhook_args', 'sh_filter_gravityflow_webhook_args', 10, 3 );
function sh_filter_gravityflow_webhook_args( $args, $entry, $current_step )
{
    //Get Created by User
    $submitUser = new WP_User( $entry['created_by'] );
    $approveUser = wp_get_current_user();

    //Get Current Status
    $status = $entry['workflow_step_status_71'];

    // Key => Value
    if($args['method'] == 'POST')
    {
        $args['body'] = array( 'requestDate' => $entry['1'],
                                'requestHours' => $entry['2'],
                                'requestOffice' => $entry['7'],
                                'requestReason' => $entry['6'],
                                'requestSentDate' => $entry['15'],
                                'submitUser' => $submitUser->display_name,
                                'approveUser' => $approveUser->display_name,
                                'workflowStatus' => $status);
    }

    return $args;
}


/* Emergency Contact Form */
add_filter('gform_pre_render', 'add_readonly_script');
function add_readonly_script($form)
{
    ?>

    <script type="text/javascript">
        jQuery(document).ready(function(){
            jQuery("li.gf_readonly input").attr("readonly","readonly");
        });
    </script>

    <?php
    return $form;
}

//Custom Merge Tag for Workflow Status
add_action( 'gform_admin_pre_render', 'add_merge_tags' );
function add_merge_tags($form)
{
    ?>
    <script type="text/javascript">
        gform.addFilter('gform_merge_tags', 'add_merge_tags');
        function add_merge_tags(mergeTags, elementId, hideAllFields, excludeFieldTypes, isPrepop, option){
            mergeTags["custom"].tags.push({ tag: '{workflow_status}', label: 'Workflow Status' });
            mergeTags["other"].tags.push({ tag: '{hostname}', label: 'Hostname' });
            mergeTags["other"].tags.push({tag: '{curtime}', label: 'Current Time'});

            return mergeTags;
        }
    </script>
    <?php
    return $form;
}

/* Change Mileage List Field Column 1 to a Date Field */
add_filter( 'gform_column_input_content_32_4_1', 'changeColumn1ToDateSup', 10, 6 );
function changeColumn1ToDateSup( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="date" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Change Mileage List Field Column 4 to a Number Field */
add_filter( 'gform_column_input_content_32_4_4', 'changeColumn4ToNumberSup', 10, 6 );
function changeColumn4ToNumberSup( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="0" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}


/************************************/
/*          Mileage Form            */
/************************************/
/* Change Mileage List Field Column 1 to a Date Field*/
add_filter( 'gform_column_input_content_17_4_1', 'changeColumn1ToDate', 10, 6 );
function changeColumn1ToDate( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="date" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Change Mileage List Field Column 4 to a Number Field */
add_filter( 'gform_column_input_content_17_4_4', 'changeColumn4ToNumber', 10, 6 );
function changeColumn4ToNumber( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="0" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Change Expense List Field Column 1 to a Date Field */
add_filter( 'gform_column_input_content_30_9_1', 'changeColumn1ToDateForExpense', 10, 6 );
function changeColumn1ToDateForExpense( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="date" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Change Expense List Field Column 2 to a Number Field */
add_filter( 'gform_column_input_content_30_9_3', 'changeColumn2ToNumber', 10, 6 );
function changeColumn2ToNumber( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="0" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Change GF Patient Pictures */
add_filter( 'gform_upload_path_54', 'change_upload_path_54', 10, 2 );
function change_upload_path_54($path_info, $form_id)
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");

    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/traunerLetter/' . $year . '/' . $month . '/' . $day . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/traunerLetter/' . $year . '/' . $month . '/' . $day . '/';
    return $path_info;
}

/* Change GF Upload Path for Mileage Coordinators */
add_filter( 'gform_upload_path_32', 'change_upload_path_32', 10, 2 );
function change_upload_path_32( $path_info, $form_id )
{
    $current_user = wp_get_current_user();
    $year = date("Y");
    $month = date("m");
    $day = date("d");

    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/mileage/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/mileage/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    return $path_info;
}

/* Change GF Upload Path for Direct Deposit */
add_filter( 'gform_upload_path_25', 'change_upload_path_25', 10, 2 );
function change_upload_path_25( $path_info, $form_id )
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");
    $current_user = wp_get_current_user();
    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/directDeposit/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/directDeposit/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    return $path_info;
}

/* Change GF Upload Path for Expense */
add_filter( 'gform_upload_path_30', 'change_upload_path_30', 10, 2 );
function change_upload_path_30( $path_info, $form_id )
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");
    $current_user = wp_get_current_user();
    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/expense/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/expense/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    return $path_info;
}

/* Change GF Upload Path for Expense */
add_filter( 'gform_upload_path_33', 'change_upload_path_33', 10, 2 );
function change_upload_path_33( $path_info, $form_id )
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");
    $current_user = wp_get_current_user();
    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/expense/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/expense/' . $year . '/' . $month . '/' . $day . '/' . $current_user->user_login . '/';
    return $path_info;
}

/* Change GF Upload Path for Training Upload */
add_filter( 'gform_upload_path_27', 'gform_upload_path_27', 10, 2 );
function change_upload_path_27( $path_info, $form_id )
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");
    $current_user = wp_get_current_user();
    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/training/' . $year . '/' . $current_user->user_login . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/training/' . $year . '/' . $current_user->user_login . '/';
    return $path_info;
}

/* Change GF Upload Path for Maintenance */
add_filter( 'gform_upload_path_37', 'change_upload_path_37', 10, 2 );
function change_upload_path_37($path_info, $form_id)
{
    $year = date("Y");
    $month = date("m");
    $day = date("d");
    $path_info['path'] = 'E:\inetpub\wwwroot\wordpress/wp-content/uploads/gravity_forms/maintenance/' . $year . '/' . $month . '/' . $day . '/';
    $path_info['url'] = 'http://intranet/wp-content/uploads/gravity_forms/maintenance/' . $year . '/' . $month . '/' . $day . '/';
    return $path_info;
}

//List Field Columns
add_filter( 'gform_merge_tag_filter', function ( $value, $merge_tag, $modifier, $field, $raw_value ) {
    if ( $field->type == 'list' && $merge_tag != 'all_fields' && is_numeric( $modifier ) ) {
        // count the actual number of columns
        $choices      = $field->choices;
        $column_count = count( $choices );

        if ( $column_count > 1 ) {
            // subtract 1 from column number as the choices array is zero based
            $column_num = $modifier - 1;

            // get the column label so we can use that as the key to the multi-column values
            $column = rgars( $choices, "{$column_num}/text" );

            // get the list fields values from the $entry
            $values        = unserialize( $raw_value );
            $column_values = array();

            foreach ( $values as $value ) {
                $column_values[] = rgar( $value, $column );
            }

            $value = GFCommon::implode_non_blank('<br><hr>', $column_values);
        }
    }

    return $value;
}, 10, 5 );

//Change Values of Custom Merge Tags
add_filter( 'gform_replace_merge_tags', 'replace_status', 10, 7 );
function replace_status( $text, $form, $entry, $url_encode, $esc_html, $nl2br, $format )
{

    $custom_merge_tag = '{workflow_status}';

    if ( strpos( $text, $custom_merge_tag ) === false ) {
        return $text;
    }

    $text = str_replace( $custom_merge_tag, $entry['workflow_final_status'], $text );

    return $text;
}

add_filter( 'gform_replace_merge_tags', 'replace_time', 10, 7 );
function replace_time( $text, $form, $entry, $url_encode, $esc_html, $nl2br, $format )
{
    $custom_merge_tag = '{curtime}';

    if ( strpos( $text, $custom_merge_tag ) === false )
    {
        return $text;
    }

    date_default_timezone_set('America/Los_Angeles');
    $time = date('H:i');
    $text = str_replace( $custom_merge_tag, $time, $text );

    return $text;
}

add_filter( 'gform_replace_merge_tags', 'replace_hostname', 10, 7 );
function replace_hostname( $text, $form, $entry, $url_encode, $esc_html, $nl2br, $format )
{

    $custom_merge_tag = '{hostname}';

    if ( strpos( $text, $custom_merge_tag ) === false ) {
        return $text;
    }

    $ipaddress = '';
    if (getenv('HTTP_CLIENT_IP'))
        $ipaddress = getenv('HTTP_CLIENT_IP');
    else if(getenv('HTTP_X_FORWARDED_FOR'))
        $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
    else if(getenv('HTTP_X_FORWARDED'))
        $ipaddress = getenv('HTTP_X_FORWARDED');
    else if(getenv('HTTP_FORWARDED_FOR'))
        $ipaddress = getenv('HTTP_FORWARDED_FOR');
    else if(getenv('HTTP_FORWARDED'))
       $ipaddress = getenv('HTTP_FORWARDED');
    else if(getenv('REMOTE_ADDR'))
        $ipaddress = getenv('REMOTE_ADDR');
    else
        $ipaddress = 'UNKNOWN';

    $fqdn = gethostbyaddr($ipaddress);
    $fqdnExp = explode('.', $fqdn);

    $hostname = array(
                        'host'=> $fqdnExp[0],
                        'domain'=> $fqdnExp[1],
                        'scope'=> $fqdnExp[2]);

    if(stripos($hostname['host'], 'termserv') === FALSE)
    {
        $text = str_replace( $custom_merge_tag, $hostname['host'], $text );
    }
    else
    {
        $text = str_replace( $custom_merge_tag, '', $text );
    }

    return $text;
}

/* Uniform Order Webhook */
add_action('gform_after_submission_41', 'createOrderForms', 10, 2);
function createOrderForms($entry, $form)
{
    /* Set Form Info */
    $uniformTopsFID = 4;
    $uniformBottomsFID = 8;
    $frontOfficeUniformFID = 22;

    /* Get Location Info */
    $location = rgar($entry, '3');
    $department = rgar($entry, '21');

    //$postURL = 'http://requestb.in/zpmft8zp';
    $postURL = 'http://intranet/employeedb/orderFormCreation.php';
    $body = array(
        'uniformTops' => $entry[$uniformTopsFID],
        'uniformBottoms' => $entry[$uniformBottomsFID],
        'frontOfficeOrder' => $entry[$frontOfficeUniformFID],
        'location' => $location,
        'department' => $department);

    $request = new WP_Http();
    $response = $request->post($postURL, array('body' => $body));
}

/* Change path of Gravity flow PDF's */
add_filter( 'gravityflowpdf_file_path', 'sh_gravityflowpdf_file_path', 10, 2 );
function sh_gravityflowpdf_file_path( $path, $entry_id ) {
    $entry = GFAPI::get_entry( $entry_id );
    $form = GFAPI::get_form( $entry['form_id'] );

    if($entry['form_id'] == 42)
    {
        $FirstName = rgar($entry, '3.3');
        $LastName = rgar($entry, '3.6');
        $physicianFirstName = rgar($entry, '15.3');
        $physicianLastName = rgar($entry, '15.6');
        $path = gravity_flow_pdf()->get_destination_folder() . $FirstName . $physicianFirstName . ' ' . $LastName . $physicianLastName . ' - ' . $form['title'] . ' - ' . $entry_id . '.pdf';

    }
    else
    {
        $entry_creator = new WP_User( $entry['created_by'] );
        $path = gravity_flow_pdf()->get_destination_folder() . $entry_creator->display_name . ' - ' . $form['title'] . ' - ' . $entry_id . '.pdf';
    }

    return $path;
}

/* Change Number of List field rows */
/**
 * Gravity Wiz // Gravity Forms // Set Number of List Field Rows by Field Value
 *
 * Add/remove list field rows automatically based on the value entered in the specified field. Removes the add/remove
 * that normally buttons next to List field rows.
 *
 * @version   1.0
 * @author    David Smith <david@gravitywiz.com>
 * @license   GPL-2.0+
 * @link      http://gravitywiz.com/2012/06/03/set-number-of-list-field-rows-by-field-value/
 */
class GWAutoListFieldRows {

    private static $_is_script_output;

    function __construct( $args )
    {

        $this->_args = wp_parse_args( $args, array(
            'form_id'       => false,
            'input_html_id' => false,
            'list_field_id' => false
        ) );

        extract( $this->_args ); // gives us $form_id, $input_html_id, and $list_field_id

        if( ! $form_id || ! $input_html_id || ! $list_field_id )
            return;

        add_filter( 'gform_pre_render_' . $form_id, array( $this, 'pre_render' ) );

    }

    function pre_render( $form ) {
        ?>

        <style type="text/css"> #field_<?php echo $form['id']; ?>_<?php echo $this->_args['list_field_id']; ?> .gfield_list_icons { display: none; } </style>

        <?php

        add_filter( 'gform_register_init_scripts', array( $this, 'register_init_script' ) );

        if( ! self::$_is_script_output )
            $this->output_script();

        return $form;
    }

    function register_init_script( $form ) {

        // remove this function from the filter otherwise it will be called for every other form on the page
        remove_filter( 'gform_register_init_scripts', array( $this, 'register_init_script' ) );

        $args = array(
            'formId'      => $this->_args['form_id'],
            'listFieldId' => $this->_args['list_field_id'],
            'inputHtmlId' => $this->_args['input_html_id']
        );

        $script = "new gwalfr(" . json_encode( $args ) . ");";
        $key = implode( '_', $args );

        GFFormDisplay::add_init_script( $form['id'], 'gwalfr_' . $key , GFFormDisplay::ON_PAGE_RENDER, $script );

    }

    function output_script() {
        ?>

        <script type="text/javascript">

            window.gwalfr;

            (function($){

                gwalfr = function( args ) {

                    this.formId      = args.formId,
                        this.listFieldId = args.listFieldId,
                        this.inputHtmlId = args.inputHtmlId;

                    this.init = function() {

                        var gwalfr = this,
                            triggerInput = $( this.inputHtmlId );

                        // update rows on page load
                        this.updateListItems( triggerInput, this.listFieldId, this.formId );

                        // update rows when field value changes
                        triggerInput.change(function(){
                            gwalfr.updateListItems( $(this), gwalfr.listFieldId, gwalfr.formId );
                        });

                    }

                    this.updateListItems = function( elem, listFieldId, formId ) {

                        var listField = $( '#field_' + formId + '_' + listFieldId ),
                            count = parseInt( elem.val() );
                        rowCount = listField.find( 'table.gfield_list tbody tr' ).length,
                            diff = count - rowCount;

                        if( diff > 0 ) {
                            for( var i = 0; i < diff; i++ ) {
                                listField.find( '.add_list_item:last' ).click();
                            }
                        } else {

                            // make sure we never delete all rows
                            if( rowCount + diff == 0 )
                                diff++;

                            for( var i = diff; i < 0; i++ ) {
                                listField.find( '.delete_list_item:last' ).click();
                            }

                        }
                    }

                    this.init();

                }

            })(jQuery);

        </script>

        <?php
    }

}

/* Mileage form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 17,
    'list_field_id' => 4,
    'input_html_id' => '#input_17_18'
) );

/* Expense form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 30,
    'list_field_id' => 9,
    'input_html_id' => '#input_30_16'
) );

/* Expense form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 32,
    'list_field_id' => 4,
    'input_html_id' => '#input_32_18'
) );

/* Expense form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 33,
    'list_field_id' => 9,
    'input_html_id' => '#input_33_16'
) );

/* Order form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 41,
    'list_field_id' => 4,
    'input_html_id' => '#input_41_5'
) );

/* Order form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 41,
    'list_field_id' => 8,
    'input_html_id' => '#input_41_9'
) );

/* Order form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 41,
    'list_field_id' => 22,
    'input_html_id' => '#input_41_23'
) );

/* Office Supplies Order form Dynamic rows */
new GWAutoListFieldRows( array(
    'form_id' => 52,
    'list_field_id' => 4,
    'input_html_id' => '#input_52_11'
));

/* Scrub Uniform Tops Order Form Custom Code */
/* Scrub Top Quantity */
add_filter( 'gform_column_input_content_41_4_4', 'changeColumn4ToNumberOrder', 10, 6 );
function changeColumn4ToNumberOrder( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="1" max="10" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Scrub Top Size */
add_filter( 'gform_column_input_content_41_4_1', 'changeColumn1ToDropOrder', 10, 6 );
function changeColumn1ToDropOrder( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="XS">Xtra Small</option>
                        <option value="Small">Small</option>
                        <option value="Medium">Medium</option>
                        <option value="Large">Large</option>
                        <option value="XL">XL</option>
                        <option value="2XL">2XL</option>
                        <option value="3XL">3XL</option>
                        <option value="4XL">4XL</option>
                    </select>';
    return $new_input;
}

/*Scrub Top Style */
add_filter( 'gform_column_input_content_41_4_2', 'changeColumn2ToDropOrder', 10, 6 );
function changeColumn2ToDropOrder( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="086706D">Womens V-Neck</option>
                        <option value="4876">Mens V-Neck</option>
                        <option value="86306D">Lab Coat (White Only)</option>
                        <option value="FleeceJacket">Fleece Jacket (Black Only)</option>
                    </select>';
    return $new_input;
}

/* Scrub Top Color */
add_filter( 'gform_column_input_content_41_4_3', 'changeColumn3ToDropOrder', 10, 6 );
function changeColumn3ToDropOrder( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="Pewter">Pewter</option>
                        <option value="Maroon">Maroon (Surgery Only)</option>
                        <option value="Black">Black</option>
                        <option value="Black">White</option>
                    </select>';
    return $new_input;
}


/* Scrub Uniform Bottoms Order Form */

/* Scrub Pant Quantity */
add_filter( 'gform_column_input_content_41_8_4', 'scrubBottomFormCol4', 10, 6 );
function scrubBottomFormCol4( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="1" max="10" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Scrub Pants Size */
add_filter( 'gform_column_input_content_41_8_1', 'scrubBottomFormCol1', 10, 6 );
function scrubBottomFormCol1( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="XS">Xtra Small</option>
                        <option value="Small">Small</option>
                        <option value="SmallTall">Small Tall</option>
                        <option value="Medium">Medium</option>
                        <option value="MediumTall">Medium Tall</option>
                        <option value="LargeTall">Large Tall</option>
                        <option value="XL">XL</option>
                        <option value="XLT">XL Tall</option>
                        <option value="2XL">2XL</option>
                        <option value="2XLT">2XL Tall</option>
                        <option value="3XL">3XL</option>
                        <option value="3XLT">3XL Tall</option>
                        <option value="4XL">4XL</option>
                        <option value="4XLT">4XL Tall</option>
                    </select>';
    return $new_input;
}

/* Scrub Pants Style */
add_filter( 'gform_column_input_content_41_8_2', 'scrubBottomFormCol2', 10, 6 );
function scrubBottomFormCol2( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="86206D">Womens Half Draw & Half Elastic</option>
                        <option value="86106D">Womens Full Elastic</option>
                        <option value="4000">Mens Scrub Pants</option>
                    </select>';
    return $new_input;
}

/* Scrub bottom Colors */
add_filter( 'gform_column_input_content_41_8_3', 'scrubBottomFormCol3', 10, 6 );
function scrubBottomFormCol3( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="Pewter">Pewter</option>
                        <option value="Maroon">Maroon (Surgery Only)</option>
                        <option value="Black">Black</option>
                    </select>';
    return $new_input;
}

/* Front Office Uniforms */

/* Shirt Quantity */
add_filter( 'gform_column_input_content_41_22_4', 'foBottomFormCol4', 10, 6 );
function foBottomFormCol4( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input = '<input type="number" step="any" min="1" max="10" name="' . $input_field_name . '" value="' . $value . '" ' . $tabindex . ' />';
    return $new_input;
}

/* Shirt Size */
add_filter( 'gform_column_input_content_41_22_1', 'foBottomFormCol1', 10, 6 );
function foBottomFormCol1( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="" disabled>Jacket & Cardigan</option>
                        <option value="Small">Small</option>
                        <option value="Medium">Medium</option>
                        <option value="Large">Large</option>
                        <option value="XL">Xtra Large</option>
                        <option value="" disabled>Petite</option>
                        <option value="Petite 00">00</option>
                        <option value="Petite 0">0</option>
                        <option value="Petite 1">1</option>
                        <option value="Petite 2">2</option>
                        <option value="Petite 3">3</option>
                        <option value="Petite 4">4</option>
                        <option value="Petite 5">5</option>
                        <option value="Petite 6">6</option>
                        <option value="Petite 7">7</option>
                        <option value="Petite 8">8</option>
                        <option value="Petite 9">9</option>
                        <option value="Petite 10">10</option>
                        <option value="Petite 11">11</option>
                        <option value="Petite 12">12</option>
                        <option value="Petite 13">13</option>
                        <option value="Petite 14">14</option>
                        <option value="Petite 15">15</option>
                        <option value="Petite 16">16</option>
                        <option value="" disabled>Regular</option>
                        <option value="Regular 2">2</option>
                        <option value="Regular 3">3</option>
                        <option value="Regular 4">4</option>
                        <option value="Regular 5">5</option>
                        <option value="Regular 6">6</option>
                        <option value="Regular 7">7</option>
                        <option value="Regular 8">8</option>
                        <option value="Regular 9">9</option>
                        <option value="Regular 10">10</option>
                        <option value="Regular 11">11</option>
                        <option value="Regular 12">12</option>
                        <option value="Regular 13">13</option>
                        <option value="Regular 14">14</option>
                        <option value="Regular 15">15</option>
                        <option value="Regular 16">16</option>
                        <option value="Regular 17">17</option>
                        <option value="Regular 18">18</option>
                        <option value="" disabled>Tall</option>
                        <option value="Tall 8">8</option>
                        <option value="Tall 9">9</option>
                        <option value="Tall 10">10</option>
                        <option value="Tall 11">11</option>
                        <option value="Tall 12">12</option>
                        <option value="Tall 13">13</option>
                        <option value="Tall 14">14</option>
                        <option value="Tall 15">15</option>
                        <option value="Tall 16">16</option>
                        <option value="Tall 17">17</option>
                        <option value="Tall 18">18</option>
                        <option value="Tall 19">19</option>
                        <option value="Tall 20">20</option>
                        <option value="" disabled>Womens</option>
                        <option value="Womens 18W">18W</option>
                        <option value="Womens 19W">19W</option>
                        <option value="Womens 20W">20W</option>
                        <option value="Womens 21W">21W</option>
                        <option value="Womens 22W">22W</option>
                        <option value="Womens 23W">23W</option>
                        <option value="Womens 24W">24W</option>
                        <option value="Womens 25W">25W</option>
                        <option value="Womens 26W">26W</option>
                        <option value="Womens 27W">27W</option>
                        <option value="Womens 28W">28W</option>
                        <option value="Womens 29W">29W</option>
                        <option value="Womens 30W">30W</option>
                        <option value="Womens 31W">31W</option>
                        <option value="Womens 32W">32W</option>
                        <option value="Womens 33W">33W</option>
                        <option value="Womens 34W">34W</option>
                    </select>';
    return $new_input;
}

/* Shirt Style */
add_filter( 'gform_column_input_content_41_22_2', 'foBottomFormCol2', 10, 6 );
function foBottomFormCol2( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="3/4 Sleeve">3/4 Sleeve</option>
                        <option value="Long Sleeve">Long Sleeve</option>
                        <option value="Long Sleeve V-Neck Cardigan">Long Sleeve V-Neck Cardigan (small-XL)</option>
                        <option value="Polo">Polo</option>
                        <option value="Fleece Jacket">Fleece Jacket (Black Only, small-XL)</option>
                    </select>';
    return $new_input;
}

/* Shirt Color */
add_filter( 'gform_column_input_content_41_22_3', 'foBottomFormCol3', 10, 6 );
function foBottomFormCol3( $input, $input_info, $field, $text, $value, $form_id )
{
    //build field name, must match List field syntax to be processed correctly
    $input_field_name = 'input_' . $field->id . '[]';
    $tabindex = GFCommon::get_tabindex();
    $new_input =    '<select name="' . $input_field_name . '" ' . $tabindex . '>
                        <option value="' . $value . '">' . $value . '</option>
                        <option value="Blue">Dark Cobalt Blue</option>
                        <option value="Red">Rich Red</option>
                        <option value="Purple">Prism Purple</option>
                        <option value="Burgundy">Burgundy</option>
                        <option value="Black">Black</option>
                    </select>';
    return $new_input;
}

/**
* Better Pre-submission Confirmation
* http://gravitywiz.com/2012/08/04/better-pre-submission-confirmation/
*/
class GWPreviewConfirmation {

    private static $lead;

    public static function init() {
        add_filter( 'gform_pre_render', array( __class__, 'replace_merge_tags' ) );
    }

    public static function replace_merge_tags( $form ) {

        $current_page = isset(GFFormDisplay::$submission[$form['id']]) ? GFFormDisplay::$submission[$form['id']]['page_number'] : 1;
        $fields = array();

        // get all HTML fields on the current page
        foreach($form['fields'] as &$field) {

            // skip all fields on the first page
            if(rgar($field, 'pageNumber') <= 1)
                continue;

            $default_value = rgar($field, 'defaultValue');
            preg_match_all('/{.+}/', $default_value, $matches, PREG_SET_ORDER);
            if(!empty($matches)) {
                // if default value needs to be replaced but is not on current page, wait until on the current page to replace it
                if(rgar($field, 'pageNumber') != $current_page) {
                    $field['defaultValue'] = '';
                } else {
                    $field['defaultValue'] = self::preview_replace_variables($default_value, $form);
                }
            }

            // only run 'content' filter for fields on the current page
            if(rgar($field, 'pageNumber') != $current_page)
                continue;

            $html_content = rgar($field, 'content');
            preg_match_all('/{.+}/', $html_content, $matches, PREG_SET_ORDER);
            if(!empty($matches)) {
                $field['content'] = self::preview_replace_variables($html_content, $form);
            }

        }

        return $form;
    }

    /**
    * Adds special support for file upload, post image and multi input merge tags.
    */
    public static function preview_special_merge_tags($value, $input_id, $merge_tag, $field) {

        // added to prevent overriding :noadmin filter (and other filters that remove fields)
        if( ! $value )
            return $value;

        $input_type = RGFormsModel::get_input_type($field);

        $is_upload_field = in_array( $input_type, array('post_image', 'fileupload') );
        $is_multi_input = is_array( rgar($field, 'inputs') );
        $is_input = intval( $input_id ) != $input_id;

        if( !$is_upload_field && !$is_multi_input )
            return $value;

        // if is individual input of multi-input field, return just that input value
        if( $is_input )
            return $value;

        $form = RGFormsModel::get_form_meta($field['formId']);
        $lead = self::create_lead($form);
        $currency = GFCommon::get_currency();

        if(is_array(rgar($field, 'inputs'))) {
            $value = RGFormsModel::get_lead_field_value($lead, $field);
            return GFCommon::get_lead_field_display($field, $value, $currency);
        }

        switch($input_type) {
        case 'fileupload':
            $value = self::preview_image_value("input_{$field['id']}", $field, $form, $lead);
            $value = self::preview_image_display($field, $form, $value);
            break;
        default:
            $value = self::preview_image_value("input_{$field['id']}", $field, $form, $lead);
            $value = GFCommon::get_lead_field_display($field, $value, $currency);
            break;
        }

        return $value;
    }

    public static function preview_image_value($input_name, $field, $form, $lead) {

        $field_id = $field['id'];
        $file_info = RGFormsModel::get_temp_filename($form['id'], $input_name);
        $source = RGFormsModel::get_upload_url($form['id']) . "/tmp/" . $file_info["temp_filename"];

        if(!$file_info)
            return '';

        switch(RGFormsModel::get_input_type($field)){

            case "post_image":
                list(,$image_title, $image_caption, $image_description) = explode("|:|", $lead[$field['id']]);
                $value = !empty($source) ? $source . "|:|" . $image_title . "|:|" . $image_caption . "|:|" . $image_description : "";
                break;

            case "fileupload" :
                $value = $source;
                break;

        }

        return $value;
    }

    public static function preview_image_display($field, $form, $value) {

        // need to get the tmp $file_info to retrieve real uploaded filename, otherwise will display ugly tmp name
        $input_name = "input_" . str_replace('.', '_', $field['id']);
        $file_info = RGFormsModel::get_temp_filename($form['id'], $input_name);

        $file_path = $value;
        if(!empty($file_path)){
            $file_path = esc_attr(str_replace(" ", "%20", $file_path));
            $value = "<a href='$file_path' target='_blank' title='" . __("Click to view", "gravityforms") . "'>" . $file_info['uploaded_filename'] . "</a>";
        }
        return $value;

    }

    /**
    * Retrieves $lead object from class if it has already been created; otherwise creates a new $lead object.
    */
    public static function create_lead( $form ) {

        if( empty( self::$lead ) ) {
            self::$lead = GFFormsModel::create_lead( $form );
            self::clear_field_value_cache( $form );
        }

        return self::$lead;
    }

    public static function preview_replace_variables( $content, $form ) {

        $lead = self::create_lead($form);

        // add filter that will handle getting temporary URLs for file uploads and post image fields (removed below)
        // beware, the RGFormsModel::create_lead() function also triggers the gform_merge_tag_filter at some point and will
        // result in an infinite loop if not called first above
        add_filter('gform_merge_tag_filter', array('GWPreviewConfirmation', 'preview_special_merge_tags'), 10, 4);

        $content = GFCommon::replace_variables($content, $form, $lead, false, false, false);

        // remove filter so this function is not applied after preview functionality is complete
        remove_filter('gform_merge_tag_filter', array('GWPreviewConfirmation', 'preview_special_merge_tags'));

        return $content;
    }

    public static function clear_field_value_cache( $form ) {

        if( ! class_exists( 'GFCache' ) )
            return;

        foreach( $form['fields'] as &$field ) {
            if( GFFormsModel::get_input_type( $field ) == 'total' )
                GFCache::delete( 'GFFormsModel::get_lead_field_value__' . $field['id'] );
        }

    }

}

GWPreviewConfirmation::init();


/* Start */

add_filter("gform_field_value_groppoMorningHours", "gmh");
function gmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=1;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_groppoMorningLocation", "gml");
function gml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=1;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_groppoAfternoonHours", "gah");
function gah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=1;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_groppoAfternoonLocation", "gal");
function gal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=1;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_bernsteinMorningHours", "bmh");
function bmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=2;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_bernsteinMorningLocation", "bml");
function bml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=2;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_bernsteinAfternoonHours", "bah");
function bah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=2;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_bernsteinAfternoonLocation", "bal");
function bal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=2;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_goldfarbMorningHours", "gomh");
function gomh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=3;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_goldfarbMorningLocation", "goml");
function goml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=3;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_goldfarbAfternoonHours", "goah");
function goah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=3;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_goldfarbAfternoonLocation", "goal");
function goal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=3;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_clutterMorningHours", "clmh");
function clmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=4;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_clutterMorningLocation", "clml");
function clml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=4;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_clutterAfternoonHours", "clah");
function clah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=4;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_clutterAfternoonLocation", "clal");
function clal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=4;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_cathMorningHours", "camh");
function camh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=5;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_cathMorningLocation", "caml");
function caml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=5;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_cathAfternoonHours", "caah");
function caah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=5;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_cathAfternoonLocation", "caal");
function caal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=5;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_areenMorningHours", "amh");
function amh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=6;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_areenMorningLocation", "aml");
function aml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=6;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_areenAfternoonHours", "afh");
function afh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=6;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_areenAfternoonLocation", "afl");
function afl($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=6;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_traunerMorningHours", "tmh");
function tmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=7;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_traunerMorningLocation", "tml");
function tml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=7;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_traunerAfternoonHours", "tah");
function tah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=7;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_traunerAfternoonLocation", "tal");
function tal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=7;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_mckennanMorningHours", "mmh");
function mmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=8;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_mckennanMorningLocation", "mml");
function mml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=8;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_mckennanAfternoonHours", "mah");
function mah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=8;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_mckennanAfternoonLocation", "mal");
function mal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=8;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_evansMorningHours", "emh");
function emh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=9;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_evansMorningLocation", "eml");
function eml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=9;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_evansAfternoonHours", "eah");
function eah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=9;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_evansAfternoonLocation", "eal");
function eal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=9;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}


add_filter("gform_field_value_lenzMorningHours", "lmh");
function lmh($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=10;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['am'];
        }
    }
}

add_filter("gform_field_value_lenzMorningLocation", "lml");
function lml($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=10;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_lenzAfternoonHours", "lah");
function lah($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=10;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pm'];
        }
    }
}

add_filter("gform_field_value_lenzAfternoonLocation", "lal");
function lal($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=10;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}

add_filter("gform_field_value_sentcall", "sentcall");
function sentcall($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=11;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_mandocall", "mandocall");
function mandocall($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=12;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_expTriage", "expTriage");
function expTriage($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=13;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}

add_filter("gform_field_value_sckTriageam", "sckTriageam");
function sckTriageam($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=14;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['amLocation'];
        }
    }
}

add_filter("gform_field_value_sckTriagepm", "sckTriagepm");
function sckTriagepm($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM dailyschedule WHERE id=14;";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['pmLocation'];
        }
    }
}

/* Send Order Info*/
add_action('gform_after_submission_61', 'updateDailySchedule', 10, 2);
function updateDailySchedule($entry, $form)
{
    $sentCall = $entry['52'];
    $mandoCall = $entry['53'];
    $expTriage = $entry['54'];
    $sckTriageam = $entry['55'];
    $sckTriagepm = $entry['56'];

    $groppoMorningHours = $entry['2'];
    $groppoMorningLocation = $entry['3'];
    $groppoAfternoonHours = $entry['4'];
    $groppoAfternoonLocation = $entry['5'];

    $bernsteinMorningHours = $entry['7'];
    $bernsteinMorningLocation = $entry['8'];
    $bernsteinAfternoonHours = $entry['9'];
    $bernsteinAfternoonLocation = $entry['10'];

    $goldfarbMorningHours = $entry['12'];
    $goldfarbMorningLocation = $entry['13'];
    $goldfarbAfternoonHours = $entry['14'];
    $goldfarbAfternoonLocation = $entry['15'];

    $clutterMorningHours = $entry['17'];
    $clutterMorningLocation = $entry['18'];
    $clutterAfternoonHours = $entry['19'];
    $clutterAfternoonLocation = $entry['20'];

    $cathMorningHours = $entry['22'];
    $cathMorningLocation = $entry['23'];
    $cathAfternoonHours = $entry['24'];
    $cathAfternoonLocation = $entry['25'];

    $areenMorningHours = $entry['27'];
    $areenMorningLocation = $entry['28'];
    $areenAfternoonHours = $entry['29'];
    $areenAfternoonLocation = $entry['30'];

    $traunerMorningHours = $entry['32'];
    $traunerMorningLocation = $entry['33'];
    $traunerAfternoonHours = $entry['34'];
    $traunerAfternoonLocation = $entry['35'];

    $mckennanMorningHours = $entry['37'];
    $mckennanMorningLocation = $entry['38'];
    $mckennanAfternoonHours = $entry['39'];
    $mckennanAfternoonLocation = $entry['40'];

    $evansMorningHours = $entry['42'];
    $evansMorningLocation = $entry['43'];
    $evansAfternoonHours = $entry['44'];
    $evansAfternoonLocation = $entry['45'];

    $lenzMorningHours = $entry['47'];
    $lenzMorningLocation = $entry['48'];
    $lenzAfternoonHours = $entry['49'];
    $lenzAfternoonLocation = $entry['50'];


    $sqlGrop = "UPDATE dailyschedule SET am='$groppoMorningHours', pm='$groppoAfternoonHours', amLocation='$groppoMorningLocation', pmLocation='$groppoAfternoonLocation' WHERE id=1";
    $sqlBern = "UPDATE dailyschedule SET am='$bernsteinMorningHours', pm='$bernsteinAfternoonHours', amLocation='$bernsteinMorningLocation', pmLocation='$bernsteinAfternoonLocation' WHERE id=2";
    $sqlGold = "UPDATE dailyschedule SET am='$goldfarbMorningHours', pm='$goldfarbAfternoonHours', amLocation='$goldfarbMorningLocation', pmLocation='$goldfarbAfternoonLocation' WHERE id=3";
    $sqlClut = "UPDATE dailyschedule SET am='$clutterMorningHours', pm='$clutterAfternoonHours', amLocation='$clutterMorningLocation', pmLocation='$clutterAfternoonLocation' WHERE id=4";
    $sqlCath = "UPDATE dailyschedule SET am='$cathMorningHours', pm='$cathAfternoonHours', amLocation='$cathMorningLocation', pmLocation='$cathAfternoonLocation' WHERE id=5";
    $sqlAreen = "UPDATE dailyschedule SET am='$areenMorningHours', pm='$areenAfternoonHours', amLocation='$areenMorningLocation', pmLocation=' $areenAfternoonLocation' WHERE id=6";
    $sqlTrau = "UPDATE dailyschedule SET am='$traunerMorningHours', pm='$traunerAfternoonHours', amLocation='$traunerMorningLocation', pmLocation='$traunerAfternoonLocation' WHERE id=7";
    $sqlMck = "UPDATE dailyschedule SET am='$mckennanMorningHours', pm='$mckennanAfternoonHours', amLocation='$mckennanMorningLocation', pmLocation='$mckennanAfternoonLocation' WHERE id=8";
    $sqlEvans = "UPDATE dailyschedule SET am='$evansMorningHours', pm='$evansAfternoonHours', amLocation='$evansMorningLocation', pmLocation='$evansAfternoonLocation' WHERE id=9";
    $sqlLenz = "UPDATE dailyschedule SET am='$lenzMorningHours', pm='$lenzAfternoonHours', amLocation='$lenzMorningLocation', pmLocation='$lenzAfternoonLocation' WHERE id=10";

    $sqlSENT = "UPDATE dailyschedule SET amLocation='$sentCall' WHERE id=11";
    $sqlMando = "UPDATE dailyschedule SET amLocation='$mandoCall' WHERE id=12";
    $sqlExpo = "UPDATE dailyschedule SET amLocation='$expTriage' WHERE id=13";
    $sqlSck = "UPDATE dailyschedule SET amLocation='$sckTriageam', pmLocation='$sckTriagepm' WHERE id=14";

    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }

    $result = $conn->query($sqlGrop);
    $result = $conn->query($sqlBern);
    $result = $conn->query($sqlGold);
    $result = $conn->query($sqlClut);
    $result = $conn->query($sqlCath);
    $result = $conn->query($sqlAreen);
    $result = $conn->query($sqlTrau);
    $result = $conn->query($sqlMck);
    $result = $conn->query($sqlEvans);
    $result = $conn->query($sqlLenz);

    $result = $conn->query($sqlSENT);
    $result = $conn->query($sqlMando);
    $result = $conn->query($sqlExpo);
    $result = $conn->query($sqlSck);
}

add_filter( 'gform_pre_render_62', 'populateEmployees' );
add_filter( 'gform_pre_validation_62', 'populateEmployees' );
add_filter( 'gform_pre_submission_filter_62', 'populateEmployees' );
add_filter( 'gform_admin_pre_render_62', 'populateEmployees' );
function populateEmployees($form)
{

    foreach ($form['fields'] as &$field)
    {
        if ($field->id == 1)
        {
            /* MySQL Server Setup */
            $servername = "127.0.0.1";
            $username = "root";
            $password = "admin4sql!";
            $databasename = "employee_database";

            /* Create a connection to the server */
            $conn = new mysqli($servername, $username, $password, $databasename);

            /* Check Connection */
            if($conn->connect_error)
            {
                die("Connection Failed: " . $conn->connect_error);
            }

            $sql = "SELECT CONCAT(firstName, ' ', lastName) AS fullname FROM employees WHERE isdisabled=0 ORDER BY fullname ASC;";
            $result = $conn->query($sql);
            $choices = array();
            if($result->num_rows > 0)
            {
                while($row = $result->fetch_assoc())
                {
                    $choices[] = array('text' => $row['fullname'], 'value' => $row['id']);
                }
            }
            $field->placeholder = 'Select an Employee';
            $field->choices = $choices;
        }
    }

    return $form;
}

add_action('gform_after_submission_62', 'updateOutLate', 10, 2);
function updateOutLate($entry, $form)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_schedules";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    $emp = $entry['1'];
    $status = $entry['2'];
    $loc = $entry['3'];

    if(strcasecmp($status, 'Off-Site') == 0 || strcasecmp($status, 'Triage') == 0)
    {
        $sql = "INSERT INTO outlate (name, status, location) VALUES ('$emp', '$status', '$loc');";
    }
    else
    {
        $sql = "INSERT INTO outlate (name, status) VALUES ('$emp', '$status');";
    }
    $result = $conn->query($sql);
}

/* Finish*/

add_filter("gform_field_value_order_number", "getOrderNum");
function getOrderNum($value)
{
    /* MySQL Server Setup */
    $servername = "127.0.0.1";
    $username = "root";
    $password = "admin4sql!";
    $databasename = "sent_purchaseorders";

    /* Create a connection to the server */
    $conn = new mysqli($servername, $username, $password, $databasename);

    /* Check Connection */
    if($conn->connect_error)
    {
        die("Connection Failed: " . $conn->connect_error);
    }

    //$sql = "SELECT orderID FROM orders ORDER BY orderID DESC LIMIT 1;";
    $sql = "SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sent_purchaseorders' AND TABLE_NAME = 'orders'";
    $result = $conn->query($sql);
    if($result->num_rows > 0)
    {
        while($row = $result->fetch_assoc())
        {
            return $row['AUTO_INCREMENT'];
        }
    }
    else
    {
        return 1;
    }
}

/* Change values of field on Entry Form */
add_filter( 'gform_entry_field_value', 'category_names', 10, 4 );
function category_names($value, $field, $lead, $form)
{
    if($form['id'] == 52)
    {
        if($field->id == 5) // Vendor Field
        {
            if($value != 3)
            {
                /* MySQL Server Setup */
                $servername = "127.0.0.1";
                $username = "root";
                $password = "admin4sql!";
                $databasename = "sent_purchaseorders";

                /* Create a connection to the server */
                $conn = new mysqli($servername, $username, $password, $databasename);

                /* Check Connection */
                if($conn->connect_error)
                {
                    die("Connection Failed: " . $conn->connect_error);
                }

                $sqlField = "SELECT name FROM vendors WHERE id='$value';";
                $result = $conn->query($sqlField);
                if($result->num_rows > 0)
                {
                    while($row = $result->fetch_assoc())
                    {
                        $newValue = $row['name'];
                    }
                }

                return $newValue;
            }

            $newValue = 'Other';
            return $newValue;
        }
        elseif($field->id == 8) // Location Field
        {
            $locations = array(
                    1 => "Expo",
                    2 => "Fair Oaks ENT",
                    3 => "Fair Oaks Allergy",
                    4 => "Folsom ENT",
                    5 => "Folsom Allergy",
                    6 => "Jackson",
                    7 => "Lodi",
                    8 => "Roseville ENT",
                    9 => "Roseville Allergy",
                    10 => "Stockton",
                    11 => "Tracy");

            $newValue = $locations[$value];

            return $newValue;
        }
    }
    return $value;
}

add_filter( 'wp_get_nav_menu_items', 'custom_nav_menu_items', 20, 2 );
function custom_nav_menu_items($items, $menu)
{
    // only add item to a specific menu
    $curUser = wp_get_current_user();

    if ($menu->slug == 'links')
    {
        if($curUser->user_login == 'btempleton' || $curUser->user_login == 'devans' || $curUser->user_login == 'egroppo' || $curUser->user_login == 'cgroves' || $curUser->user_login == 'jdudley' || $curUser->user_login == 'kxm' || $curUser->user_login == 'mcardenas' || $curUser->user_login == 'pghafari' || $curUser->user_login == 'palfaro' || $curUser->user_login == 'rareen' || $curUser->user_login == 'ksurrit' || $curUser->user_login == 'valentina' || $curUser->user_login == 'amcpeters' || $curUser->user_login == 'dclutter' || $curUser->user_login == 'aeppler' || $curUser->user_login == 'jgandy' || $curUser->user_login == 'sclark' || $curUser->user_login == 'cbrown' || $curUser->user_login == 'nortegon' || $curUser->user_login == 'salmond' || $curUser->user_login == 'dfountain')
        {
            $top = _custom_nav_menu_item( 'PO Requests', '#', 10 );
            $items[] = $top;
            $items[] = _custom_nav_menu_item('Office Supllies',  'http://intranet/human-resources/forms/office-supply-orders/', 11, $top->ID);
            //$items[] = _custom_nav_menu_item('Medical Supplies',  'http://intranet/human-resources/forms/office-supply-orders/', 12, $top->ID);
        }

        if(current_user_can('gravityforms_edit_entry_notes'))//Only Admin's + Supervisors have access
        {
            $top = _custom_nav_menu_item( 'Coordinators', '#', 12 );

            if($curUser->user_login == 'btempleton' || $curUser->user_login == 'cgroves' || $curUser->user_login == 'jdudley' || $curUser->user_login == 'pghafari' || $curUser->user_login == 'palfaro' || $curUser->user_login == 'obonard' || $curUser->user_login == 'dfountain' || $curUser->user_login == 'asperling')
            {
                $items[] = $top;$items[] = _custom_nav_menu_item('Employee Database', 'http://intranet/employeedb/', 13, $top->ID);
            }

            $items[] = $top;$items[] = _custom_nav_menu_item('Update Employee Status', 'http://intranet/human-resources/employee-status-update/', 14, $top->ID);
        }
    }


    if ($menu->slug == 'main')
    {
        $top = _custom_nav_menu_item('Schedules', '#', 43);
        $items[] = $top;
        $items[] = _custom_nav_menu_item('Out/Late List', 'http://intranet/out-late/', 44, $top->ID);
        $items[] = _custom_nav_menu_item('Daily Schedule', 'http://intranet/daily-doctor-schedule/', 45, $top->ID);

        if(current_user_can('gravityforms_edit_entry_notes'))//Only Admin's + Supervisors have access
        {
            $items[] = _custom_nav_menu_item('Update Out/Late', 'http://intranet/out-late-form/', 46, $top->ID);
            $items[] = _custom_nav_menu_item('Update Daily Schedule', 'http://intranet/departments/medical-assistant/daily-schedule-form/', 47, $top->ID);
        }
    }

    return $items;
}

/**
 * Simple helper function for make menu item objects
 *
 * @param $title      - menu item title
 * @param $url        - menu item url
 * @param $order      - where the item should appear in the menu
 * @param int $parent - the item's parent item
 * @return \stdClass
 */
function _custom_nav_menu_item( $title, $url, $order, $parent = 0 ){
  $item = new stdClass();
  $item->ID = 1000000 + $order + parent;
  $item->db_id = $item->ID;
  $item->title = $title;
  $item->url = $url;
  $item->menu_order = $order;
  $item->menu_item_parent = $parent;
  $item->type = '';
  $item->object = '';
  $item->object_id = '';
  $item->classes = array();
  $item->target = '';
  $item->attr_title = '';
  $item->description = '';
  $item->xfn = '';
  $item->status = '';
  return $item;
}