PHP - Wordpress Woocommerce Advice

I'm trying to show on my order printed receipt some checkout fields and extras from the products.

The website is www.prontoitaliano.co.uk/shop

What needs to appear on the receipt are all the extras options from all the products(See checkboxes in all pasta dishes and checkboxes toppings in "create your own pizza") and 2 fields from the checkout page (Pick up Date, Pick up Time).

To send the order to the printer I'm using the "Star cloud PRNT woocommerce" plugin and for the pickup date and time fields "ultimate woocommerce delivery and pickup date time", I've attached below the code that needs to be edited to add more fields to the receipt. I know that probably it's not difficult to solve my issue but I don't have any knowledge of php and I hope you guys can assist me. Also, I've attached a picture showing what is missing on the printed receipt and what result I'm trying to get. Thanks for your time!

 

<?php
function star_cloudprnt_get_column_separated_data($columns)
{
    $max_chars = STAR_CLOUDPRNT_MAX_CHARACTERS_THREE_INCH;
    $total_columns = count($columns);

    if ($total_columns == 0) return "";
    if ($total_columns == 1) return $columns[0];
    if ($total_columns == 2)
    {
        $total_characters = strlen($columns[0])+strlen($columns[1]);
        $total_whitespace = $max_chars - $total_characters;
        if ($total_whitespace < 0) return "";
        return $columns[0].str_repeat(" ", $total_whitespace).$columns[1];
    }

    $total_characters = 0;
    foreach ($columns as $column)
    {
        $total_characters += strlen($column);
    }
    $total_whitespace = $max_chars - $total_characters;
    if ($total_whitespace < 0) return "";
    $total_spaces = $total_columns-1;
    $space_width = floor($total_whitespace / $total_spaces);
    $result = $columns[0].str_repeat(" ", $space_width);
    for ($i = 1; $i < ($total_columns-1); $i++)
    {
        $result .= $columns[$i].str_repeat(" ", $space_width);
    }
    $result .= $columns[$total_columns-1];

    return $result;
}

function star_cloudprnt_get_seperator()
{
    $max_chars = STAR_CLOUDPRNT_MAX_CHARACTERS_THREE_INCH;
    return str_repeat('_', $max_chars);
}

function star_cloudprnt_parse_order_status($status)
{
    if ($status === 'wc-pending') return 'Pending Payment';
    else if ($status === 'wc-processing') return 'Processing';
    else if ($status === 'wc-on-hold') return 'On Hold';
    else if ($status === 'wc-completed') return 'Completed';
    else if ($status === 'wc-cancelled') return 'Cancelled';
    else if ($status === 'wc-refunded') return 'Refunded';
    else if ($status === 'wc-failed') return 'Failed';
    else return "Unknown";
}

function star_cloudprnt_get_codepage_1252_currency_symbol()
{
    $symbol = get_woocommerce_currency_symbol();
    if ($symbol === "&pound;") return "\xA3"; // £ pound
    else if ($symbol === "&#36;") return "\x24"; // $ dollar
    else if ($symbol === "&euro;") return "\x80"; // € euro
    return ""; // return blank by default
}

function star_cloudprnt_get_formatted_variation($variation, $order, $item_id) 
{
    $return = '';
    if (is_array($variation))
    {
        $variation_list = array();
        foreach ($variation as $name => $value)
        {
            // If the value is missing, get the value from the item
            if (!$value)
            {
                $meta_name = esc_attr(str_replace('attribute_', '', $name));
                $value = $order->get_item_meta($item_id, $meta_name, true);
            }

            // If this is a term slug, get the term's nice name
            if (taxonomy_exists(esc_attr(str_replace('attribute_', '', $name))))
            {
                $term = get_term_by('slug', $value, esc_attr(str_replace('attribute_', '', $name)));
                if (!is_wp_error($term) && ! empty($term->name))
                {
                    $value = $term->name;
                }
            }
            else
            {
                $value = ucwords(str_replace( '-', ' ', $value ));
            }
            $variation_list[] = wc_attribute_label(str_replace('attribute_', '', $name)) . ': ' . rawurldecode($value);
        }
        $return .= implode('||', $variation_list);
    }
    return $return;
}

function star_cloudprnt_create_receipt_items($order, &$printer)
{
    $order_items = $order->get_items();
    foreach ($order_items as $item_id => $item_data)
    {
        $product_name = $item_data['name'];
        $product_id = $item_data['product_id'];
        $variation_id = $item_data['variation_id'];

        $item_qty = $order->get_item_meta($item_id, "_qty", true);
        $item_total_price = floatval($order->get_item_meta($item_id, "_line_total", true))
                        +floatval($order->get_item_meta($item_id, "_line_tax", true));
        $item_price = floatval($item_total_price) / intval($item_qty);
        $currencyHex = star_cloudprnt_get_codepage_1252_currency_symbol();
        $formatted_item_price = number_format($item_price, 2, '.', '');
        $formatted_total_price = number_format($item_total_price, 2, '.', '');

        $printer->set_text_emphasized();
        $printer->add_text_line(str_replace('&ndash;', '-', $product_name)." - ID: ".$product_id."");
        $printer->cancel_text_emphasized();

        if ($variation_id != 0)
        {
            $product_variation = new WC_Product_Variation( $variation_id );
            $variation_data = $product_variation->get_variation_attributes();
            $variation_detail = star_cloudprnt_get_formatted_variation($variation_data, $order, $item_id); 
            $exploded = explode("||", $variation_detail);
            foreach($exploded as $exploded_variation)
            {
                $printer->add_text_line(" ".ucwords($exploded_variation));
            }
        }
        $printer->add_text_line(star_cloudprnt_get_column_separated_data(array(" Qty: ".
                    $item_qty." x Cost: ".$currencyHex.$formatted_item_price,
                    $currencyHex.$formatted_total_price)));
    }
}

function star_cloudprnt_create_address($order, $order_meta, &$printer)
{
    $fname = $order_meta[_shipping_first_name][0];
    $lname = $order_meta[_shipping_last_name][0];
    $a1 = $order_meta[_shipping_address_1][0];
    $a2 = $order_meta[_shipping_address_2][0];
    $city = $order_meta[_shipping_city][0];
    $state = $order_meta[_shipping_state][0];
    $postcode = $order_meta[_shipping_postcode][0];
    $tel = $order_meta[_billing_phone][0];

    $printer->set_text_emphasized();
    if ($a1 == '')
    {
        $printer->add_text_line("Billing Address:");
        $printer->cancel_text_emphasized();
        $fname = $order_meta[_billing_first_name][0];
        $lname = $order_meta[_billing_last_name][0];
        $a1 = $order_meta[_billing_address_1][0];
        $a2 = $order_meta[_billing_address_2][0];
        $city = $order_meta[_billing_city][0];
        $state = $order_meta[_billing_state][0];
        $postcode = $order_meta[_billing_postcode][0];
    }
    else
    {
        $printer->add_text_line("Shipping Address:");
        $printer->cancel_text_emphasized();
    }

    $printer->add_text_line($fname." ".$lname);
    $printer->add_text_line($a1);
    if ($a2 != '') $printer->add_text_line($a2);
    if ($city != '') $printer->add_text_line($city);
    if ($state != '') $printer->add_text_line($state);
    if ($postcode != '') $printer->add_text_line($postcode);
    $printer->add_text_line("Tel: ".$tel);
}

function star_cloudprnt_print_order_summary($selectedPrinter, $file, $order_id)
{
    $order = wc_get_order($order_id);
    $shipping_items = @array_shift($order->get_items('shipping'));
    $order_meta = get_post_meta($order_id);

    $printer = new Star_CloudPRNT_Star_Line_Mode_Job($selectedPrinter, $file);
    $printer->set_codepage("20"); // 20 hex == 32 decimal == 1252 Windows Latin-1
    if (get_option('star-cloudprnt-print-logo-top-input')) $printer->add_nv_logo(esc_attr(get_option('star-cloudprnt-print-logo-top-input')));
    $printer->set_text_emphasized();
    $printer->set_text_center_align();
    $printer->add_text_line("ORDER NOTIFICATION");
    $printer->set_text_left_align();
    $printer->cancel_text_emphasized();
    $printer->add_new_line(1);
    $printer->add_text_line(star_cloudprnt_get_column_separated_data(array("Order #".$order_id, date("d-m-y H:i:s", time()))));
    $printer->add_new_line(1);
    $printer->add_text_line("Order Status: ".star_cloudprnt_parse_order_status($order->post->post_status));
    $printer->add_text_line("Order Date: ".$order->order_date);                     
    if (isset($shipping_items['name']))
    {
        $printer->add_new_line(1);
        $printer->add_text_line("Shipping Method: ".$shipping_items['name']);
    }
    $printer->add_text_line("Payment Method: ".$order_meta[_payment_method_title][0]);
    $printer->add_new_line(1);
    $printer->add_text_line(star_cloudprnt_get_column_separated_data(array('ITEM', 'TOTAL')));
    $printer->add_text_line(star_cloudprnt_get_seperator());

    star_cloudprnt_create_receipt_items($order, $printer);

    $printer->add_new_line(1);
    $printer->set_text_right_align();
    $formatted_overall_total_price = number_format($order_meta[_order_total][0], 2, '.', '');
    $printer->add_text_line("TOTAL     ".star_cloudprnt_get_codepage_1252_currency_symbol().$formatted_overall_total_price);
    $printer->set_text_left_align();
    $printer->add_new_line(1);
    $printer->add_text_line("All prices are inclusive of tax (if applicable).");
    $printer->add_new_line(1);

    star_cloudprnt_create_address($order, $order_meta, $printer);

    $printer->add_new_line(1);
    $printer->set_text_emphasized();
    $printer->add_text_line("Customer Provided Notes:");
    $printer->cancel_text_emphasized();
    $printer->add_text(empty($order->post->post_excerpt) ? "None" : $order->post->post_excerpt);
    if (get_option('star-cloudprnt-print-logo-bottom-input')) $printer->add_nv_logo(esc_attr(get_option('star-cloudprnt-print-logo-bottom-input')));

    $printer->printjob();
}

function star_cloudprnt_woo_on_thankyou($order_id)
{
    $file = STAR_CLOUDPRNT_PRINTER_PENDING_SAVE_PATH.star_cloudprnt_get_os_path("/order_".$order_id."_".time().".bin");

    $selectedPrinter = "";
    $printerList = star_cloudprnt_get_printer_list();
    if (!empty($printerList))
    {
        foreach ($printerList as $printer)
        {
            if (get_option('star-cloudprnt-printer-select') == $printer['name'])
            {
                $selectedPrinter = $printer['printerMAC'];
                break;
            }
        }

        if ($selectedPrinter === "" && count($printerList) === 1) $selectedPrinter = $printer['printerMAC'];

        if ($selectedPrinter !== "") star_cloudprnt_print_order_summary($selectedPrinter, $file, $order_id);
    }
}

function star_cloudprnt_setup_order_handler()
{
    if (selected(get_option('star-cloudprnt-select'), "enable", false) !== "" && star_cloudprnt_is_woo_activated())
    {
        add_action('woocommerce_thankyou', 'star_cloudprnt_woo_on_thankyou', 1, 1);
    }
}

 

Dear forum,
my name is Dominic from germany.

I`m always trying hard, but after 5 hours I really need some help in php coding.

My problem deals with my checkout page for woocommerce.

At the moment, my legal terms are above the total-order-table where u can find the booked product, order-subtotal, order-total and tex-total.

But I need to display the legal terms under my total-order table. I need the terms directly above the "Buy now" button.

Do you guys know which file to modify ? I tried everything. Nothing worked for me.

You will find a picture in this post. There you can see my problem. 

Would be pretty nice if you can give me some information.

Kind regards,
Dominic Lindner

I have a php tutorial that I followed for creating, inserting, selecting and updating a MySQL database with php.  Everything works fine so I wanted to put it into Wordpress.  I took the code and placed it into the wordpress page and everything worked just fine except the update function. 

Here is the tutorial I used. http://www.phpsimple.net/mysql_insert_record.html  It is also the part I am having trouble with.  I am able to create a record and I am also able to select a record but when I choose "update" the form doesn't load the data.  It will outside the website but not inside wordpress.  I am hoping this is not vague but because of my inexperience I am not sure what else to say.  I will be more than happy to provide any other information you need.

I'm using a woocommerce order report plugin, some customers order multiple products but order report shows only number of order and one product name: I want to see all product names: also I want to see customer notes it doesn't show up

 

<?php

/**

 * Plugin Name: Custom Order Report

 * Description: Generates a report on individual WooCommerce products sold during a specified time period.

 * Version: 1.4.8

 */





// Add the Product Sales Report to the WordPress admin

add_action('admin_menu', 'hm_psrf_admin_menu');

function hm_psrf_admin_menu() {

	add_submenu_page('woocommerce', 'Custom Order Report', 'Custom Order Report', 'view_woocommerce_reports', 'hm_sbpf', 'hm_sbpf_page');

}



function hm_psrf_default_report_settings() {

	return array(

		'report_time' => '30d',

		'report_start' => date('Y-m-d', current_time('timestamp') - (86400 * 31)),

		'report_end' => date('Y-m-d', current_time('timestamp') - 86400),

		'order_statuses' => array('wc-processing', 'wc-on-hold', 'wc-completed'),

		'products' => 'all',

		'product_cats' => array(),

		'product_ids' => '',

		'variations' => 0,

		'orderby' => 'quantity',

		'orderdir' => 'desc',

		'fields' => array('product_id', 'product_sku', 'product_name', 'quantity_sold', 'gross_sales'),

		'limit_on' => 0,

		'limit' => 10,

		'include_header' => 1,

		'exclude_free' => 0

	);

}



// This function generates the Product Sales Report page HTML

function hm_sbpf_page() {



	$savedReportSettings = get_option('hm_psr_report_settings');

	if (isset($_POST['op']) && $_POST['op'] == 'preset-del' && !empty($_POST['r']) && isset($savedReportSettings[$_POST['r']])) {

		unset($savedReportSettings[$_POST['r']]);

		update_option('hm_psr_report_settings', $savedReportSettings);

		$_POST['r'] = 0;

		echo('<script type="text/javascript">location.href = location.href;</script>');

	}

	

	$reportSettings = (empty($savedReportSettings) ?

						hm_psrf_default_report_settings() :

						array_merge(hm_psrf_default_report_settings(),

								$savedReportSettings[

									isset($_POST['r']) && isset($savedReportSettings[$_POST['r']]) ? $_POST['r'] : 0

								]

						));

	

	// For backwards compatibility with pre-1.4 versions

	if (!empty($reportSettings['cat'])) {

		$reportSettings['products'] = 'cats';

		$reportSettings['product_cats'] = array($reportSettings['cat']);

	}

	

	$fieldOptions = array(
         
         'order_id' => 'Order ID',
		/*'product_id' => 'Product ID',*/
        'customer_name' => 'Customer Name',
		/*'variation_id' => 'Variation ID',*/
		'city' => 'City',
        'address' => 'Address',
        'product_name' => 'Product Name',
        'quantity_sold' => 'Quantity Sold',
		/*'product_sku' => 'Product SKU',*/
		'gross_sales' => 'Gross Sales',
		'product_categories' => 'Schools',
		/*'variation_attributes' => 'Variation Attributes',*/
		/*'gross_after_discount' => 'Gross Sales (After Discounts)'*/
        'ceremony_date' => 'Ceremony Date',
        'ceremony_time' => 'Ceremony Time',
	);

		

	include(dirname(__FILE__).'/admin.php');

}



// Hook into WordPress init; this function performs report generation when

// the admin form is submitted

add_action('init', 'hm_sbpf_on_init', 9999);

function hm_sbpf_on_init() {

	global $pagenow;

	

	// Check if we are in admin and on the report page

	if (!is_admin())

		return;

	if ($pagenow == 'admin.php' && isset($_GET['page']) && $_GET['page'] == 'hm_sbpf' && !empty($_POST['hm_sbp_do_export'])) {

		

		// Verify the nonce

		check_admin_referer('hm_sbpf_do_export');

		

		$newSettings = array_intersect_key($_POST, hm_psrf_default_report_settings());

		foreach ($newSettings as $key => $value)

			if (!is_array($value))

				$newSettings[$key] = htmlspecialchars($value);

		

		// Update the saved report settings

		$savedReportSettings = get_option('hm_psr_report_settings');

		$savedReportSettings[0] = array_merge(hm_psrf_default_report_settings(), $newSettings);

		



		update_option('hm_psr_report_settings', $savedReportSettings);

		

		// Check if no fields are selected or if not downloading

		if (empty($_POST['fields']) || empty($_POST['hm_sbp_download']))

			return;

		

		

		// Assemble the filename for the report download

		$filename =  'Product Sales - ';

		if (!empty($_POST['cat']) && is_numeric($_POST['cat'])) {

			$cat = get_term($_POST['cat'], 'product_cat');

			if (!empty($cat->name))

				$filename .= addslashes(html_entity_decode($cat->name)).' - ';

		}

		$filename .= date('Y-m-d', current_time('timestamp')).'.csv';

		

		// Send headers

		header('Content-Type: text/csv');

		header('Content-Disposition: attachment; filename="'.$filename.'"');

		

		// Output the report header row (if applicable) and body

		$stdout = fopen('php://output', 'w');

		if (!empty($_POST['include_header']))

			hm_sbpf_export_header($stdout);

		hm_sbpf_export_body($stdout);

		

		exit;

	}

}



// This function outputs the report header row

function hm_sbpf_export_header($dest, $return=false) {

	$header = array();

	

	foreach ($_POST['fields'] as $field) {

		switch ($field) {

			case 'order_id':

				$header[] = 'Order ID';

				break;
            case 'product_name':

				$header[] = 'Product Name';

				break;
			case 'quantity_sold':

				$header[] = 'Quantity Sold';

				break;	
			case 'gross_sales':

				$header[] = 'Gross Sales';

				break;	
			case 'product_categories':

				$header[] = 'Schools';

				break;		
            case 'customer_name':

				$header[] = 'Customer Name';

				break;
			case 'city':

				$header[] = 'City';

				break;
			case 'address':

				$header[] = 'Address';

				break;		
			
			case 'ceremony_date':

				$header[] = 'Ceremony Date';

				break;
		    case 'ceremony_time':

				$header[] = 'Ceremony Time';

				break;				

		}

	}

	

	if ($return)

		return $header;

	fputcsv($dest, $header);

}



// This function generates and outputs the report body rows

function hm_sbpf_export_body($dest, $return=false) {

	global $woocommerce, $wpdb;

	

	$product_ids = array();

	if ($_POST['products'] == 'cats') {

		$cats = array();

		foreach ($_POST['product_cats'] as $cat)

			if (is_numeric($cat))

				$cats[] = $cat;

		$product_ids = get_objects_in_term($cats, 'product_cat');

	} else if ($_POST['products'] == 'ids') {

		foreach (explode(',', $_POST['product_ids']) as $productId) {

			$productId = trim($productId);

			if (is_numeric($productId))

				$product_ids[] = $productId;

		}

	}

	

	// Calculate report start and end dates (timestamps)

	switch ($_POST['report_time']) {

		case '0d':

			$end_date = strtotime('midnight', current_time('timestamp'));

			$start_date = $end_date;

			break;

		case '1d':

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date;

			break;

		case '7d':

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date - (86400 * 6);

			break;

		case '1cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight -1month');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '0cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '+1cm':

			$start_date = strtotime(date('Y-m', current_time('timestamp')).'-01 midnight +1month');

			$end_date = strtotime('+1month', $start_date) - 86400;

			break;

		case '+7d':

			$start_date = strtotime('midnight', current_time('timestamp')) + 86400;

			$end_date = $start_date + (86400 * 6);

			break;

		case '+30d':

			$start_date = strtotime('midnight', current_time('timestamp')) + 86400;

			$end_date = $start_date + (86400 * 29);

			break;

		case 'custom':

			$end_date = strtotime('midnight', strtotime($_POST['report_end']));

			$start_date = strtotime('midnight', strtotime($_POST['report_start']));

			break;

		default: // 30 days is the default

			$end_date = strtotime('midnight', current_time('timestamp')) - 86400;

			$start_date = $end_date - (86400 * 29);

	}

	

	// Assemble order by string

	$orderby = (in_array($_POST['orderby'], array('product_id', 'gross', 'gross_after_discount')) ? $_POST['orderby'] : 'quantity');

	$orderby .= ' '.($_POST['orderdir'] == 'asc' ? 'ASC' : 'DESC');

	

	// Create a new WC_Admin_Report object

	include_once($woocommerce->plugin_path().'/includes/admin/reports/class-wc-admin-report.php');

	$wc_report = new WC_Admin_Report();

	$wc_report->start_date = $start_date;

	$wc_report->end_date = $end_date;

	

	//echo(date('Y-m-d', $end_date));

	

	$where_meta = array();

	if ($_POST['products'] != 'all') {

		$where_meta[] = array(

			'type' => 'order_item_meta',

			'meta_key' => '_product_id',

			'operator' => 'in',

			'meta_value' => $product_ids

		);

	}

	if (!empty($_POST['exclude_free'])) {

		$where_meta[] = array(

			'meta_key' => '_line_total',

			'meta_value' => 0,

			'operator' => '!=',

			'type' => 'order_item_meta'

		);

	}

	

	// Get report data

	

	// Avoid max join size error

	$wpdb->query('SET SQL_BIG_SELECTS=1');

	

	// Prevent plugins from overriding the order status filter

	add_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);

	

	// Based on woocoommerce/includes/admin/reports/class-wc-report-sales-by-product.php

	$sold_products = $wc_report->get_order_report_data(array(

		'data' => array(

			'_product_id' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => '',

				'name' => 'product_id'

			),

			'_qty' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'quantity'

			),

			'_line_subtotal' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'gross'

			),

			'_line_total' => array(

				'type' => 'order_item_meta',

				'order_item_type' => 'line_item',

				'function' => 'SUM',

				'name' => 'gross_after_discount'

			),
            /*usama*/
			'order_id' => array(

				'type' => 'order_item',

				'order_item_type' => 'line_item',

				'function' => '',

				'name' => 'order_id'
			)
             /*usama*/
		),

		'query_type' => 'get_results',

		'group_by' => 'order_id',

		'where_meta' => $where_meta,

		'order_by' => $orderby,

		'limit' => (!empty($_POST['limit_on']) && is_numeric($_POST['limit']) ? $_POST['limit'] : ''),

		'filter_range' => ($_POST['report_time'] != 'all'),

		'order_types' => wc_get_order_types('order_count'),

		'order_status' => hm_psrf_report_order_statuses()

	));

	

	// Remove report order statuses filter

	remove_filter('woocommerce_reports_order_statuses', 'hm_psrf_report_order_statuses', 9999);

	

	if ($return)

		$rows = array();



	// Output report rows

	foreach ($sold_products as $product) {

		$row = array();

		
         /*usama*/
		$order = wc_get_order($product->order_id);
        $customerName =  $order->get_billing_first_name().' '.$order->get_billing_last_name();
        $billingCity = $order->get_billing_city();
        $billingAddress1 = $order->get_billing_address_1();
        
        //echo $product->order_id;
        //echo $customerName.$city.$billingAddress1;
		//echo '<pre>';print_r($order);exit;
         /*usama*/
		foreach ($_POST['fields'] as $field) {

			switch ($field) {

				case 'order_id':

					$row[] = $product->order_id;

					break;
				case 'product_name':

					$row[] = html_entity_decode(get_the_title($product->product_id));

					break;

				case 'quantity_sold':

					$row[] = $product->quantity;

					break;

				case 'gross_sales':

					$row[] = $product->gross;

					break;	
				/*case 'variation_id':

					$row[] = (empty($product->variation_id) ? '' : $product->variation_id);

					break;

				case 'product_sku':

					$row[] = get_post_meta($product->product_id, '_sku', true);

					break;*/
				case 'product_categories':

					$terms = get_the_terms($product->product_id, 'product_cat');

					if (empty($terms)) {

						$row[] = '';

					} else {

						$categories = array();

						foreach ($terms as $term)

							$categories[] = $term->name;

						$row[] = implode(', ', $categories);

					}

				break;	
                case 'customer_name':

					$row[] = $customerName;

					break;
                case 'city':

					$row[] = $billingCity;

					break;
				case 'address':

					$row[] = $billingAddress1;

					break;


				/*case 'gross_after_discount':

					$row[] = $product->gross_after_discount;

					break;*/


                /*usama*/
				
				case 'ceremony_date':

					$row[] = $order->get_meta( '_billing_myfield12', true );

					break;
				case 'ceremony_time':

					$row[] = $order->get_meta( '_billing_myfield13', true );

					break;

			}

		}

			

		if ($return)

			$rows[] = $row;

		else

			fputcsv($dest, $row);

	}

	if ($return)

		return $rows;

}



add_action('admin_enqueue_scripts', 'hm_psrf_admin_enqueue_scripts');

function hm_psrf_admin_enqueue_scripts() {

	wp_enqueue_style('hm_psrf_admin_style', plugins_url('css/hm-product-sales-report.css', __FILE__));

	wp_enqueue_style('pikaday', plugins_url('css/pikaday.css', __FILE__));

	wp_enqueue_script('moment', plugins_url('js/moment.min.js', __FILE__));

	wp_enqueue_script('pikaday', plugins_url('js/pikaday.js', __FILE__));

}



// Schedulable email report hook

add_filter('pp_wc_get_schedulable_email_reports', 'hm_psrf_add_schedulable_email_reports');

function hm_psrf_add_schedulable_email_reports($reports) {

	$reports['hm_psr'] = array(

		'name' => 'Product Sales Report',

		'callback' => 'hm_psrf_run_scheduled_report',

		'reports' => array(

			'last' => 'Last used settings'

		)

	);

	return $reports;

}



function hm_psrf_run_scheduled_report($reportId, $start, $end, $args=array(), $output=false) {

	$savedReportSettings = get_option('hm_psr_report_settings');

	if (!isset($savedReportSettings[0]))

		return false;

	$prevPost = $_POST;

	$_POST = $savedReportSettings[0];

	$_POST['report_time'] = 'custom';

	$_POST['report_start'] = date('Y-m-d', $start);

	$_POST['report_end'] = date('Y-m-d', $end);

	$_POST = array_merge($_POST, array_intersect_key($args, $_POST));

	

	if ($output) {

		echo('<table><thead><tr>');

		foreach (hm_sbpf_export_header(null, true) as $heading) {

			echo("<th>$heading</th>");

		}

		echo('</tr></thead><tbody>');

		foreach (hm_sbpf_export_body(null, true) as $row) {

			echo('<tr>');

			foreach ($row as $cell)

				echo('<td>'.htmlspecialchars($cell).'</td>');

			echo('</tr>');

		}

		echo('</tbody></table>');

		$_POST = $prevPost;

		return;

	}

	

	$filename = get_temp_dir().'/Product Sales Report.csv';

	$out = fopen($filename, 'w');

	if (!empty($_POST['include_header']))

		hm_sbpf_export_header($out);

	hm_sbpf_export_body($out);

	fclose($out);

	

	$_POST = $prevPost;

	

	return $filename;

}



function hm_psrf_report_order_statuses() {

	$wcOrderStatuses = wc_get_order_statuses();

	$orderStatuses = array();

	if (!empty($_POST['order_statuses'])) {

		foreach ($_POST['order_statuses'] as $orderStatus) {

			if (isset($wcOrderStatuses[$orderStatus]))

				$orderStatuses[] = substr($orderStatus, 3);

		}

	}

	return $orderStatuses;

}



/* Review/donate notice */



register_activation_hook(__FILE__, 'hm_psrf_first_activate');

function hm_psrf_first_activate() {

	$pre = 'hm_psr';

	$firstActivate = get_option($pre.'_first_activate');

	if (empty($firstActivate)) {

		update_option($pre.'_first_activate', time());

	}

}

if (is_admin() && get_option('hm_psr_rd_notice_hidden') != 1 && time() - get_option('hm_psr_first_activate') >= (14*86400)) {

	add_action('admin_notices', 'hm_psrf_rd_notice');

	add_action('wp_ajax_hm_psrf_rd_notice_hide', 'hm_psrf_rd_notice_hide');

}

function hm_psrf_rd_notice() {

	$pre = 'hm_psr';

	$slug = 'product-sales-report-for-woocommerce';

	echo('

		<div id="'.$pre.'_rd_notice" class="updated notice is-dismissible"><p>Do you use the <strong>Product Sales Report</strong> plugin?

		Please support our free plugin by <a href="" target="_blank">making a donation</a>!product-sales-report-for-woocommerce

		Thanks!</p></div>

		<script>jQuery(document).ready(function($){$(\'#'.$pre.'_rd_notice\').on(\'click\', \'.notice-dismiss\', function(){jQuery.post(ajaxurl, {action:\'hm_psrf_rd_notice_hide\'})});});</script>

	');

}

function hm_psrf_rd_notice_hide() {

	$pre = 'hm_psr';

	update_option($pre.'_rd_notice_hidden', 1);

}

?>

 

for those of you who don't know i am creating a piece of forum software called ASF. Ive done it by myself so far but as it grows i find it harder to write the code and keep organised. my code is a mess and things arent done the way they should be. So if anyone can give me advice or wants to help i could post some of the files for download. Even if you just want to have a look and let me know waht you think.

Thanks
Carl

http://www.thevault.cz.cc

So here's my problem I'm not sure how to approach this:

I have a table with user_items which are stored together separated by commas.
Code: [Select]
13,12,11,9,27,15,16,22,21,23,24,26,29,30,31,32,33
Now, I have a script where the user is in a trade and I want to verify the item they are trying to trade, but is there an alternative other than grabbing all of that users' items and checking that one item with all of the records?

I've tried using
Code: [Select]
SELECT * FROM MYTABLE WHERE user_item_id IN(33)
As an example to see if it will pull the rows with that ID.  It didn't seem to work, am I doing it wrong? if so, forgive me. Any suggestions/help? The main problem is I don't want to have to explode that data and use a foreach to check that one item against all of that users items, as they could have well over 500.

Right now I have a SESSION so when users flip though pages they carry their info with them, what I'm trying to do now is that userhome.php can't be accesses unless the user just was succesful in cracking there system.. game I'm creating for those of you helping and following me while I do this! it's a virutal hacking simulation and where I'm now is that the user's passwordcracker was compared to the target systems 'systemkey' and either granted him access or didn't, if it did it displayed a progress bar then fowarded to userhome.php where the target users info will lay, right now though if I just type in userhome.php i get there without haveing the crack it.... any ideas?

In short i want to use the following code below, when someone selects there option and submits it, it would bring up details from the database on this user from the selected table, can you explain what it would be called doing this so i can look it up, Sorry to be a pain, Cheers.

Code: [Select]
<select name="target2" id="target2">

    <option value=""></option>

  <?php

  $sql = "SELECT player_id, friend_id, name, is_active FROM contacts as c JOIN players as p ON c.friend_id = p.id WHERE c.player_id = $playerID AND is_active = 1 ORDER BY name ASC";

  $que = mysql_query($sql) or die(mysql_error());

  while($list = mysql_fetch_array($que)) {

  ?>

  <option value="<?php echo $list['friend_id'] ?>"><?php echo $list['name'] ?></option>

  <?php } ?>

  </select>

Hi, basically i have data in my database i want to represent as cash, i currently put the dollar sign infront of each echo which is fine, but how would i go about adding , to the php code itself as you cannot do this from the sql database..

Hi all,

I am looking as a pet project to develop a review site, with the info stored in a database by id and the information grabbed bet get id and then displayed on a dynamic page, eg review.php?id=1

My question is this, if i throw keywords into the mix for each review, will search engines cache a review like this? Or would I need static pages for google etc to find the info?

Thanks

Hello, can someone please advice me on what scripts I will need to accomplish the following.

I want users to be able to login to their personal page, on there will be items such as pdf files, jpeg files etc, that they will be able to download.

Are there any free scripts out there that can do this, that anyone knows of? I don't mind paying if its a cheapish script for one of you to make for me, but money is a bit tight at the moment so a free script would be my 1st choice...

Thanks for all your help

Hello world,   Im a development fan,but not a coder.   Im planning to hire a developer for a project but i want some advice from experts first.   My project is a market place where sellers and stores could place their ads, I want it very very custom,so here are the questions.   1. Do i use php from scratch or maybe a CMS?   2.Is there a possibly to develop a custom cms to admin this project if it has been developed on php or i have to learn to code by the way?   3.how i can detail exactly what i want to the coder,is there a glossary or something like that for the modules?   this is the question that came up now,but fell free of give me all advice you think i might know.   Thanks.   

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=328588.0

I have a restricted page for members of a website. This restricted area is within a directory called 'download.'

There is a login form on two pages (home and support pages, found in the main menu). These pages are on the site root directory. When the user successfully logs in they are taken inside the download directory to index.php.

This index.php has a different look to the site root design. I have since redesigned this page to have the same structure as the site root pages.

I would love for the user to able to navigate around the main site if they wanted, and when they clicked support in the menu they would have all the download files there on the page, instead of a login form.

My question is how would I implement this login so that when the user logs in the support page changes from the login page to the page with the files.

I don't want to to duplicate the site within the download directory, I was hoping for an efficient method, but I am unsure how to go about it. 

Was wondering if anyone had any thoughts on how im running settings on my text base game.

I currently have like 60 settings stored in the data base. These are only admin control settings. They set what things cost in the game and such.

I was thinking today that would it be better instead of running a query on every page to grab the settings that page uses. I just simply  do one huge select ALL query for the settings when a user logs in and turn all the setting into super global $_SESSION.

Also this way any function i made i can simply use the SESSION instead of grabing settings out side the function or creating a query for it with in the function.

So i was thinking doing this would extremly speed up my game wouldnt it?
wondering if anyone has any thoughts on this