PHP – Page 335 – Blancer.com Tutorials and projects

Prestashop 1.7.5.2 How to add manually the customer vat_number on invoice

I need to add the customer delivery and billing vat_number on the invoice generated by prestashop.

I’ve tryed to modify my classes/pdf/HTMLTemplateInvoice.php adding ‘customer_vat_number’ => $invoice_address->vat_number like that:

$data = array(
            'order' => $this->order,
            'order_invoice' => $this->order_invoice,
            'order_details' => $order_details,
            'carrier' => $carrier,
            'cart_rules' => $cart_rules,
            'delivery_address' => $formatted_delivery_address,
            'invoice_address' => $formatted_invoice_address,
            'addresses' => array('invoice' => $invoice_address, 'delivery' => $delivery_address),
            'tax_excluded_display' => $tax_excluded_display,
            'display_product_images' => $display_product_images,
            'layout' => $layout,
            'tax_tab' => $this->getTaxTabContent(),
            'customer' => $customer,
            'footer' => $footer,
            'ps_price_compute_precision' => _PS_PRICE_COMPUTE_PRECISION_,
            'round_type' => $round_type,
            'legal_free_text' => $legal_free_text,
            'customer_vat_number' => $invoice_address->vat_number, // <= that doesn't works!!
        );

and also adding this to the pdf/invoice.addresses-tab.tpl

<table id="addresses-tab" cellspacing="0" cellpadding="0">
    <tr>
        <td width="50%">{if $delivery_address}<span class="bold">{l s='Delivery Address' d='Shop.Pdf' pdf='true'}</span><br/><br/>
                {$delivery_address}<br/>{$customer_vat_number} // <= that
            {/if}
        </td>
        <td width="50%"><span class="bold">{l s='Billing Address' d='Shop.Pdf' pdf='true'}</span><br/><br/>
                {$invoice_address}<br/>{$customer_vat_number} // <= that
        </td>
    </tr>
</table>

But it doesn’t works!

Help please!

Eloquent select field after aggregation

I have three models, User, Post and Comment. User and Post are in a One-To-Many relationship, and so are User and Comment. For the sake of this example, there isn’t a Post–Comment relationship.

When I run the following query

User::withCount(['posts', 'comments'])->get()

I obtain the expected results:

[
...
  AppModelsUser {#3459
    id: 18,
    username: "Foo",
    created_at: "2021-12-08 11:38:39",
    updated_at: "2021-12-08 11:38:39",
    posts_count: 5,
    comments_count: 15,
  }
...
]

I would like to remove the timestamps from the resulting models.
I’ve tried putting the array of fields I want as parameter for get (as in ->get(['username', 'posts_count', 'comments_count']), but the result didn’t change at all.

I’ve also tried replacing get(...) with select(...)->get(), but that produces this error:

IlluminateDatabaseQueryException with message 
'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'posts_count' in 'field list'  
(SQL: select `username`, `posts_count`, `comments_count` from `users`)'

which I assume it is due to the fact that the aggregation function is not yet being executed.

So I came up with this solution

$usersWithCounts = User::withCount(['posts', 'comments'])->get()
    ->map(function ($item, $key) {
         return $item->only(['username', 'posts_count', 'comments_count']); 
      });

but it doesn’t feel right: the returned collection is no longer made of Eloquent models, just simple arrays.

What’s the right way of proceeding?

How to download CSV file with CRLF and not LF?

I am using FastExcel to generate .csv templates, but it downloads it with LF instead of CRLF for the line breaks, so whenever I upload the file back to the server, the .csv formatting is messed up.

How can I fix that?

The datatable cant display the searching and sorting, may I know why?

The datatable cant display the searching and sorting, may I know why? The problem is, the searching, sorting didn’t display. But when I use HTML code 100% then it will display, but when I use data that fetch from MySQL, it didn’t display the searching and sorting but it displays the table. I’m new to this and still a student. This is where the js and css link I take
datatable

table for datatype

<!DOCTYPE html>
<html lang="en">
<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Content filter for IHSR</title>

    <!--Link from datatable for sort,pagging,search-->
    <link href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css" rel="stylesheet">
    <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
</head>

<body >
    <?php
    include('connection.php');

    // select column from table ihsr_facebook_content
    $query = "SELECT * FROM customer ORDER BY Customer_Name ASC";//later change to DESC
    // get results from database
    $result = mysqli_query($connect, $query);

    // display data in table
    if(mysqli_num_rows($result)>0)
    {
    $output = '<div>
                <table id="example" class="display" style="width:100%">
                  <thead class="table-dark">
                    <tr>
                      <th style="padding-left: 10px; padding-right: 20px;" >No.</th>
                      <th style="padding-left: 10px; padding-right: 20px;" colspan="2">Name</th>
                      <th style="padding-left: 10px; padding-right: 20px;" >Email</th>
                      <th style="padding-left: 10px; padding-right: 20px;" >Contact</th>
                      <th style="padding-left: 10px; padding-right: 20px;" >Address</th>
                      <th width="7%">Edit</th>
                      <th width="9%">Delete</th>
                    </tr>
                  </thead>
                <tbody>';
    $num = mysqli_num_rows($result);
    $count= 1 ;
    // loop through results of database query, displaying them in the table
    while($row = mysqli_fetch_array( $result )) {
      $Customer_ID = $row['Customer_Id'];
      $Customer_Name = $row['Customer_Name'];
      $Customer_Email = $row['Customer_Email'];
      $Customer_Contact = $row['Customer_Contact'];
      $Customer_Address = $row['Customer_Address'];

    // echo out the contents of each row into a table
      $output.='<tr>
                  <td>'.$count.'</td>
                  <td colspan="2">'.$Customer_Name.'</td>
                  <td>'.$Customer_Email.'</td>
                  <td>'.$Customer_Contact.'</td>
                  <td>'.$Customer_Address.'</td>
                  <td><a class="btn-1" href="product_edit.php?GetEdit='.$Customer_ID.'" id="myBtn">Edit</a></td>
                  <td><button type="button" class="delButton btn-1" data-toggle="modal" id="'.$Customer_ID.'" data-target="#myModal" >Delete</button></td>
                </tr>';
      $count++;
    }
    }
    // close table>
    echo $output.'</tbody></table></div>';
    ?>

<script>
$(document).ready(function() {
    $('#example').DataTable();
} );

</script>
</body>
</html>

first time trying email for with php, help would be appreciated

I am trying to send some basic text data from a html form to an email. I found an article online with the php code contain below. Here is the link to the article https://html.form.guide/email-form/php-form-to-email/. I am using easyphp dev server to run my code and it is reporting an error on line 22 of the php file. Here is the error: Parse error: syntax error, unexpected ‘mail’ (T_STRING) in C:Program Files (x86)EasyPHP-Devserver-17eds-wwwform-to-email.php on line 22. Any help in clarifying what this means would be greatly appreciated as this is my first time attempting this. Thanks in advance.

<?php
$name = $_POST['name'];
$visitor_email = $_POST['email'];
$message = $_POST['message'];

$email_from = '[email protected]';

$email_subject = "New Form submission";

$email_body = "You have received a new message from the user $name.n".
                        "Here is the message:n $message".
                        

$to = "[email protected]";

$headers = "From: $email_from rn";

$headers .= "Reply-To: $visitor_email rn";


ini_set(25)
mail($to,$email_subject, $email_body,$headers);

?>

Sort A Multi Dimensional Array In Laravel

This is the result of dd() that I use in my controller on laravel 8. I want to sort the data based on the JB column. I can’t use the manual order by in SQL syntax because I get JB from complex DB RAW. Therefore I want to sort this multi-dimensional array using php. Does anyone know how to sort the multi-dimensional array based on JB column value?

Send data with cURL by post’s data

Hi can I concatenate my post data?

CURLOPT_POSTFIELDS => "{"contact":{"dataFields":[{"key":"FIRSTNAME","value":"Foo"},{"key":"LASTNAME","value":"Bar"}],"email":"[email protected]","optInType":"Single","emailType":"PlainText"},"consentFields":{"fields":[{"key":"UK_OPT_IN_COUNT","value":"Y"}]}}"

I need to replace Foo with $_POST['firstName'], Bar with $_POST['lastName'], and [email protected] with $_POST['email']

Carry over Phone Number field to meta field WooCommerce

so I’ve implemented a phone login and register option in WooCommerce with the code:

function wooc_add_phone_number_field() {
    return apply_filters( 'woocommerce_forms_field', array(
        'wooc_user_phone' => array(
            'type'        => 'text',
            'pattern'     => '[0][0-9]{9}',
            'label'       => __( 'Phone Number', ' woocommerce' ),
            'placeholder' => __( 'MUST START WITH 0 e.g 081 123 4567', 'woocommerce' ),
            'required'    => true,
        ),
    ) );
}
add_action( 'woocommerce_register_form', 'wooc_add_field_to_registeration_form', 15 );
function wooc_add_field_to_registeration_form() {
    $fields = wooc_add_phone_number_field();
    foreach ( $fields as $key => $field_args ) {
        woocommerce_form_field( $key, $field_args );
    }
}


//Store
add_action( 'woocommerce_created_customer', 'wooc_save_extra_register_fields' );
function wooc_save_extra_register_fields( $customer_id ) {
    if (isset($_POST['wooc_user_phone'])){
        update_user_meta( $customer_id, 'wooc_user_phone', sanitize_text_field( $_POST['wooc_user_phone'] ) );
    }
}

//Check against phone
function wooc_get_users_by_phone($phone_number){
    $user_query = new WP_User_Query( array(
        'meta_key' => 'wooc_user_phone',
        'meta_value' => $phone_number,
        'compare'=> '='
    ));
    return $user_query->get_results();
}


//Authenticate 
add_filter('authenticate','wooc_login_with_phone',30,3);
function wooc_login_with_phone($user, $username, $password ){
    if($username != ''){
        $users_with_phone = wooc_get_users_by_phone($username);
        if(empty($users_with_phone)){
            return $user;
  }
  $phone_user = $users_with_phone[0];
  
  if ( wp_check_password( $password, $phone_user->user_pass, $phone_user->ID ) ){
   return $phone_user;
  }
    }
    return $user;
}


//Login label
add_filter( 'gettext', 'wooc_change_login_label', 10, 3 );
function wooc_change_login_label( $translated, $original, $domain ) {
    if ( $translated == "Username or email address" && $domain === 'woocommerce' ) {
        $translated = "Username or email address or phone";
    }
    return $translated;
}

Which works perfectly fine however what I want to do is then populate the phone field in the Billing Address with the value that is stored here so when a user goes to Billing Form theyll find the same details they entered when registering.

Run PHP script after Azure Web app deployment

I am having an Azure app Service and I want to upload/deploy an .php file to it an run it right after the upload.

I managed to upload it via curl and also start a post deployment script. Unfortunately I can not use the command “php …” in it because I get an error like: “/opt/Kudu/Scripts/starter.sh: line 2: exec: php: not foundn” in the logs.
The same occurs if I use the “/api/command” endpoint with the same command. I get the same kind of error in the response.

It seems like the php executable is not known in that environment.
Is there any way to run a php script via the command API or in a post deployment script?

Thanks in advance

PHP simplexml – dealing with namespaces

Background
I am trying to extract the value of the following element

<D:POD>2021-08-07</D:POD>

from the following XML.

The output I am trying to get

2021-08-07

The problem of this XML is that its elements (including the root element) contain namespaces. I am struggling to deal with this using simplexml.

My steps

I request and receive the above XML from the api using

$this->curl = curl_init($this->url);
curl_setopt($this->curl, CURLOPT_URL, $this->url);
curl_setopt($this->curl, CURLOPT_RETURNTRANSFER, true);
$this->headers = array(
    "Accept: application/xml",
 );
 curl_setopt($this->curl, CURLOPT_HTTPHEADER, $this->headers);

 $this->resp = curl_exec($this->curl);
 curl_close($this->curl);

Then I run simplex_load_string:

$this->xml = simplexml_load_string($this->resp);

I am trying to access:

<are:Ares_odpovedi>(root)
   <are:Odpoved>
      <D:Vypis_OR>
         <D:ZAU>
 ->         <D:POD>2021-08-07</D:POD>

I am not able to point to the element <D:POD> with the standard $xml->element_lvl1->element_lvl2… since all the elements have namespaces.

I tried running print_r on the result to help me to point to these namespaced elements:

print_r($this->xml);

but it only displays the attributes of the root element (are:Ares_odpovedi) in the XMLobject. I cannot see any child elements of this root element.

SimpleXMLElement Object ( [@attributes] => Array ( [odpoved_datum_cas]
=> 2022-01-17T11:41:46 [odpoved_pocet] => 1 [odpoved_typ] => Vypis_OR [vystup_format] => XML [xslt] => klient [validation_XSLT] =>
http://wwwinfo.mfcr.cz/ares/xml_doc/schemas/ares/ares_odpovedi.xsl
[Id] => ares ) )

Question:
Is there please a way how to get the value of a specific child element (<D:POD>2021-08-07</D:POD>) in this xml where all the elements (including the root element) contain namespaces?

HIGHCHARTS PROBLEM: ajax call from an .php JSON data file for display it on the chart not working

we are two students that have to load on a highcharts chart some x and y data taken from a .php file that contains the data in JSON format, but after making the AJAX call we do not know how to recall the data on the chart, we have seen a lot of guides but, we can’t find anything, if you can help us we will be glad.

Our complete code:
Html:

<html lang="it">
<head>
 <meta charset="UTF-8">
 <meta name="viewport" content="width=device-width, initial-scale=1.0">
 <meta http-equiv="X-UA-Compatible" content="ie=edge">
 <script src="https://code.highcharts.com/highcharts.js"></script>
 <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
 <title>Grafico Stage</title>
</head>
<body>

 <div id="container"></div>

 <script src="index.js"></script>
</body>
</html>

.javaScript

    Highcharts.chart('container', {
        colors: ["#669900"],
        chart: {
            type: 'spline',
            zoomType: 'x,y',
        },
        title: {
            text: 'Grafico Stage Samela-Ungureanu'
        },
        credits: {
            text: 'Powered by Sirius s.r.l',
            href: 'http://www.sirius.to.it/',
            position: {
                align: 'left',
                x: 70,
                y: -355
            },
            style: {
                fontSize: "15px",
                color: "#669900"
            }
        },
        yAxis: {
            title: {
                text: null,
            },
        },
        series: [
            {
                name: 'Potenza',
                data: []
            },
        ],
        xAxis: {
            categories: []
        },
        series: [
            {
                name: 'SSEMontalto.Montalto.WPP.Line 01.WTG01.DMAV.Active Power',
                data: []

            },

        ]

    });
    $.ajax({
        url: "getData.php",
        cache: false,
        dataType: "json",
        type: "GET",
        complete: function (data) {
            console.log("Ajax request finished");
        },
        success: function (data) {

            console.log(data)
        },
        error: function (jqXHR, textStatus, errorThrown) {
            console.log("Error:" + textStatus);
        }
    })

});

.php with JSON format

PHP Paypal MALFORMED_REQUEST_JSON although JSON seems to be well formatted

I try to implement a paypal express checkout flow to a website.

The user must be able to adjust the order after they have logged in with paypal and choosed their payment option.

To do so, I create the order with paypal with the intent “AUTHORIZE” and user action “CONTINUE”. It is created, the user is sent back to our website and I can fetch order and payer information with the (order) id created.

But then, when the payer is done checking and adjusting some final parameters and clicks the “buy now” button, I want to send the update order call as referenced here:
https://developer.paypal.com/api/orders/v2/#orders_patch

I create the payload in exactly the same way as for order creation, but this time with intent “CAPTURE” and user_action=”PAY_NOW”. I PATCH it to the correct path, but I keep getting the failure message “MALFORMED_REQUEST_JSON” .

Hoewever, the JSON itself is a valid JSON, no errors thrown in creation. Here is a sample:

{
    intent: "CAPTURE",
    application_context: {
        landing_page: "NO_PREFERENCE",
        shipping_preference: "SET_PROVIDED_ADDRESS",
        user_action: "PAY_NOW",
    },
    purchase_units: [{
        reference_id: "2289256",
        description: "Your Order with us",
        custom_id: "OrderId 2289256",
        soft_descriptor: "Name of the site",
        invoice_id: "2289256",
        amount: {
            currency_code: "EUR",
            value: 59.98,
            breakdown: {
                item_total: {
                    currency_code: "EUR",
                    value: 50.41,
                },
                shipping: {
                    currency_code: "EUR",
                    value: 0,
                },
                discount: {
                    currency_code: "EUR",
                    value: 0,
                },
                tax_total: {
                    currency_code: "EUR",
                    value: 9.57,
                },
            },
        },
        items: [{
            name: "Product 1",
            description: "Product 1 description",
            sku: "1019879",
            unit_amount: {
                currency_code: "EUR",
                value: 16.8,
            },
            tax: {
                currency_code: "EUR",
                value: 3.19,
            },
            quantity: "1",
            category: "PHYSICAL_GOODS",
        }, {
            name: "Product 2",
            description: "Product 2 description",
            sku: "1024593",
            unit_amount: {
                currency_code: "EUR",
                value: 33.61,
            },
            tax: {
                currency_code: "EUR",
                value: 6.38,
            },
            quantity: "1",
            category: "PHYSICAL_GOODS",
        }, ],
        shipping: {
            name: {
                full_name: "John Doe"
            },
            address: {
                address_line_1: "Badensche Str.    24",
                address_line_2: " ",
                admin_area_2: "Berlin(Berlin)",
                postal_code: "10715",
                country_code: "DE",
            },
        },
    }],
}

Here is paypal´s response

{
    name: "INVALID_REQUEST",
    message: "Request is not well-formed, syntactically incorrect, or violates schema.",
    debug_id: "c315ce9eb90b4",
    details: [{
        field: "/",
        location: "body",
        issue: "MALFORMED_REQUEST_JSON",
        description: "The request JSON is not well formed.",
    }],
    links: [{
        href: "https://developer.paypal.com/docs/api/orders/v2/#error-MALFORMED_REQUEST_JSON",
        rel: "information_link",
        encType: "application/json",
    }],
}

I just cannot figure out the problem. I tried to remove the whole application_context, purchase_units, intent and see if there is a problem within any of these parameters. Nothing changed. What exactly is wrong with this call?

Contact Form with Custom Datepicker NMR don’t validate field when required

Using Custom Datepicker NMR plugin with CF7 which nearly duplicate the CF7 date.php module and add a new $tag where we can use jquery-ui-datepicker.

Everything works as except but when the field is required, the validation do not validate the datepicker field on form submit.

Looks like this line have no effect :

 **$atts['aria-invalid'] = $validation_error ? 'true' : 'false';**

Any help would be appreciated !

Thanks in advance

[PHP]

add_action('wpcf7_init', 'nmr_add_jqueryui_datepicker');
function nmr_add_jqueryui_datepicker()
{
    wpcf7_add_form_tag(
        array('datepicker', 'datepicker*'),
        'nmr_datepicker_form_tag_handler',
        array('name-attr' => true)
    );
}

function nmr_datepicker_form_tag_handler($tag)
{
    if (empty($tag->name)) {
        return '';
    }
    $validation_error = wpcf7_get_validation_error($tag->name);

    $class = wpcf7_form_controls_class($tag->type);

    $class .= ' wpcf7-validates-as-date';

    if ($validation_error) {
        $class .= ' wpcf7-not-valid';
    }

    $atts = array();
    $atts['class'] = $tag->get_class_option($class) . ' nmr-datepicker';
    $atts['id'] = $tag->get_id_option();
    $atts['tabindex'] = $tag->get_option('tabindex', 'signed_int', true);
    $atts['min'] = $tag->get_date_option('min');
    $atts['max'] = $tag->get_date_option('max');
    $atts['step'] = $tag->get_option('step', 'int', true);
    $atts['data-format'] = $tag->get_option('format', '', true);

    if ($tag->has_option('readonly')) {
        $atts['readonly'] = 'readonly';
    }

    if ($tag->is_required()) {
        $atts['aria-required'] = 'true';
    }

    $atts['aria-invalid'] = $validation_error ? 'true' : 'false';

    $value = (string) reset($tag->values);

    if (
        $tag->has_option('placeholder')
        or $tag->has_option('watermark')
    ) {
        $atts['placeholder'] = $value;
        $value = '';
    }

    $value = $tag->get_default_option($value);

    $value = wpcf7_get_hangover($tag->name, $value);

    $atts['value'] = $value;

    $atts['type'] = 'text';
    $atts['name'] = $tag->name;
    $atts = wpcf7_format_atts($atts);

    $html = sprintf(
        '<span class="wpcf7-form-control-wrap %1$s"><input %2$s />%3$s</span>',
        sanitize_html_class($tag->name),
        $atts,
        $validation_error
    );
    return $html;
}

function nmr_datepicker_enqueue_script() {   
    $path = plugin_dir_url( __FILE__ );
    wp_enqueue_style('jquery-ui-css', $path .'css/jquery-ui.css');
    wp_enqueue_script( 'nmr_datepicker', $path . 'js/nmr-datepicker.js' , array('jquery', 'jquery-ui-datepicker'));
}
add_action('wp_enqueue_scripts', 'nmr_datepicker_enqueue_script');

[JS]

(function ($) {
    $(document).ready(function () {
        $(".nmr-datepicker").each(function (i, item) {
            var settings = {};
            if (item.dataset.format) {
                settings.dateFormat = item.dataset.format;
            }
            if (item.id) {
                $(`#${item.id}`).datepicker(settings);
            }
        });
    });
})(jQuery);

combine 2 comma separated list into one in php

I have 2 arrays that are coming from the database, [options] column has comma-separated values.

Array
(
    [0] => Array
        (
            [id] => 143
            [menu_id] => 590
            [name] => bread
            [options] => small, large
        )

    [1] => Array
        (
            [id] => 144
            [menu_id] => 590
            [name] => jam
            [options] => mango, orange, grape
        )

)

Is there have any way to combine the list of [options] at [0] and [1]?

Example: small, large, mango, orange, grape

Approach

 <?php foreach ($menu_options as $key => $menu_option) : ?>  
     <?PHP $exploded_variant_options = explode(',', $menu_option['options']);
           foreach ($exploded_variant_options as $exploded_variant_option) : ?>
                     <?php echo ucfirst(sanitize($exploded_variant_option)); ?> //print one by one
                             
          <?php endforeach; ?>
  <?php endforeach; ?>

Drupal 9: implementing custom functionality in PHP

I would really appreciate it if somebody would give me some hints about implementing/inserting custom functionality into a drupal 9 page with PHP code.
I am trying to write a PHP function that is generating a file based on some specific properties of Drupal users on a button click, and I do not know where to start.
I am really confused. Is there an easy way to insert PHP code into a Drupal basic page?
I am searching for solutions, but what I always find is custom modules where none of the given examples is working