PHP - Wordpress / Woocommerce Question

I need to copy a table from one code to another. But I couldn't figure out how to do it properly. Just tried to copy code from one file to another but it doesn't work the same. I need to find where to change the code to show right columns.

https://easyupload.io/maoa9h - zipped cart.php (original code with right table) and review.php (the one that doesn't show right table)
 

We need to copy the table from cart.php:
https://ibb.co/MZ7K7S5 - table look

But it doesn't work. The quantity column doesn't show in review.php - as you can see here https://ibb.co/brP0yy1

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);

}

?>

 

I am new here I dont know if I am breaching any policy by posting questions.   Are there any Tutorials that can give me input for wordpress basics such as listed here   -  http://codex.wordpress.org/Plugin_API http://codex.wordpre...Class_Reference   I would be indebted if you can help me with that.   Looking Forward. Cheers!

I've been trying to use an example I got off of this forum.
The PHP file works fine as a separate PHP file.
When it's adding into a wp page the following results occur;

Page will access db and display the list of people.
Columns can be sorted by either the id or name.
Existing names can be modified

However;
Can not add new players or delete players

ANY suggestions are appreciated!

<?php
/**** Dealing with the database ****/
// connect to db
$conn = mysql_connect('xxxxxxxxxx','yyyyyyyyyy','zzzzzzzzzzzzz') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('ddddddddddddd',$conn) or trigger_error("SQL", E_USER_ERROR);

// INSERT: if we have a name to add...
if($_GET['name']) {
   // little bit of cleaning...
   $name = mysql_real_escape_string($_GET['name']);
   // insert new name into table
   $sql = "INSERT INTO info (id, name) VALUES ('','$name')";
   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if

// UPDATE: if we have name(s) to change...
if($_POST['cname']) {
   // for each name to change...
   foreach($_POST['cname'] as $cid => $cname) {
      // little bit of cleaning...
      $id = mysql_real_escape_string($cid);
      $name = mysql_real_escape_string($cname);
      // update name in the table 
      $sql = "UPDATE info SET name = '$name' WHERE id = '$id'";
      $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
   } // end foreach
} // end if
         
// DELETE: if we have a name to delete...
if($_GET['name']) {
   // little bit of cleaning...
   $name = mysql_real_escape_string($_GET['name']);
   // delete name from table
   $sql = "DELETE FROM info WHERE name = '$name'";
   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if

// ORDERBY: if one of the links was clicked..
if ($_GET['orderby']) {
   // make an aray of allowed names
   $allowed = array('id','name');
   // bit of cleaning...
   $order = mysql_real_escape_string($_GET['orderby']);
   // is it a valid column name? yes: use it. no: default to 'id'
   $order = (in_array($order, $allowed))? $order : "id";
// if no link clicked, default to 'id'
} else {
   $order = "id";
} // end else

// SELECT: get the list of names from database
$sql = "SELECT id, name FROM info ORDER BY $order";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
/**** end deal with the database ****/

/**** list everything out ****/
// list columns
echo <<<LISTCOLS
<form action = '{$_SERVER['REQUEST_URI']}' method = 'post'>
<table border = '1'>
   <tr>
      <td><a href = '{$_SERVER['REQUEST_URI']}?orderby=id'>id</td>
      <td><a href = '{$_SERVER['REQUEST_URI']}?orderby=name'>name</td>
      <td>delete</td>
   </tr>
LISTCOLS;

// loop through list of names
while ($list = mysql_fetch_assoc($result)) {
echo <<<LISTINFO
   <tr>
      <td>{$list['id']}</td>
      <td><input type = 'text' name = 'cname[{$list['id']}]' value = '{$list['name']}'>
      <td><a href = '{$_SERVER['REQUEST_URI']}?name={$list['name']}'>delete</a></td>
   </tr>
LISTINFO;
} // end while

// list input box for adding new entry
echo <<<NEWENTRY
   <tr>
      <td bgcolor = 'gray'></td>
      <td><input type = 'text' name = 'name'></td>
      <td bgcolor = 'gray'></td>
   </tr><tr>
      <td></td>
      <td align = 'center'><input type = 'submit' value = 'submit'></td>
      <td></td>
   </tr>
</table>
</form> 
NEWENTRY;
/**** end list everything out ****/

?>

Greetings all,   Been trying to make a plugin in wordpress and ran into an issue with the way wordpress makes use of ajax in the administration menu. The problem is that I completely don't understand it. I've read all the docs on it and even tried messing with a variety of tutorials on the matter to no avail.   What I am trying to do is a simple task outside of wordpress. The form has two select fields, the first field populates the second selection field. While this works fine on a standard html page, trying to do it in wordpress is another story.   Form.php:

<div id="wrapper">
<h1>Second dropdown selection based </h1>
<form action="" method="post">
<p><label>Main Menu :</label>
<select name="main_menu_id" id="main_menu_id">
<option value="">Select</option>
<?php
// Connect to database.
	$connect = mysqli_connect('<!--DB connection info-->");
$q = mysqli_query($connect, "SELECT cfid,cfname FROM categoryfiles ORDER BY cfid");
while($row = mysqli_fetch_array($q)) {
	echo '<option value="' . $row['cfname'] . '">' . $row['cfname'] . '</option>';
}
?>
</select>
</p>
<p><label>Sub Menu:   </label>
<select name="sub_menu_id" id="sub_menu_id"></select>
</p>
</form>
</div>

The script.js

$(function() {
	$("#main_menu_id").bind("change", function() {
		$.ajax({
			type: "GET",
			url: "scripts/get_sub_category.php",
			data: "main_menu_id="+$("#main_menu_id").val(),
			success: function(html) {
				$("#sub_menu_id").html(html);
			}
		});
	});
});

The get_sub_category.php

<?php

	// Connect to database.
	$connect = mysqli_connect('<!--My connection info-->);
							  
	$id = $_GET['main_menu_id'];
	$q = mysqli_query($connect, "SELECT sfid, sfname FROM subjectfiles WHERE sfcategory='" . $id . "' ORDER BY sfname");
	while($row = mysqli_fetch_array($q)) {
		
	echo '<option value="' . $row['sfname'] . '">' . $row['sfname'] . '</option>';
	
	}
?>

Like I said, it works just fine outside of wordpress so really I just need help getting it to work in wordpress. I just don't understand it. Thanks to anyone that takes the time to look this over.   Best Regards, Nightasy

Hi: I have a wordpress, and I want to publish a flash animation.   I´ve modified the wordpress file sidebar.php with a include to this code in another .php file, but I don´t see nothing, but I don´t have any error... just "white space" instead the animation...   Can you help me with the code??

<?
$wmode	= "opaque";

$refererId	=	258;
$bannerId	=	210;
$width		=	250;
$height		=	250;

$link		= "http://www.bellross.com/index.php?bannerId=".$bannerId."&refererId=".$refererId;
$flashLink	= "http://www.bellross.com/index.php?bannerId=".$bannerId."%26refererId=".$refererId;

?>

<style type="text/css">

body, object {
	padding:0;
	margin:0;
}

#timekeeper, .link {
	width: <?= $width?>px;
	height:<?= $height?>px;
}

.hand {
	bottom: 0px;
	left: 107px;
}

</style>



<link href="wp-content/themes/sahifa/template/style.css" rel="stylesheet" type="text/css"/>

<script type="text/javascript">
window.onload = function() {      
      if(document.getElementsByTagName('body')[0].style.MozTransform == ''
         || document.getElementsByTagName('body')[0].style.WebkitTransform == ''
         || document.getElementsByTagName('body')[0].style.OTransform == ''
		 || document.getElementsByTagName('body')[0].style.transform == '') {
	    function hand() {
		  handS.style.MozTransform    =
		  handS.style.WebkitTransform =
		  handS.style.OTransform      =
		  handS.style.transform       = 'rotate(' + (time * 6) + 'deg)';
		  handM.style.MozTransform    =
		  handM.style.WebkitTransform =
		  handM.style.OTransform      =
		  handM.style.transform       = 'rotate(' + (time / 10) + 'deg)';
		  handH.style.MozTransform    =
		  handH.style.WebkitTransform =
		  handH.style.OTransform      =
		  handH.style.transform       = 'rotate(' + (time / 120) + 'deg)';
	    }
	    var handH = document.getElementById('handH');
	    var handM = document.getElementById('handM');
	    var handS = document.getElementById('handS');
	    var timekeeper = document.getElementById('timekeeper');
	    var d = new Date();
	    var time = d.getSeconds() + 60 * d.getMinutes() + 3600 * d.getHours();
	    hand();
	    setInterval(function() {time = time+0.20; hand();}, 200);
		setInterval(function() {r = new Date(); time = r.getSeconds() + 60 * r.getMinutes() + 3600 * r.getHours(); hand()}, 10000);
      }
	  
};
</script>


<script src="wp-content/themes/sahifa/swf/Scripts/swfobject_modified.js" type="text/javascript"></script>

<script type="text/javascript">
swfobject.registerObject("FlashID");
</script>



<object id="FlashID" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="<?= $width?>" height="<?= $height?>">
  <param name="movie" value="wp-content/themes/sahifa/swf/timekeeper.swf">
  <param name="quality" value="high">
  <param name="wmode" value="<?= $wmode?>">
  <param name="swfversion" value="8.0.35.0">
  <param name="FlashVars" value="clickTAG=<?=$flashLink?>" />
  <!-- Cette balise <param> invite les utilisateurs de Flash Player en version 6.0 r65 et ultérieure à télécharger la version la plus récente de Flash Player. Supprimez-la si vous ne voulez pas que cette invite soit visible. -->
  <param name="expressinstall" value="wp-content/themes/sahifa/swf/Scripts/expressInstall.swf">
  <!-- La balise <object> suivante est destinée aux navigateurs autres qu'IE. Supprimez-la d'IE à l'aide d'IECC. -->
  <!--[if !IE]>-->
  <object type="application/x-shockwave-flash" data="wp-content/themes/sahifa/swf/timekeeper.swf" width="<?= $width?>" height="<?= $height?>">
    <!--<![endif]-->
    <param name="quality" value="high">
    <param name="wmode" value="<?= $wmode?>">
    <param name="swfversion" value="8.0.35.0">
    <param name="expressinstall" value="wp-content/themes/sahifa/swf/Scripts/expressInstall.swf">
    <param name="FlashVars" value="clickTAG=<?=$flashLink?>" />
    <!-- Le navigateur affichera le contenu alternatif suivant pour les utilisateurs d'un lecteur Flash de version 6.0 ou de versions plus anciennes. -->
    <div id="timekeeper">
        <a href="<?= $link; ?>" target="_blank" class="link"></a>
        <img src="template/images/handH.png" class="hand" id="handH" alt="heure"/>
        <img src="template/images/handM.png" class="hand" id="handM" alt="minute"/>
        <img src="template/images/handS.png" class="hand" id="handS" alt="seconde"/>
    </div>
    <!--[if !IE]>-->
  </object>
  <!--<![endif]-->
</object>

Do you see anything wrong? How can I make this work in my page?   I hope you can help me. Thanks. Regards  

Hi   I need to add one more function in my wordpress plugin. below is the sample code working for 2nd tier. Now i need a same function for 3rd and 4th tire.   Function explanation   I am A and i refer B and if B made any sale means I (A) will get direct commission for that sale.   If B refer C and if C made any sale means (B) will get direct commission for that sale. And in this sample code me(A) also get commission for that sale as a 2nd tier.   Now C refer D and if D made any sale means © will get direct commission for that sale and (B) will get 2nd tier commission. So here (A) me too should get 3rd tire commission and i need that function.   Please help me.    

function wp_aff_award_second_tier_commission($wp_aff_affiliates_db,$sale_amount,$txn_id,$item_id,$buyer_email,$buyer_name='')
{
global $aff_tx_msg;
    $clientdate = (date ("Y-m-d"));
$clienttime = (date ("H:i:s")); 


if (get_option('wp_aff_use_2tier') && !empty($wp_aff_affiliates_db->referrer))
{
$aff_tx_msg .= '<br />Using tier model';
wp_affiliate_log_debug("Using tier model",true);
$award_tier_commission = true; 
$duration = get_option('wp_aff_2nd_tier_duration'); 
if(!empty($duration))
{
$join_date = $wp_aff_affiliates_db->date;
$days_since_joined = round((strtotime(date("Y-m-d")) - strtotime($join_date) ) / (60 * 60 * 24));


if ($days_since_joined > $duration)
{
$aff_tx_msg .= '<br />Tier commission award duration expried';
wp_affiliate_log_debug("Tier commission award duration expried! No tier commission will be awarded for this sale.",true);
$award_tier_commission = false;
}
} 
if ($award_tier_commission)
{
if(!empty($wp_aff_affiliates_db->sec_tier_commissionlevel)){
$second_tier_commission_level = $wp_aff_affiliates_db->sec_tier_commissionlevel;
wp_affiliate_log_debug("Using the affiliate specific 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
else{
$second_tier_commission_level = get_option('wp_aff_2nd_tier_commission_level');
wp_affiliate_log_debug("Using global 2nd tier commission for this referral. 2nd tier commission level: ".$second_tier_commission_level,true);
}
if (get_option('wp_aff_use_fixed_commission'))
{
                    $commission_amount = $second_tier_commission_level;
                }
                else
                {
   $commission_amount = round(($second_tier_commission_level * $sale_amount)/100,2);
                }
                $campaign_id = "";
                $is_tier_comm = "yes";
global $wpdb;
$aff_sales_table = WP_AFF_SALES_TBL_NAME;
$updatedb = "INSERT INTO $aff_sales_table (refid,date,time,browser,ipaddress,payment,sale_amount,txn_id,item_id,buyer_email,campaign_id,buyer_name,is_tier_comm) VALUES ('$wp_aff_affiliates_db->referrer','$clientdate','$clienttime','','','$commission_amount','$sale_amount','$txn_id','$item_id','$buyer_email','$campaign_id','$buyer_name','$is_tier_comm')";
$results = $wpdb->query($updatedb); 
$aff_tx_msg .= '<br />Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount;
wp_affiliate_log_debug('Tier commission awarded to: '.$wp_aff_affiliates_db->referrer.'. Commission amount: '.$commission_amount,true); 
} 
} 
return $aff_tx_msg;
}

This topic has been moved to PHP Applications.

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

I placed car-dealer-website, a web application from car-dealer-website.org , in a subdirectory on my host mysite.com/car. Wordpress is public_html (mysite.com).

What I am trying to do is embed mysite.com/car in Wordpress. I tried iframe and it is ugly. I looked for a php css options,using a code I found online, it didnt work but I saw hope and think php and css is the solution.

What I am asking for is direction on using php and css to embed in Wordpress. I want to write code no plugins. I hope to learn some php coding. Thank you in advance for your suggestions, tutorials, different methods.

What I remember from my college days is that isset check whether the variable has a value set or not and return true or false value.   However I encountered a code in wordpress -  // Set up the content width value based on the theme's design and stylesheet.

How do I incorporate wordpress php usage withing standard php? For example, this is typically the template used for the title in wordpress:

Code: [Select]
<?php the_title(); ?>
How would I show that in php, like:

Code: [Select]
$title = the_title(); //this doesn't work by the way

Hi all,

I have the following which displays my posts on a wordpress blog
<?php 

$x = 0;

while (have_posts()) : the_post(); update_post_caches($posts); 

$x++;

?>

<li<?php if ($x % 2) { } else { echo ' class="right_col"';} ?>>

<?php unset($img); 

if ( current_theme_supports( 'post-thumbnails' ) && has_post_thumbnail() ) {

$thumbURL = wp_get_attachment_image_src( get_post_thumbnail_id($post->ID), '' );

$img = $thumbURL[0];  }

else { 

unset($img);

if ($wpzoom_cf_use == 'Yes')  { $img = get_post_meta($post->ID, $wpzoom_cf_photo, true); }

else {  

if (!$img)  {  $img = catch_that_image($post->ID);  } }

}

if ($img) { $img = wpzoom_wpmu($img); ?>

<a href="<?php the_permalink(); ?>" rel="bookmark" title="<?php the_title(); ?>"><img src="<?php bloginfo('template_directory'); ?>/scripts/timthumb.php?src=<?php echo $img ?>&amp;w=75&amp;h=75&amp;zc=1" alt="<?php the_title(); ?>" /></a><?php } ?>

<a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title(); ?></a><span class="comm_bubble"><?php comments_popup_link('0', '1', '%', ' ', ' '); ?></span>

<span class="meta"><?php the_time("$dateformat $timeformat"); ?> <?php edit_post_link( __('Edit', 'wpzoom'), ' ', ''); ?></span>

<?php wpe_excerpt('excerpt_tabs', 'wpe_excerptmore'); ?>

</li><?php endwhile; ?>
 

 

</ul><?php endif; ?>

What I would like to do is limit the max posts to 6, but I cant seem to work out a way of doing it!

Any pointers?

Cheers