<?php

namespace PhpOffice\PhpSpreadsheet\Shared;

use GdImage;

> use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;

> use SimpleXMLElement;


class Drawing
{
    /**
     * Convert pixels to EMU.
     *

<      * @param int $pValue Value in pixels



>      * @param int $pixelValue Value in pixels


     *
     * @return int Value in EMU
     */

<     public static function pixelsToEMU($pValue)



>     public static function pixelsToEMU($pixelValue)


    {

<         return round($pValue * 9525);



>         return $pixelValue * 9525;


    }

    /**
     * Convert EMU to pixels.
     *

<      * @param int $pValue Value in EMU



>      * @param int|SimpleXMLElement $emuValue Value in EMU


     *
     * @return int Value in pixels
     */

<     public static function EMUToPixels($pValue)



>     public static function EMUToPixels($emuValue)


    {

<         if ($pValue != 0) {
<             return round($pValue / 9525);



>         $emuValue = (int) $emuValue;
>         if ($emuValue != 0) {
>             return (int) round($emuValue / 9525);


        }

        return 0;
    }

    /**
     * Convert pixels to column width. Exact algorithm not known.
     * By inspection of a real Excel file using Calibri 11, one finds 1000px ~ 142.85546875
     * This gives a conversion factor of 7. Also, we assume that pixels and font size are proportional.
     *

<      * @param int $pValue Value in pixels
<      * @param \PhpOffice\PhpSpreadsheet\Style\Font $pDefaultFont Default font of the workbook



>      * @param int $pixelValue Value in pixels


     *

<      * @return int Value in cell dimension



>      * @return float|int Value in cell dimension


     */

<     public static function pixelsToCellDimension($pValue, \PhpOffice\PhpSpreadsheet\Style\Font $pDefaultFont)



>     public static function pixelsToCellDimension($pixelValue, \PhpOffice\PhpSpreadsheet\Style\Font $defaultFont)


    {
        // Font name and size

<         $name = $pDefaultFont->getName();
<         $size = $pDefaultFont->getSize();



>         $name = $defaultFont->getName();
>         $size = $defaultFont->getSize();



        if (isset(Font::$defaultColumnWidths[$name][$size])) {
            // Exact width can be determined

<             $colWidth = $pValue * Font::$defaultColumnWidths[$name][$size]['width'] / Font::$defaultColumnWidths[$name][$size]['px'];
<         } else {
<             // We don't have data for this particular font and size, use approximation by
<             // extrapolating from Calibri 11
<             $colWidth = $pValue * 11 * Font::$defaultColumnWidths['Calibri'][11]['width'] / Font::$defaultColumnWidths['Calibri'][11]['px'] / $size;



>             return $pixelValue * Font::$defaultColumnWidths[$name][$size]['width']
>                 / Font::$defaultColumnWidths[$name][$size]['px'];


        }


<         return $colWidth;



>         // We don't have data for this particular font and size, use approximation by
>         // extrapolating from Calibri 11
>         return $pixelValue * 11 * Font::$defaultColumnWidths['Calibri'][11]['width']
>             / Font::$defaultColumnWidths['Calibri'][11]['px'] / $size;


    }

    /**
     * Convert column width from (intrinsic) Excel units to pixels.
     *

<      * @param float $pValue Value in cell dimension
<      * @param \PhpOffice\PhpSpreadsheet\Style\Font $pDefaultFont Default font of the workbook



>      * @param float $cellWidth Value in cell dimension
>      * @param \PhpOffice\PhpSpreadsheet\Style\Font $defaultFont Default font of the workbook


     *
     * @return int Value in pixels
     */

<     public static function cellDimensionToPixels($pValue, \PhpOffice\PhpSpreadsheet\Style\Font $pDefaultFont)



>     public static function cellDimensionToPixels($cellWidth, \PhpOffice\PhpSpreadsheet\Style\Font $defaultFont)


    {
        // Font name and size

<         $name = $pDefaultFont->getName();
<         $size = $pDefaultFont->getSize();



>         $name = $defaultFont->getName();
>         $size = $defaultFont->getSize();



        if (isset(Font::$defaultColumnWidths[$name][$size])) {
            // Exact width can be determined

<             $colWidth = $pValue * Font::$defaultColumnWidths[$name][$size]['px'] / Font::$defaultColumnWidths[$name][$size]['width'];



>             $colWidth = $cellWidth * Font::$defaultColumnWidths[$name][$size]['px']
>                 / Font::$defaultColumnWidths[$name][$size]['width'];


        } else {
            // We don't have data for this particular font and size, use approximation by
            // extrapolating from Calibri 11

<             $colWidth = $pValue * $size * Font::$defaultColumnWidths['Calibri'][11]['px'] / Font::$defaultColumnWidths['Calibri'][11]['width'] / 11;



>             $colWidth = $cellWidth * $size * Font::$defaultColumnWidths['Calibri'][11]['px']
>                 / Font::$defaultColumnWidths['Calibri'][11]['width'] / 11;


        }

        // Round pixels to closest integer
        $colWidth = (int) round($colWidth);

        return $colWidth;
    }

    /**
     * Convert pixels to points.
     *

<      * @param int $pValue Value in pixels



>      * @param int $pixelValue Value in pixels


     *
     * @return float Value in points
     */

<     public static function pixelsToPoints($pValue)



>     public static function pixelsToPoints($pixelValue)


    {

<         return $pValue * 0.75;



>         return $pixelValue * 0.75;


    }

    /**
     * Convert points to pixels.
     *

<      * @param int $pValue Value in points



>      * @param int $pointValue Value in points


     *
     * @return int Value in pixels
     */

<     public static function pointsToPixels($pValue)



>     public static function pointsToPixels($pointValue)


    {

<         if ($pValue != 0) {
<             return (int) ceil($pValue / 0.75);



>         if ($pointValue != 0) {
>             return (int) ceil($pointValue / 0.75);


        }

        return 0;
    }

    /**
     * Convert degrees to angle.
     *

<      * @param int $pValue Degrees



>      * @param int $degrees Degrees


     *
     * @return int Angle
     */

<     public static function degreesToAngle($pValue)



>     public static function degreesToAngle($degrees)


    {

<         return (int) round($pValue * 60000);



>         return (int) round($degrees * 60000);


    }

    /**
     * Convert angle to degrees.
     *

<      * @param int $pValue Angle



>      * @param int|SimpleXMLElement $angle Angle


     *
     * @return int Degrees
     */

<     public static function angleToDegrees($pValue)



>     public static function angleToDegrees($angle)


    {

<         if ($pValue != 0) {
<             return round($pValue / 60000);



>         $angle = (int) $angle;
>         if ($angle != 0) {
>             return (int) round($angle / 60000);


        }

        return 0;
    }

    /**
     * Create a new image from file. By alexander at alexauto dot nl.
     *
     * @see http://www.php.net/manual/en/function.imagecreatefromwbmp.php#86214
     *

<      * @param string $p_sFile Path to Windows DIB (BMP) image



>      * @param string $bmpFilename Path to Windows DIB (BMP) image


     *
     * @return GdImage|resource

>      *
     */
>      * @deprecated 1.26 use Php function imagecreatefrombmp instead
    public static function imagecreatefrombmp($p_sFile)
>      *
    {
>      * @codeCoverageIgnore



<     public static function imagecreatefrombmp($p_sFile)



>     public static function imagecreatefrombmp($bmpFilename)



<         //    Load the image into a string
<         $file = fopen($p_sFile, 'rb');
<         $read = fread($file, 10);
<         while (!feof($file) && ($read != '')) {
<             $read .= fread($file, 1024);



>         $retVal = @imagecreatefrombmp($bmpFilename);
>         if ($retVal === false) {
>             throw new ReaderException("Unable to create image from $bmpFilename");




<         $temp = unpack('H*', $read);
<         $hex = $temp[1];
<         $header = substr($hex, 0, 108);
< 
<         //    Process the header
<         //    Structure: http://www.fastgraph.com/help/bmp_header_format.html
<         if (substr($header, 0, 4) == '424d') {
<             //    Cut it in parts of 2 bytes
<             $header_parts = str_split($header, 2);
< 
<             //    Get the width        4 bytes
<             $width = hexdec($header_parts[19] . $header_parts[18]);
< 
<             //    Get the height        4 bytes
<             $height = hexdec($header_parts[23] . $header_parts[22]);
< 
<             //    Unset the header params
<             unset($header_parts);
<         }
< 
<         //    Define starting X and Y
<         $x = 0;
<         $y = 1;
< 
<         //    Create newimage
<         $image = imagecreatetruecolor($width, $height);
< 
<         //    Grab the body from the image
<         $body = substr($hex, 108);
< 
<         //    Calculate if padding at the end-line is needed
<         //    Divided by two to keep overview.
<         //    1 byte = 2 HEX-chars
<         $body_size = (strlen($body) / 2);
<         $header_size = ($width * $height);
< 
<         //    Use end-line padding? Only when needed
<         $usePadding = ($body_size > ($header_size * 3) + 4);
< 
<         //    Using a for-loop with index-calculation instaid of str_split to avoid large memory consumption
<         //    Calculate the next DWORD-position in the body
<         for ($i = 0; $i < $body_size; $i += 3) {
<             //    Calculate line-ending and padding
<             if ($x >= $width) {
<                 // If padding needed, ignore image-padding
<                 // Shift i to the ending of the current 32-bit-block
<                 if ($usePadding) {
<                     $i += $width % 4;
<                 }
< 
<                 //    Reset horizontal position
<                 $x = 0;
< 
<                 //    Raise the height-position (bottom-up)
<                 ++$y;
< 
<                 //    Reached the image-height? Break the for-loop
<                 if ($y > $height) {
<                     break;
<                 }
<             }
< 
<             // Calculation of the RGB-pixel (defined as BGR in image-data)
<             // Define $i_pos as absolute position in the body
<             $i_pos = $i * 2;
<             $r = hexdec($body[$i_pos + 4] . $body[$i_pos + 5]);
<             $g = hexdec($body[$i_pos + 2] . $body[$i_pos + 3]);
<             $b = hexdec($body[$i_pos] . $body[$i_pos + 1]);
< 
<             // Calculate and draw the pixel
<             $color = imagecolorallocate($image, $r, $g, $b);
<             imagesetpixel($image, $x, $height - $y, $color);
< 
<             // Raise the horizontal position
<             ++$x;
<         }
< 
<         // Unset the body / free the memory
<         unset($body);
< 
<         //    Return image-object
<         return $image;



>         return $retVal;


    }
}