Condition is not working in php -
here entire code:
<?php require_once 'lib/shopify.php'; //require_once 'csv.php'; function csvtojson($csv) { $rows = explode("\n", trim($csv)); $csvarr = array_map(function($row) { $keys = array( 'var0', 'var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7', 'var8', 'var9' ); homecoming array_combine($keys, str_getcsv($row)); }, $rows); $json = json_encode($csvarr); homecoming $json; } $t = "bac2486aa2b31aa5aed1fdd62e77a4ae"; $sc = new shopifyclient("mine-329.myshopify.com/", $t, api_key, secret); $order = array(); if (!isset($t)) { if (!isset($_get['signature'])) { $url = $sc->getauthorizeurl("read_orders"); header('location: ' . $url); } if (isset($_get['code'])) { $acctok = $sc->getaccesstoken($_get['code']); echo "token = " . $acctok; exit; $orders = $sc->call('get', 'admin/orders.json', array( 'published_status' => 'published' )); foreach ($orders $order) { echo $order['id']; echo $order['email']; } } } if (isset($t)) { $orders = $sc->call('get', 'admin/orders.json', array( 'published_status' => 'published' )); $myarray = array(); $list[] = array( 'name', 'email', 'financial status', 'paid at', 'fulfillment status', 'fulfilled at', 'accepts marketing', 'currency', 'subtotal', 'shipping', 'taxes', 'total', 'discount code', 'discount amount', 'shipping method', 'created at', 'lineitem quantity', 'lineitem name', 'lineitem price', 'lineitem compare @ price', 'lineitem sku', 'lineitem requires shipping', 'lineitem taxable', 'lineitem fulfillment status', 'billing name', 'billing street', 'billing address1', 'billing address2', 'billing company', 'billing city', 'billing zip', 'billing province', 'billing country', 'billing phone', 'shipping name', 'shipping street', 'shipping address1', 'shipping address2', 'shipping company', 'shipping city', 'shipping zip', 'shipping province', 'shipping country', 'shipping phone', 'notes', 'note attributes', 'vat', 'cancelled at', 'payment method', 'payment reference', 'refunded amount', 'vendor', 'id', 'tags' ); $list = array_filter($list); $empty_note_attribute = ""; if (empty($order['note_attributes'])) { $empty_note_attribute = ""; } else { $empty_note_attribute = $order['note_attributes']; } $empty_discount_codes = ""; if (empty($order['discount_codes'])) { $empty_discount_codes = ""; } else { $empty_discount_codes = $order['discount_codes']; } foreach ($orders $order) { $str = file_get_contents('slim-2.json'); //give address of json file $str = mb_convert_encoding($str, 'utf-8'); $json_country = json_decode($str, true); //here problem passing `$str` should pass `$json_country` if (is_array($json_country)) { foreach ($json_country $key => $value) { if (array_search(trim($order['billing_address']['country']), $value)) // added trim { $order['billing_address']['country'] = $value['alpha-2']; } if (isset($order['shipping_address']['country'])) { if (array_search(trim($order['shipping_address']['country']), $value)) // added trim { $order['shipping_address']['country'] = $value['alpha-2']; } } } } $csv = file_get_contents('states.csv'); $csv = mb_convert_encoding($csv, 'utf-8'); $json = csvtojson($csv); $json_state = json_decode($json, true); $bilprovin = trim($order['billing_address']['province']); $shpprovin = ''; if (isset($order['shipping_address'])) { $shpprovin = $order['shipping_address']['province']; } foreach ($json_state $keys) { if (array_search($bilprovin, $keys)) // added trim { $order['billing_address']['province'] = substr($keys['var1'], 3); } if (isset($order['shipping_address'])) { if (array_search($shpprovin, $keys)) { $order['shipping_address']['province'] = substr($keys['var1'], 3); } } } $orders_lineitem = $order['line_items']; $lineitemcount = 0; foreach ($orders_lineitem $lineitem) { /* fulfillment status */ $fulfill_status = ""; if (empty($order['fulfillment_status'])) { $fulfill_status = "pending"; } else { $fulfill_status = $order['fulfillment_status']; } /* lineitem fulfillment status */ $fulfillment_status = ''; if (empty($order['fulfillments'][0]['created_at'])) { $fulfillment_status = "pending"; } else { $fulfillment_status = $order['line_items'][0]['fulfillment_status']; } $variants = ""; $variants = $sc->call('get', "admin/variants/" . $lineitem['variant_id'] . ".json", array( 'published_status' => 'published' )); $requires_shipping = "false"; if ($lineitem['requires_shipping']) { $requires_shipping = "true"; } $lineitem_taxable = "false"; if ($lineitem['taxable']) { $lineitem_taxable = "true"; } //** accepts marketting ** $accepts_marketting = "no"; if ($order['buyer_accepts_marketing']) { $accepts_marketting = "yes"; } $shipping = ''; if (count($order['shipping_lines']) > 0) { $shipping = $order['shipping_lines'][0]['price']; } /* fulfilled @ */ $created_at = ''; if (count($order['fulfillments']) > 0) { $created_at = $order['fulfillments'][0]['created_at']; } /* total taxation */ $total_tax = ''; if (count($order['line_items'][0]['tax_lines']) > 0) { $total_tax = $order['line_items'][0]['tax_lines'][0]['price']; } /* payment reference */ $payment = ''; if ($order['checkout_id']) { $payment = sprintf('c%s.1', $order['checkout_id']); } /* refunded amount */ $refund_price = ''; if (count($order['refunds']) > 0) { foreach ($order['refunds'] $refund) { if (count($refund['transactions']) > 0) { $refund_price += $refund['transactions'][0]['receipt']['paid_amount']; } } } if ('pending' == $fulfill_status || 'partial' == $fulfill_status) { $created_at = ''; } if ($lineitemcount == 0) { array_push($list, array( $order['name'], $order['email'], $order['financial_status'], (($order['financial_status'] != 'partially_refunded') && ($order['financial_status'] != 'refunded') && ($order['financial_status'] != 'authorized') ? $order['created_at'] : null), $fulfill_status, $created_at, $accepts_marketting, $order['currency'], $order['subtotal_price'], (($shipping > 0) ? $shipping : 0), $order['total_tax'], $order['total_price'], $empty_discount_codes, $order['total_discounts'], (($shipping > 0) ? $order['shipping_lines'][0]['code'] : null), $order['created_at'], $lineitem['quantity'], $lineitem['name'], $lineitem['price'], $variants['compare_at_price'], $lineitem['sku'], $requires_shipping, $lineitem_taxable, $fulfillment_status, $order['billing_address']['name'], $order['billing_address']['address1'], $order['billing_address']['address1'], $order['billing_address']['address2'], $order['billing_address']['company'], $order['billing_address']['city'], $order['billing_address']['zip'], $order['billing_address']['province'], $order['billing_address']['country'], $order['billing_address']['phone'], (($shipping > 0) ? $order['shipping_address']['name'] : null), (($shipping > 0) ? $order['shipping_address']['address1'] : null), (($shipping > 0) ? $order['shipping_address']['address1'] : null), (($shipping > 0) ? $order['shipping_address']['address2'] : null), (($shipping > 0) ? $order['shipping_address']['company'] : null), (($shipping > 0) ? $order['shipping_address']['city'] : null), (($shipping > 0) ? $order['shipping_address']['zip'] : null), (($shipping > 0) ? $order['shipping_address']['province'] : null), (($shipping > 0) ? $order['shipping_address']['country'] : null), (($shipping > 0) ? $order['shipping_address']['phone'] : null), $order['note'], $empty_note_attribute, $total_tax, $order['cancelled_at'], $order['payment_details']['credit_card_company'], $payment, (($refund_price > 0) ? $refund_price : 0), $lineitem['vendor'], $order['id'], $order['tags'] )); } else { array_push($list, array( $order['name'], $order['email'], '', '', '', '', '', '', '', '', '', '', $empty_discount_codes, '', '', $order['created_at'], $lineitem['quantity'], $lineitem['name'], $lineitem['price'], $variants['compare_at_price'], $lineitem['sku'], $requires_shipping, $lineitem_taxable, $fulfillment_status, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', $lineitem['vendor'], '', $order['tags'] )); } $lineitemcount++; } } $order = $_get; $list[] = array_to_csv_download($myarray, // array going sec row "numbers.csv"); $list = array_filter($list); array_to_csv_download($list); header("content-type: text/csv"); header("content-disposition: attachment; filename=file.csv"); header("pragma: no-cache"); header("expires: 0"); } function array_to_csv_download($list) { $output = fopen("php://output", "w"); foreach ($list $row) { fputcsv($output, $row); //print_r($row); die; } fclose($output); } ?> i created 1 app using above code used download details csv file fron online store.
now details got it. problem is, in above code, $order['billing_address']['province']'s value not shows correctly.
the reason is, want add together status above code. if $order['billing_address']['province']'s value 'ky', shows empty field.but checked
$province = ''; if($order['billing_address']['province']! = 'ky') { $province = $order['billing_address']['province']; } on above code foreach ($json_state $keys), display parse error. dont know how add together code in above code. m new php.can 1 help me?
thanks!!!
wrong:
if($order['billing_address']['province']! = 'ky') { correct:
if($order['billing_address']['province'] != 'ky') { php
No comments:
Post a Comment