function open_csa_wp_spot_form($spot_id, $display) { wp_enqueue_script('open-csa-wp-general-scripts'); wp_enqueue_script('open-csa-wp-spots-scripts'); wp_enqueue_script('jquery.cluetip'); wp_enqueue_style('jquery.cluetip.style'); global $days_of_week, $wpdb; $spot_info; if ($spot_id != null) { $spot_info = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . OPEN_CSA_WP_TABLE_SPOTS . " WHERE id=%d", $spot_id)); } ?> <br /> <div id="open-csa-wp-showNewSpot_formHeader"> <span id="open-csa-wp-showNewSpot_formHeader_text" <?php if ($spot_id == null) { echo 'style="cursor:pointer"'; echo 'onclick="open_csa_wp_toggle_form(\'showNewSpot\',\'' . __('Add New Spot', OPEN_CSA_WP_DOMAIN) . '\', \' ' . __('form', OPEN_CSA_WP_DOMAIN) . '\')"'; } ?> > <font size='4'> <?php if ($spot_id == null) { if ($display == false) { _e('Add New Spot (show form)', OPEN_CSA_WP_DOMAIN); } else { _e('Add New Spot (hide form)', OPEN_CSA_WP_DOMAIN); } } else { echo __('Edit Spot #', OPEN_CSA_WP_DOMAIN) . $spot_id; } ?> </font></span></div> <div id="open-csa-wp-showNewSpot_div" <?php if ($display == false) { echo "style='display:none'"; } ?> > <form method="POST" id="open-csa-wp-showNewSpot_form"> <table class="form-table"> <tr valign="top"><td> <input type="text" <?php if ($spot_id != null && $spot_info[0]->spot_name != "" && $spot_info[0]->spot_name != null) { echo "value='" . $spot_info[0]->spot_name . "'"; } echo "placeholder=\"" . __('Spot Name *', OPEN_CSA_WP_DOMAIN) . "\""; ?> required name="open-csa-wp-spots_spot_name_input" onchange="open_csa_wp_request_spot_name_validity(this.value, <?php echo $spot_id != null ? $spot_id : "null"; ?> , 0, null)"> <span id="open-csa-wp-showNewSpot_name_span_id" style="display:none"></span></td></tr> <tr valign="top"><td> <input type="text" <?php if ($spot_id != null && $spot_info[0]->street_name != "" && $spot_info[0]->street_name != null) { echo "value='" . $spot_info[0]->street_name . "'"; } echo "placeholder=\"" . __('Street Name *', OPEN_CSA_WP_DOMAIN) . "\""; ?> required name="open-csa-wp-spots_street_name_input"> <input type="text" <?php if ($spot_id != null && $spot_info[0]->street_number != "" && $spot_info[0]->street_number != null) { echo "value='" . $spot_info[0]->street_number . "'"; } echo "placeholder=\"" . __('Street Number *', OPEN_CSA_WP_DOMAIN) . "\""; ?> required name="open-csa-wp-spots_street_number_input"></td></tr> <tr valign="top"><td> <input type="text" <?php if ($spot_id != null && $spot_info[0]->city != "" && $spot_info[0]->city != null) { echo "value='" . $spot_info[0]->city . "'"; } echo "placeholder=\"" . __('City *', OPEN_CSA_WP_DOMAIN) . "\""; ?> required name="open-csa-wp-spots_city_input"> <input type="text" <?php if ($spot_id != null && $spot_info[0]->region != "" && $spot_info[0]->region != null) { echo "value='" . $spot_info[0]->region . "'"; } echo "placeholder=\"" . __('Region *', OPEN_CSA_WP_DOMAIN) . "\""; ?> required name="open-csa-wp-spots_region_input"></td></tr> <tr valign="top"><td> <textarea name="open-csa-wp-spots_description_input" rows="3" cols="30" <?php _e('placeholder="Description"', OPEN_CSA_WP_DOMAIN); ?> ><?php if ($spot_id != null) { echo $spot_info[0]->description; } ?> </textarea></td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_is_delivery_spot_input" id="open-csa-wp-spots_is_delivery_spot_input_id" onchange='open_csa_wp_show_new_spot_is_delivery_selection(this,<?php echo $spot_id ? $spot_id : "null"; ?> )' <?php if ($spot_id == null) { echo "style='color:#999'"; } ?> > <?php if ($spot_id != null) { echo ' <option value="" style="color:#999" disabled="disabled">Is this a delivery spot? *</option> <option value="yes" style="color:black". ' . ($spot_info[0]->is_delivery_spot == 1 ? "selected='selected'> it is a delivery spot" : ">yes") . ' </option> <option value="no" style="color:black"' . ($spot_info[0]->is_delivery_spot == 0 ? "selected='selected'> it is not a delivery spot" : ">no") . ' </option> '; } else { ?> <option value="" selected="selected" disabled="disabled">Is this a delivery spot? *</option> <option value="yes" style="color:black"><?php _e('yes', OPEN_CSA_WP_DOMAIN); ?> </option> <option value="no" style="color:black"><?php _e('no', OPEN_CSA_WP_DOMAIN); ?> </option> <?php } ?> </select> <span id="open-csa-wp-showNewSpotForm_deliverySpot_span"></span> </td></tr> </table> <div id = "open-csa-wp-spots_deliverySpot_div" <?php $is_delivery_spot = $spot_id != null && $spot_info[0]->is_delivery_spot == 1 ? 1 : 0; if ($is_delivery_spot) { "style='display:block'"; } else { echo "style='display:none'"; } ?> > <table class="form-table"> <tr valign="top"><td> <select name="open-csa-wp-delivery_spot_owner_input" id="open-csa-wp-delivery_spot_owner_input_id" <?php if (!$is_delivery_spot) { echo "style='color:#999'"; } ?> onfocus='getElementById("open-csa-wp-delivery_spot_owner_span_id").style.display = "none";' onchange=' if (this.options[this.selectedIndex].text.split(" ")[0] != "<?php _e('The owner of this delivery spot is', OPEN_CSA_WP_DOMAIN); ?> ".split(" ")[0]) this.options[this.selectedIndex].text = "<?php _e('The owner of this delivery spot is', OPEN_CSA_WP_DOMAIN); ?> : "+ this.options[this.selectedIndex].text; (this.style.color=this.options[this.selectedIndex].style.color);' > <option value="" <?php if (!$is_delivery_spot) { echo "selected='selected'"; } ?> disabled="disabled" id="open-csa-wp-delivery_spot_owner_disabled_id"><?php _e('Owner of this delivery spot... *', OPEN_CSA_WP_DOMAIN); ?> </option> <?php $spot_owner_id = null; if ($is_delivery_spot) { $spot_owner_id = $wpdb->get_var($wpdb->prepare("SELECT user_id FROM " . OPEN_CSA_WP_TABLE_SPOTS_TO_USERS . " WHERE spot_id=%d AND type='delivery' ", $spot_id), 0, 0); } open_csa_wp_select_users($spot_owner_id, __("The owner of this delivery spot is: ", OPEN_CSA_WP_DOMAIN)); ?> </select> <span style="display:none;color:blue" id="open-csa-wp-delivery_spot_owner_span_id"></span> </td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_order_deadline_day_input" id='open-csa-wp-spots_order_deadline_day_input_id' onfocus='document.getElementById("open-csa-wp-showNewSpotForm_orderDeadline_span").style.display = "none";' onchange=' this.style.color="black"; if (this.options[this.selectedIndex].text.split(" ")[0] != "<?php _e('Order deadline is on', OPEN_CSA_WP_DOMAIN); ?> ".split(" ")[0]) this.options[this.selectedIndex].text = "<?php _e('Order deadline is on', OPEN_CSA_WP_DOMAIN); ?> : " + this.options[this.selectedIndex].text; getElementById("open-csa-wp-spots_order_deadline_time_input_id").style.display = "inline" ' <?php if (!$is_delivery_spot) { echo "style='color:#999'"; } ?> > <option value="" <?php if (!$is_delivery_spot) { echo "selected='selected'"; } ?> disabled="disabled" id="open-csa-wp-spots_order_deadline_day_disabled_id"><?php _e('Order deadline day... *', OPEN_CSA_WP_DOMAIN); ?> </option> <?php for ($i = 0; $i < 7; $i++) { if ($is_delivery_spot && $spot_info[0]->default_order_deadline_day == $i) { echo "<option value='{$i}' selected='selected' style='color:black'>" . __('Order deadline is on ', OPEN_CSA_WP_DOMAIN) . " {$days_of_week[$i]} </option>"; } else { echo "<option value='{$i}' style='color:black'>" . $days_of_week[$i] . "</option>"; } } ?> </select> <input <?php if ($is_delivery_spot && $spot_info[0]->default_order_deadline_time != "" && $spot_info[0]->default_order_deadline_time != null) { echo "value='" . __('up to', OPEN_CSA_WP_DOMAIN) . " " . open_csa_wp_remove_seconds($spot_info[0]->default_order_deadline_time) . "'"; } if (!$is_delivery_spot) { echo "style='display:none'"; } echo "placeholder=\"" . __('up to', OPEN_CSA_WP_DOMAIN) . "... *\""; ?> id="open-csa-wp-spots_order_deadline_time_input_id" class="textbox-n" type="text" size="10" name="open-csa-wp-spots_order_deadline_time_input" onfocus=' if (this.value != "") { this.value=this.value.split(" ")[2]; } else { getElementById("open-csa-wp-showNewSpotForm_orderDeadline_span").style.display = "none"; } this.type="time";' onblur=' this.type="text"; if (this.value != "") { this.style.color="black"; this.value = "<?php _e('up to', OPEN_CSA_WP_DOMAIN); ?> " + this.value; }'> <span id="open-csa-wp-showNewSpotForm_orderDeadline_span" style="display:none"></span> </td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_delivery_day_input" id="open-csa-wp-spots_delivery_day_input_id" onfocus='getElementById("open-csa-wp-showNewSpotForm_invalidDeliveryTime_span").innerHTML = "";' onchange=' this.style.color="black"; if (this.options[this.selectedIndex].text.split(" ")[0] != "<?php _e('Delivery day is', OPEN_CSA_WP_DOMAIN); ?> ".split(" ")[0]) { this.options[this.selectedIndex].text = "<?php _e('Delivery day is', OPEN_CSA_WP_DOMAIN); ?> " + this.options[this.selectedIndex].text; } getElementById("open-csa-wp-showNewSpotForm_delivery_start_time_input_id").style.display = "inline" getElementById("open-csa-wp-showNewSpotForm_delivery_end_time_input_id").style.display = "inline"; ' <?php if (!$is_delivery_spot) { echo "style='color:#999'"; } ?> > <option value="" disabled="disabled" <?php if (!$is_delivery_spot) { echo "selected='selected'"; } ?> id="open-csa-wp-spots_delivery_day_disabled_id"><?php _e('Delivery day', OPEN_CSA_WP_DOMAIN); ?> ... *</option> <?php for ($i = 0; $i < 7; $i++) { if ($is_delivery_spot && $spot_info[0]->default_delivery_day == $i) { echo "<option value='{$i}' selected='selected'>" . __('Delivery day is', OPEN_CSA_WP_DOMAIN) . " {$days_of_week[$i]} </option>"; } else { echo "<option value='{$i}'>" . $days_of_week[$i] . "</option>"; } } ?> </select> <input id="open-csa-wp-showNewSpotForm_delivery_start_time_input_id" <?php if ($is_delivery_spot && $spot_info[0]->default_delivery_start_time != "" && $spot_info[0]->default_delivery_start_time != null) { echo "value='" . __('from', OPEN_CSA_WP_DOMAIN) . " " . open_csa_wp_remove_seconds($spot_info[0]->default_delivery_start_time) . "'"; } if (!$is_delivery_spot) { echo "style='display:none'"; } echo "placeholder=\"" . __('from', OPEN_CSA_WP_DOMAIN) . "... *\""; ?> class="textbox-n" type="text" size="10" name="open-csa-wp-spots_delivery_start_time_input" onfocus=' if (this.value != "") { this.value=this.value.split(" ")[1]; } else { getElementById("open-csa-wp-showNewSpotForm_invalidDeliveryTime_span").style.display = "none"; } this.type="time";' onblur=' this.type="text"; if (this.value == "") { getElementById("open-csa-wp-showNewSpotForm_delivery_end_time_input_id").value = ""; } else { this.style.color="black"; this.value = "<?php _e('from', OPEN_CSA_WP_DOMAIN); ?> " + this.value; open_csa_wp_validate_delivery_time_period("showNewSpotForm"); }'> <input id="open-csa-wp-showNewSpotForm_delivery_end_time_input_id" <?php if ($is_delivery_spot && $spot_info[0]->default_delivery_end_time != "" && $spot_info[0]->default_delivery_end_time != null) { echo "value='" . __('to', OPEN_CSA_WP_DOMAIN) . " " . open_csa_wp_remove_seconds($spot_info[0]->default_delivery_end_time) . "'"; } if (!$is_delivery_spot) { echo "style='display:none'"; } echo "placeholder=\"" . __('to', OPEN_CSA_WP_DOMAIN) . "... *\""; ?> class="textbox-n" type="text" size="10" name="open-csa-wp-spots_delivery_end_time_input" onfocus=' if (this.value != "") { this.value=this.value.split(" ")[1]; } getElementById("open-csa-wp-showNewSpotForm_invalidDeliveryTime_span").style.display = "none"; this.type="time";' onblur=' this.type="text"; if (this.value != "") { this.style.color="black"; this.value = "<?php _e('to', OPEN_CSA_WP_DOMAIN); ?> " + this.value; open_csa_wp_validate_delivery_time_period("showNewSpotForm"); } '> <span id="open-csa-wp-showNewSpotForm_invalidDeliveryTime_span"> </span> </td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_close_input" id="open-csa-wp-spots_close_input_id" <?php if (!$is_delivery_spot) { echo "style='color:#999'"; } ?> onfocus='getElementById("open-csa-wp-showNewSpotForm_ordersClose_span_id").innerHTML = "";' onchange=' this.style.color="black"; if (this.options[this.selectedIndex].text.split(" ")[0] != "<?php _e('Order close', OPEN_CSA_WP_DOMAIN); ?> ".split(" ")[0]) { this.options[this.selectedIndex].text = "<?php _e('Order close', OPEN_CSA_WP_DOMAIN); ?> "+this.options[this.selectedIndex].text; } getElementById("open-csa-wp-spots_close_"+ this.options[this.selectedIndex].value).style.display= "inline"; getElementById("open-csa-wp-spots_close_"+ this.options[((this.selectedIndex-1)+1)%2+1].value).style.display="none"'> <option value="" <?php if (!$is_delivery_spot) { echo "selected='selected'"; } ?> disabled="disabled" id="open-csa-wp-spots_close_disabled_id"><?php _e('Order close', OPEN_CSA_WP_DOMAIN); ?> ... *</option> <option value="automatic" <?php if ($is_delivery_spot && $spot_info[0]->close_order == "automatic") { echo "selected='selected'"; } ?> title="<?php _e("Orders' submission will be closed automatically when order submission deadline is reached", OPEN_CSA_WP_DOMAIN); ?> "> <?php if ($is_delivery_spot && $spot_info[0]->close_order == "automatic") { echo __('Order close', OPEN_CSA_WP_DOMAIN) . " "; } ?> automatically</option> <option value="manual" <?php if ($is_delivery_spot && $spot_info[0]->close_order == "manual") { echo "selected='selected'"; } ?> title="<?php _e("Orders' submission will be closed manually by the user that is responsible for the delivery", OPEN_CSA_WP_DOMAIN); ?> "> <?php if ($is_delivery_spot && $spot_info[0]->close_order == "manual") { echo __('Order close', OPEN_CSA_WP_DOMAIN) . " "; } ?> manually</option> </select> <span <?php if (!$is_delivery_spot || $spot_info[0]->close_order != "automatic") { echo "style='display:none;color:gray'"; } else { echo "style='color:gray'"; } ?> id="open-csa-wp-spots_close_automatic" class="open-csa-wp-tip_spots" title="<?php _e("Orders' submission will be closed automatically when order submission deadline is reached", OPEN_CSA_WP_DOMAIN); ?> " > i.e. ... (point here)</span> <span <?php if (!$is_delivery_spot || $spot_info[0]->close_order != "manual") { echo "style='display:none;color:gray'"; } else { echo "style='color:gray'"; } ?> id="open-csa-wp-spots_close_manual" class="open-csa-wp-tip_spots" title="<?php _e("Orders' submission will be closed manually by the user that is responsible for the delivery", OPEN_CSA_WP_DOMAIN); ?> " > i.e. ... (point here)</span> <span id="open-csa-wp-showNewSpotForm_ordersClose_span_id"></span> </td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_parking_input" id="open-csa-wp-spots_parking_input_id" <?php $styleAttributes = "style='color:"; if (!$is_delivery_spot || $spot_info[0]->parking == "") { $styleAttributes = $styleAttributes . "#999'"; } else { if ($spot_info[0]->parking == "easy") { $styleAttributes = $styleAttributes . "blue'"; } else { if ($spot_info[0]->parking == "possible") { $styleAttributes = $styleAttributes . "green'"; } else { if ($spot_info[0]->parking == "hard") { $styleAttributes = $styleAttributes . "orange'"; } else { if ($spot_info[0]->parking == "impossible") { $styleAttributes = $styleAttributes . "brown'"; } } } } } echo $styleAttributes; ?> onfocus='getElementById("open-csa-wp-showNewSpotForm_parkingSpace_span_id").style.display = "none";' onchange=' this.style.color=this.options[this.selectedIndex].style.color; if (this.options[this.selectedIndex].text.split(" ")[0] != "Finding") { this.options[this.selectedIndex].text = "Finding parking space is " + this.options[this.selectedIndex].text; }' > <option value="" <?php if (!$is_delivery_spot || $spot_info[0]->parking == "") { echo "selected='selected'"; } ?> disabled="disabled" id="open-csa-wp-spots_parking_disabled_id"><?php _e("Finding parking space is", OPEN_CSA_WP_DOMAIN); ?> ...</option> <option value="easy" <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "easy") { echo "selected='selected'"; } ?> style="color:blue"> <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "easy") { echo __('Finding parking space is', OPEN_CSA_WP_DOMAIN) . " "; } ?> easy :)</option> <option value="possible" <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "possible") { echo "selected='selected'"; } ?> style="color:green"> <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "possible") { echo __('Finding parking space is', OPEN_CSA_WP_DOMAIN) . " "; } ?> possible :)</option> <option value="hard" <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "hard") { echo "selected='selected'"; } ?> style="color:orange"> <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "hard") { echo __('Finding parking space is', OPEN_CSA_WP_DOMAIN) . " "; } ?> hard :(</option> <option value="impossible" <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "impossible") { echo "selected='selected'"; } ?> style="color:brown"> <?php if ($is_delivery_spot && $spot_info[0]->parking != "" && $spot_info[0]->parking == "impossible") { echo __('Finding parking space is', OPEN_CSA_WP_DOMAIN) . " "; } ?> impossible :(</option> </select> <span style="display:none;color:blue" id="open-csa-wp-showNewSpotForm_parkingSpace_span_id"></span> </td></tr> <tr valign="top"><td> <select name="open-csa-wp-spots_refrigerator_input" id="open-csa-wp-spots_refrigerator_input_id" <?php $styleAttributes = "style='color:"; if (!$is_delivery_spot || $spot_info[0]->has_refrigerator == "") { $styleAttributes = $styleAttributes . "#999'"; } else { if ($spot_info[0]->has_refrigerator == "1") { $styleAttributes = $styleAttributes . "green'"; } else { if ($spot_info[0]->has_refrigerator == "0") { $styleAttributes = $styleAttributes . "brown'"; } } } echo $styleAttributes; ?> onfocus='getElementById("open-csa-wp-showNewSpotForm_hasRefrigerator_span_id").style.display = "none";' onchange=' (this.style.color=this.options[this.selectedIndex].style.color); if (this.options[this.selectedIndex].value == "yes") { this.options[this.selectedIndex].text = "<?php _e('It has refrigerator to store products', OPEN_CSA_WP_DOMAIN); ?> ! :)"; } else { this.options[this.selectedIndex].text = "<?php _e('It does not have refrigerator to store products', OPEN_CSA_WP_DOMAIN); ?> ! :(" }' > <option value="" <?php if (!$is_delivery_spot || $spot_info[0]->has_refrigerator == "") { echo "selected='selected'"; } ?> disabled="disabled" id="open-csa-wp-spots_refrigerator_disabled_id"><?php _e('Does it have refrigerator to store products', OPEN_CSA_WP_DOMAIN); ?> ...?</option> <option value="yes" style="color:green" <?php if ($is_delivery_spot && $spot_info[0]->has_refrigerator != "" && $spot_info[0]->has_refrigerator == "1") { echo "selected='selected'"; } ?> > <?php if ($is_delivery_spot && $spot_info[0]->has_refrigerator != "" && $spot_info[0]->has_refrigerator == "1") { echo __('It has refrigerator to store products', OPEN_CSA_WP_DOMAIN) . "! :) "; } else { echo __("yes", OPEN_CSA_WP_DOMAIN); } ?> </option> <option value="no" style="color:brown" <?php if ($is_delivery_spot && $spot_info[0]->has_refrigerator != "" && $spot_info[0]->has_refrigerator == "0") { echo "selected='selected'"; } ?> > <?php if ($is_delivery_spot && $spot_info[0]->has_refrigerator != "" && $spot_info[0]->has_refrigerator == "0") { echo _e('It does not have refrigerator to store products', OPEN_CSA_WP_DOMAIN) . "! :( "; } else { echo __("no", OPEN_CSA_WP_DOMAIN); } ?> </option> </select> <span style="display:none;color:blue" id="open-csa-wp-showNewSpotForm_hasRefrigerator_span_id"></span> </td></tr> </table> </div> <input type="submit" name="open-csa-wp-showNewSpot_button" id="open-csa-wp-showNewSpot_button_id" <?php if ($spot_id == null) { echo "\n\t\t\t\t\t\t\tvalue='" . __('Add Spot', OPEN_CSA_WP_DOMAIN) . "'\n\t\t\t\t\t\t\tonclick='open_csa_wp_new_spot_fields_validation(this, null, \"" . admin_url("/admin.php?page=csa_spots_management") . "\")'\n\t\t\t\t\t\t"; } else { echo "\n\t\t\t\t\t\t\tvalue='" . __('Update Spot', OPEN_CSA_WP_DOMAIN) . "'\n\t\t\t\t\t\t\tonclick='open_csa_wp_new_spot_fields_validation(this, {$spot_id}, \"" . admin_url("/admin.php?page=csa_spots_management") . "\")'\n\t\t\t\t\t\t"; } ?> class="button button-primary" title="<?php __('Please fill in required fields, i.e. those marked with (*)', OPEN_CSA_WP_DOMAIN); ?> " /> <input type="button" class="button button-secondary" <?php if ($spot_id == null) { echo "\n\t\t\t\t\tvalue='" . __('Reset Info', OPEN_CSA_WP_DOMAIN) . "'\n\t\t\t\t\tonclick='open_csa_wp_reset_spot_form();'"; } else { echo "\n\t\t\t\t\tvalue='" . __('Cancel', OPEN_CSA_WP_DOMAIN) . "'\n\t\t\t\t\tonclick='window.location.replace(\"" . admin_url('/admin.php?page=csa_spots_management') . "\")'\n\t\t\t\t\t'"; } ?> /> </form> <br/><br/> </div> <?php }
function open_csa_wp_show_delivery_orders_list($personal_user_id, $is_producer, $display) { wp_enqueue_script('open-csa-wp-general-scripts'); wp_enqueue_script('open-csa-wp-deliveries-scripts'); wp_enqueue_script('jquery.datatables'); wp_enqueue_script('jquery.jeditable'); wp_enqueue_script('jquery.blockui'); wp_enqueue_script('jquery.cluetip'); wp_enqueue_style('jquery.cluetip.style'); global $wpdb; if ($personal_user_id != null && $is_producer == false) { $deivery_orders_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " WHERE user_in_charge = %d ", $personal_user_id)); } else { $deivery_orders_count = $wpdb->get_var("SELECT COUNT(id) FROM " . OPEN_CSA_WP_TABLE_DELIVERIES); } if ($deivery_orders_count == 0) { if ($personal_user_id == null) { "<br/><div style='color:brown'>" . __('No delivery has yet been initiated.', OPEN_CSA_WP_DOMAIN) . "</div>"; } else { if ($is_producer == false) { echo "<br/><div style='color:brown'>" . __('You have not yet become responsible for any delivery.', OPEN_CSA_WP_DOMAIN) . "</div>"; } } } else { if ($personal_user_id) { $text_to_show = __("List", OPEN_CSA_WP_DOMAIN); } else { $text_to_show = __("Delivery Total Orders List", OPEN_CSA_WP_DOMAIN); } if ($is_producer === true) { $text_for_label = "showDeliveryOrdersListProducer"; } else { $text_for_label = "showDeliveryOrdersList"; } ?> <br /> <div id='open-csa-wp-<?php echo $text_for_label; ?> _header' > <span style="cursor:pointer" id="open-csa-wp-<?php echo $text_for_label; ?> _formHeader_text" onclick="open_csa_wp_toggle_form('<?php echo $text_for_label; ?> ','<?php echo $text_to_show; ?> ', '')"> <font size='4'> <?php if ($display == false) { echo "{$text_to_show} (" . __("show", OPEN_CSA_WP_DOMAIN) . ")"; } else { echo "{$text_to_show} (" . __("hide", OPEN_CSA_WP_DOMAIN) . ")"; } ?> </font> </span> </div> <div id="open-csa-wp-<?php echo $text_for_label; ?> _div" <?php if ($display == false) { echo 'style="display:none"'; } ?> > <span class='open-csa-wp-tip_order' title=' <?php _e('Deliveries in "green" are pending and still accept new orders.', OPEN_CSA_WP_DOMAIN); ?> | <?php _e('Deliveries in "brown" are pending and do not accept new orders.', OPEN_CSA_WP_DOMAIN); ?> | <?php _e('Deliveries in "grey" are accomplished.', OPEN_CSA_WP_DOMAIN); ?> | <?php _e('To view the total user orders for some delivery, click the "magnifier" icon.', OPEN_CSA_WP_DOMAIN); ?> '> <p style="color:green;font-style:italic; font-size:13px"> <?php _e('by pointing here you can read additional information...', OPEN_CSA_WP_DOMAIN); ?> </p></span> <table class='table-bordered' id="open-csa-wp-<?php echo $text_for_label; ?> _table" style='border-spacing:1em' > <thead class='tableHeader'> <tr> <th><?php _e('Spot', OPEN_CSA_WP_DOMAIN); ?> </th> <th><?php _e('Order Deadline Date', OPEN_CSA_WP_DOMAIN); ?> </th> <th><?php _e('Order Deadline Time', OPEN_CSA_WP_DOMAIN); ?> </th> <th><?php _e('Delivery Date', OPEN_CSA_WP_DOMAIN); ?> </th> <th><?php _e('Delivery Start Time', OPEN_CSA_WP_DOMAIN); ?> </th> <th><?php _e('Delivery End Time', OPEN_CSA_WP_DOMAIN); ?> </th> <?php if ($personal_user_id == null || $is_producer === true) { echo "<th>" . __('User In Charge', OPEN_CSA_WP_DOMAIN) . "</th>"; } ?> <th><?php _e('New Orders Can be Submitted?', OPEN_CSA_WP_DOMAIN); ?> </th> <th/> </tr> </thead> <tbody> <?php global $wpdb; $plugins_dir = plugins_url(); if ($personal_user_id == null || $is_producer === true) { $deliveries = $wpdb->get_results("SELECT * FROM " . OPEN_CSA_WP_TABLE_DELIVERIES); } else { $deliveries = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " WHERE user_in_charge = %d ", $personal_user_id)); } foreach ($deliveries as $delivery) { $delivery_id = $delivery->id; $spot_name = $wpdb->get_var($wpdb->prepare("SELECT spot_name FROM " . OPEN_CSA_WP_TABLE_SPOTS . " WHERE id=%d", $delivery->spot_id)); $user_in_charge_login = ""; if ($delivery->user_in_charge != null) { $user_in_charge_login = get_user_by('id', $delivery->user_in_charge)->user_login; } $past_delivery = false; $current_date_time = current_time('mysql'); if (strtotime($delivery->order_deadline_date . " " . $delivery->order_deadline_time) < strtotime($current_date_time)) { $past_delivery = true; } echo "\n\t\t\t\t\t\t<tr \n\t\t\t\t\t\t\tvalign='top' \n\t\t\t\t\t\t\tid='open-csa-wp-showDeliveriesDeliveryID_{$delivery_id}' \n\t\t\t\t\t\t\tclass='open-csa-wp-showDeliveries-delivery'\n\t\t\t\t\t\t\tstyle='color:" . ($past_delivery === true ? "gray" : ($delivery->are_orders_open == 1 ? "green" : "brown")) . "'\n\t\t\t\t\t\t>\n\t\t\t\t\t\t<td style='text-align:center'>{$spot_name} </td>\n\t\t\t\t\t\t<td style='text-align:center'>" . date(OPEN_CSA_WP_DATE_FORMAT_READABLE, strtotime($delivery->order_deadline_date)) . "</td>\n\t\t\t\t\t\t<td style='text-align:center'>" . open_csa_wp_remove_seconds($delivery->order_deadline_time) . "</td>\n\t\t\t\t\t\t<td style='text-align:center'>" . date(OPEN_CSA_WP_DATE_FORMAT_READABLE, strtotime($delivery->delivery_date)) . "</td>\n\t\t\t\t\t\t<td style='text-align:center'>" . open_csa_wp_remove_seconds($delivery->delivery_start_time) . "</td>\n\t\t\t\t\t\t<td style='text-align:center'>" . open_csa_wp_remove_seconds($delivery->delivery_end_time) . "</td>\n\t\t\t\t\t\t" . ($personal_user_id == null || $is_producer === true ? "<td style='text-align:center'>" . $user_in_charge_login . "</td>" : "") . "\n\t\t\t\t\t\t<td style='text-align:center'\n\t\t\t\t\t\t\tclass='editable_boolean'\n\t\t\t\t\t\t\tid = 'open-csa-wp-showDeliveriesOpenOrdersID_{$delivery_id}'\n\t\t\t\t\t\t>" . ($delivery->are_orders_open == 1 ? "yes" : "no") . "</td>\n\t\t\t\t\t\t<td style='text-align:center'> \n\t\t\t\t\t\t\t<img \n\t\t\t\t\t\t\t\twidth='24' height='24' \n\t\t\t\t\t\t\t\tclass='delete no-underline' \n\t\t\t\t\t\t\t\tsrc='{$plugins_dir}/open-csa-wp/icons/magnifier.png' \n\t\t\t\t\t\t\t\tstyle='cursor:pointer;padding-left:10px;' \n\t\t\t\t\t\t\t\tonclick='open_csa_wp_request_total_orders_of_delivery(" . $delivery_id . ", " . ($is_producer === true ? "{$personal_user_id}" : "null") . ");' \n\t\t\t\t\t\t\t\ttitle='" . __('click to view the total user orders for this delivery', OPEN_CSA_WP_DOMAIN) . "'/></td>\n\t\t\t\t\t\t</tr>\n\n\t\t\t\t\t"; } ?> </tbody> </table> </div> <?php } }
function CsaWpPluginGetReadableDeliveryInfo($delivery_id) { global $days_of_week, $wpdb; $delivery_info = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " WHERE id=%d", $delivery_id))[0]; $spotName = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\tSELECT DISTINCT " . OPEN_CSA_WP_TABLE_SPOTS . ".spot_name \n\t\t\t\t\t\t\t\t\tFROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " LEFT JOIN " . OPEN_CSA_WP_TABLE_SPOTS . " ON " . OPEN_CSA_WP_TABLE_DELIVERIES . ".spot_id = " . OPEN_CSA_WP_TABLE_SPOTS . ".id\n\t\t\t\t\t\t\t\t\tWHERE " . OPEN_CSA_WP_TABLE_DELIVERIES . ".id = %d\n\t\t\t\t\t\t\t\t", $delivery_id)); $deadlineDate = $delivery_info->order_deadline_date; $order_deadline_day = (date("w", strtotime($deadlineDate)) - 1) % 7; $deadline_day = $days_of_week[$order_deadline_day]; $delivery_date = $delivery_info->delivery_date; $delivery_day = (date("w", strtotime($delivery_date)) - 1) % 7; $delivery_day = $days_of_week[$delivery_day]; $delivery_info_readable = __('Delivery for spot', OPEN_CSA_WP_DOMAIN) . " {$spotName} " . __('with', OPEN_CSA_WP_DOMAIN) . "\n\t\t" . __('deadline on', OPEN_CSA_WP_DOMAIN) . " {$deadline_day} ," . date(OPEN_CSA_WP_DATE_FORMAT_READABLE, strtotime($deadlineDate)) . ", \n\t\t\tup to " . open_csa_wp_remove_seconds($delivery_info->order_deadline_time) . ",\n\t\t" . __('and delivery on', OPEN_CSA_WP_DOMAIN) . " {$delivery_day}," . date(OPEN_CSA_WP_DATE_FORMAT_READABLE, strtotime($delivery_date)) . ", \n\t\t\t" . __('from', OPEN_CSA_WP_DOMAIN) . " " . open_csa_wp_remove_seconds($delivery_info->delivery_start_time) . "\n\t\t\t" . __('up to', OPEN_CSA_WP_DOMAIN) . " " . open_csa_wp_remove_seconds($delivery_info->delivery_end_time); return $delivery_info_readable; }