True Light Designs Blog

Excel Compatible Partnumbers

Tuesday, 14 September 2021 15:51

Tim Ramsey

0 Comments

$compatible_partnums = [];
//param &$compatible_partnums

//Add the shared identifier and the unique identifier
if (array_key_exists('hardwarenum', $items)) {
    $compatible_partnums[$items['hardwarenum']][] = $items['partnum'];
}

$compats = array_map(function($k, $v) {
    return [$k, implode(', ', $v)];
}, array_keys($compatible_partnums), $compatible_partnums);
Excel::create($filename.
        '-hw',
        function($excel) use($newArray, $compats) {
            $excel - > sheet('Sheetname', function($sheet) use($newArray, $compats) {
                $sheet - > fromArray($compats);
            });
        }) - >
    export ('csv');

$compatible_partnums = [];

//param &$compatible_partnums

//Add the shared identifier and the unique identifier

if (array_key_exists('hardwarenum', $items)) {

$compatible_partnums[$items['hardwarenum']][] = $items['partnum'];

}

$compats = array_map(function($k, $v) {

return [$k, implode(', ', $v)];

}, array_keys($compatible_partnums), $compatible_partnums);

Excel::create($filename.

'-hw',

function($excel) use($newArray, $compats) {

$excel - > sheet('Sheetname', function($sheet) use($newArray, $compats) {

$sheet - > fromArray($compats);

});

}) - >

export ('csv');

WHMCS Oauth userinfo.php not working

Wednesday, 21 July 2021 17:07

Tim Ramsey

0 Comments

I was trying to incorporate SSO in Freshdesk with WHMCS, but because WHMCS requires passing a query parameter = access_token instead of using the Authorization header, this is what you need to do to make it work.

1. Reveal Authorization Header in .htaccess

CGIPassAuth on

1	CGIPassAuth on

2. Use your own oauth-intermediary.php where you take the header and send the query parameter that WHMCS is expecting

<?php
//https://www.yousite.com/oauth/userinfo.php
//https://www.yousite.com/oauth-intermediary.php
header('Content-Type: application/json');
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"https://www.youtsite.com/oauth/userinfo.php?access_token=".str_replace("Bearer ","",getallheaders()["Authorization"]));
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$server_output = curl_exec($ch);
echo $server_output;
curl_close ($ch);

<?php

//https://www.yousite.com/oauth/userinfo.php

//https://www.yousite.com/oauth-intermediary.php

header('Content-Type: application/json');

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,"https://www.youtsite.com/oauth/userinfo.php?access_token=".str_replace("Bearer ","",getallheaders()["Authorization"]));

curl_setopt($ch, CURLOPT_POST, 1);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$server_output = curl_exec($ch);

echo $server_output;

curl_close ($ch);

3. User your new https://www.yousite.com/oauth-intermediary.php as the new userinfo.php URL when requested

Loop Spreadsheet and Update image height/width

Friday, 14 May 2021 19:13

Tim Ramsey

0 Comments

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(storage_path('file.xlsx'));
        $worksheet = $spreadsheet->getActiveSheet();
        $highestRow = $worksheet->getHighestRow();
        for($row = 1; $row <= $highestRow; ++$row){;
            $value = $worksheet->getCellByColumnAndRow(23, $row)->getValue();
            $doc = new \DOMDocument();
            @$doc->loadHTML('<node>' . $value .'</node>', LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD);
            $images = $doc->getElementsByTagName('img');
            foreach ($images as $image) {
                if(!$image->hasAttribute('height') || $image->hasAttribute('width')){
                    $src = $image->getAttribute('src');
                    list($width, $height, $type, $attr) = @getimagesize($src);
                    if((int) $height > 0) {
                        $image->setAttribute('height', $height);
                    }
                    if((int) $width > 0) {
                        $image->setAttribute('width', $width);
                    }
                }
            }
            $document = utf8_decode($doc->saveHTML($doc->documentElement));
            $worksheet->setCellValueByColumnAndRow(23, $row, str_replace(array('<node>','</node>') , '' , $document));
        }
        $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
        $writer->save(storage_path('file-new.xlsx'));

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(storage_path('file.xlsx'));

$worksheet = $spreadsheet->getActiveSheet();

$highestRow = $worksheet->getHighestRow();

for($row = 1; $row <= $highestRow; ++$row){;

$value = $worksheet->getCellByColumnAndRow(23, $row)->getValue();

$doc = new \DOMDocument();

@$doc->loadHTML('<node>' . $value .'</node>', LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD);

$images = $doc->getElementsByTagName('img');

foreach ($images as $image) {

if(!$image->hasAttribute('height') || $image->hasAttribute('width')){

$src = $image->getAttribute('src');

list($width, $height, $type, $attr) = @getimagesize($src);

if((int) $height > 0) {

$image->setAttribute('height', $height);

}

if((int) $width > 0) {

$image->setAttribute('width', $width);

}

$document = utf8_decode($doc->saveHTML($doc->documentElement));

$worksheet->setCellValueByColumnAndRow(23, $row, str_replace(array('<node>','</node>') , '' , $document));

}

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);

$writer->save(storage_path('file-new.xlsx'));

Github permission denied from cPanel

Tuesday, 29 December 2020 16:45

Tim Ramsey

0 Comments

For some reason cPanel private keys are needing to be manually added for it to connect to github properly

ssh-add /home/your_user_name/.ssh/you_private_key_file

1	ssh-add /home/your_user_name/.ssh/you_private_key_file

Also, I ran into an issue where the ssh-agent was not running and needed to be restarted with

ssh-agent bash

1	ssh-agent bash

Page 1 of 13

Excel Compatible Partnumbers

WHMCS Oauth userinfo.php not working

Loop Spreadsheet and Update image height/width

Github permission denied from cPanel

Categories

Recent Posts