[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * Created by PhpStorm.
   4   * User: nhw2h8s
   5   * Date: 7/2/14
   6   * Time: 5:45 PM
   7   */
   8  
   9  abstract class PHPExcel_Chart_Properties
  10  {
  11      const
  12          EXCEL_COLOR_TYPE_STANDARD = 'prstClr',
  13          EXCEL_COLOR_TYPE_SCHEME = 'schemeClr',
  14          EXCEL_COLOR_TYPE_ARGB = 'srgbClr';
  15  
  16      const
  17          AXIS_LABELS_LOW = 'low',
  18          AXIS_LABELS_HIGH = 'high',
  19          AXIS_LABELS_NEXT_TO = 'nextTo',
  20          AXIS_LABELS_NONE = 'none';
  21  
  22      const
  23          TICK_MARK_NONE = 'none',
  24          TICK_MARK_INSIDE = 'in',
  25          TICK_MARK_OUTSIDE = 'out',
  26          TICK_MARK_CROSS = 'cross';
  27  
  28      const
  29          HORIZONTAL_CROSSES_AUTOZERO = 'autoZero',
  30          HORIZONTAL_CROSSES_MAXIMUM = 'max';
  31  
  32      const
  33          FORMAT_CODE_GENERAL = 'General',
  34          FORMAT_CODE_NUMBER = '#,##0.00',
  35          FORMAT_CODE_CURRENCY = '$#,##0.00',
  36          FORMAT_CODE_ACCOUNTING = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)',
  37          FORMAT_CODE_DATE = 'm/d/yyyy',
  38          FORMAT_CODE_TIME = '[$-F400]h:mm:ss AM/PM',
  39          FORMAT_CODE_PERCENTAGE = '0.00%',
  40          FORMAT_CODE_FRACTION = '# ?/?',
  41          FORMAT_CODE_SCIENTIFIC = '0.00E+00',
  42          FORMAT_CODE_TEXT = '@',
  43          FORMAT_CODE_SPECIAL = '00000';
  44  
  45      const
  46          ORIENTATION_NORMAL = 'minMax',
  47          ORIENTATION_REVERSED = 'maxMin';
  48  
  49      const
  50          LINE_STYLE_COMPOUND_SIMPLE = 'sng',
  51          LINE_STYLE_COMPOUND_DOUBLE = 'dbl',
  52          LINE_STYLE_COMPOUND_THICKTHIN = 'thickThin',
  53          LINE_STYLE_COMPOUND_THINTHICK = 'thinThick',
  54          LINE_STYLE_COMPOUND_TRIPLE = 'tri',
  55  
  56          LINE_STYLE_DASH_SOLID = 'solid',
  57          LINE_STYLE_DASH_ROUND_DOT = 'sysDot',
  58          LINE_STYLE_DASH_SQUERE_DOT = 'sysDash',
  59          LINE_STYPE_DASH_DASH = 'dash',
  60          LINE_STYLE_DASH_DASH_DOT = 'dashDot',
  61          LINE_STYLE_DASH_LONG_DASH = 'lgDash',
  62          LINE_STYLE_DASH_LONG_DASH_DOT = 'lgDashDot',
  63          LINE_STYLE_DASH_LONG_DASH_DOT_DOT = 'lgDashDotDot',
  64  
  65          LINE_STYLE_CAP_SQUARE = 'sq',
  66          LINE_STYLE_CAP_ROUND = 'rnd',
  67          LINE_STYLE_CAP_FLAT = 'flat',
  68  
  69          LINE_STYLE_JOIN_ROUND = 'bevel',
  70          LINE_STYLE_JOIN_MITER = 'miter',
  71          LINE_STYLE_JOIN_BEVEL = 'bevel',
  72  
  73          LINE_STYLE_ARROW_TYPE_NOARROW = null,
  74          LINE_STYLE_ARROW_TYPE_ARROW = 'triangle',
  75          LINE_STYLE_ARROW_TYPE_OPEN = 'arrow',
  76          LINE_STYLE_ARROW_TYPE_STEALTH = 'stealth',
  77          LINE_STYLE_ARROW_TYPE_DIAMOND = 'diamond',
  78          LINE_STYLE_ARROW_TYPE_OVAL = 'oval',
  79  
  80          LINE_STYLE_ARROW_SIZE_1 = 1,
  81          LINE_STYLE_ARROW_SIZE_2 = 2,
  82          LINE_STYLE_ARROW_SIZE_3 = 3,
  83          LINE_STYLE_ARROW_SIZE_4 = 4,
  84          LINE_STYLE_ARROW_SIZE_5 = 5,
  85          LINE_STYLE_ARROW_SIZE_6 = 6,
  86          LINE_STYLE_ARROW_SIZE_7 = 7,
  87          LINE_STYLE_ARROW_SIZE_8 = 8,
  88          LINE_STYLE_ARROW_SIZE_9 = 9;
  89  
  90      const
  91          SHADOW_PRESETS_NOSHADOW = null,
  92          SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT = 1,
  93          SHADOW_PRESETS_OUTER_BOTTOM = 2,
  94          SHADOW_PRESETS_OUTER_BOTTOM_LEFT = 3,
  95          SHADOW_PRESETS_OUTER_RIGHT = 4,
  96          SHADOW_PRESETS_OUTER_CENTER = 5,
  97          SHADOW_PRESETS_OUTER_LEFT = 6,
  98          SHADOW_PRESETS_OUTER_TOP_RIGHT = 7,
  99          SHADOW_PRESETS_OUTER_TOP = 8,
 100          SHADOW_PRESETS_OUTER_TOP_LEFT = 9,
 101          SHADOW_PRESETS_INNER_BOTTTOM_RIGHT = 10,
 102          SHADOW_PRESETS_INNER_BOTTOM = 11,
 103          SHADOW_PRESETS_INNER_BOTTOM_LEFT = 12,
 104          SHADOW_PRESETS_INNER_RIGHT = 13,
 105          SHADOW_PRESETS_INNER_CENTER = 14,
 106          SHADOW_PRESETS_INNER_LEFT = 15,
 107          SHADOW_PRESETS_INNER_TOP_RIGHT = 16,
 108          SHADOW_PRESETS_INNER_TOP = 17,
 109          SHADOW_PRESETS_INNER_TOP_LEFT = 18,
 110          SHADOW_PRESETS_PERSPECTIVE_BELOW = 19,
 111          SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT = 20,
 112          SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT = 21,
 113          SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT = 22,
 114          SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT = 23;
 115  
 116      protected function getExcelPointsWidth($width)
 117      {
 118          return $width * 12700;
 119      }
 120  
 121      protected function getExcelPointsAngle($angle)
 122      {
 123          return $angle * 60000;
 124      }
 125  
 126      protected function getTrueAlpha($alpha)
 127      {
 128          return (string) 100 - $alpha . '000';
 129      }
 130  
 131      protected function setColorProperties($color, $alpha, $type)
 132      {
 133          return array(
 134              'type' => (string) $type,
 135              'value' => (string) $color,
 136              'alpha' => (string) $this->getTrueAlpha($alpha)
 137          );
 138      }
 139  
 140      protected function getLineStyleArrowSize($array_selector, $array_kay_selector)
 141      {
 142          $sizes = array(
 143              1 => array('w' => 'sm', 'len' => 'sm'),
 144              2 => array('w' => 'sm', 'len' => 'med'),
 145              3 => array('w' => 'sm', 'len' => 'lg'),
 146              4 => array('w' => 'med', 'len' => 'sm'),
 147              5 => array('w' => 'med', 'len' => 'med'),
 148              6 => array('w' => 'med', 'len' => 'lg'),
 149              7 => array('w' => 'lg', 'len' => 'sm'),
 150              8 => array('w' => 'lg', 'len' => 'med'),
 151              9 => array('w' => 'lg', 'len' => 'lg')
 152          );
 153  
 154          return $sizes[$array_selector][$array_kay_selector];
 155      }
 156  
 157      protected function getShadowPresetsMap($shadow_presets_option)
 158      {
 159          $presets_options = array(
 160              //OUTER
 161              1 => array(
 162                  'effect' => 'outerShdw',
 163                  'blur' => '50800',
 164                  'distance' => '38100',
 165                  'direction' => '2700000',
 166                  'algn' => 'tl',
 167                  'rotWithShape' => '0'
 168              ),
 169              2 => array(
 170                  'effect' => 'outerShdw',
 171                  'blur' => '50800',
 172                  'distance' => '38100',
 173                  'direction' => '5400000',
 174                  'algn' => 't',
 175                  'rotWithShape' => '0'
 176              ),
 177              3 => array(
 178                  'effect' => 'outerShdw',
 179                  'blur' => '50800',
 180                  'distance' => '38100',
 181                  'direction' => '8100000',
 182                  'algn' => 'tr',
 183                  'rotWithShape' => '0'
 184              ),
 185              4 => array(
 186                  'effect' => 'outerShdw',
 187                  'blur' => '50800',
 188                  'distance' => '38100',
 189                  'algn' => 'l',
 190                  'rotWithShape' => '0'
 191              ),
 192              5 => array(
 193                  'effect' => 'outerShdw',
 194                  'size' => array(
 195                      'sx' => '102000',
 196                      'sy' => '102000'
 197                  )
 198                  ,
 199                  'blur' => '63500',
 200                  'distance' => '38100',
 201                  'algn' => 'ctr',
 202                  'rotWithShape' => '0'
 203              ),
 204              6 => array(
 205                  'effect' => 'outerShdw',
 206                  'blur' => '50800',
 207                  'distance' => '38100',
 208                  'direction' => '10800000',
 209                  'algn' => 'r',
 210                  'rotWithShape' => '0'
 211              ),
 212              7 => array(
 213                  'effect' => 'outerShdw',
 214                  'blur' => '50800',
 215                  'distance' => '38100',
 216                  'direction' => '18900000',
 217                  'algn' => 'bl',
 218                  'rotWithShape' => '0'
 219              ),
 220              8 => array(
 221                  'effect' => 'outerShdw',
 222                  'blur' => '50800',
 223                  'distance' => '38100',
 224                  'direction' => '16200000',
 225                  'rotWithShape' => '0'
 226              ),
 227              9 => array(
 228                  'effect' => 'outerShdw',
 229                  'blur' => '50800',
 230                  'distance' => '38100',
 231                  'direction' => '13500000',
 232                  'algn' => 'br',
 233                  'rotWithShape' => '0'
 234              ),
 235              //INNER
 236              10 => array(
 237                  'effect' => 'innerShdw',
 238                  'blur' => '63500',
 239                  'distance' => '50800',
 240                  'direction' => '2700000',
 241              ),
 242              11 => array(
 243                  'effect' => 'innerShdw',
 244                  'blur' => '63500',
 245                  'distance' => '50800',
 246                  'direction' => '5400000',
 247              ),
 248              12 => array(
 249                  'effect' => 'innerShdw',
 250                  'blur' => '63500',
 251                  'distance' => '50800',
 252                  'direction' => '8100000',
 253              ),
 254              13 => array(
 255                  'effect' => 'innerShdw',
 256                  'blur' => '63500',
 257                  'distance' => '50800',
 258              ),
 259              14 => array(
 260                  'effect' => 'innerShdw',
 261                  'blur' => '114300',
 262              ),
 263              15 => array(
 264                  'effect' => 'innerShdw',
 265                  'blur' => '63500',
 266                  'distance' => '50800',
 267                  'direction' => '10800000',
 268              ),
 269              16 => array(
 270                  'effect' => 'innerShdw',
 271                  'blur' => '63500',
 272                  'distance' => '50800',
 273                  'direction' => '18900000',
 274              ),
 275              17 => array(
 276                  'effect' => 'innerShdw',
 277                  'blur' => '63500',
 278                  'distance' => '50800',
 279                  'direction' => '16200000',
 280              ),
 281              18 => array(
 282                  'effect' => 'innerShdw',
 283                  'blur' => '63500',
 284                  'distance' => '50800',
 285                  'direction' => '13500000',
 286              ),
 287              //perspective
 288              19 => array(
 289                  'effect' => 'outerShdw',
 290                  'blur' => '152400',
 291                  'distance' => '317500',
 292                  'size' => array(
 293                      'sx' => '90000',
 294                      'sy' => '-19000',
 295                  ),
 296                  'direction' => '5400000',
 297                  'rotWithShape' => '0',
 298              ),
 299              20 => array(
 300                  'effect' => 'outerShdw',
 301                  'blur' => '76200',
 302                  'direction' => '18900000',
 303                  'size' => array(
 304                      'sy' => '23000',
 305                      'kx' => '-1200000',
 306                  ),
 307                  'algn' => 'bl',
 308                  'rotWithShape' => '0',
 309              ),
 310              21 => array(
 311                  'effect' => 'outerShdw',
 312                  'blur' => '76200',
 313                  'direction' => '13500000',
 314                  'size' => array(
 315                      'sy' => '23000',
 316                      'kx' => '1200000',
 317                  ),
 318                  'algn' => 'br',
 319                  'rotWithShape' => '0',
 320              ),
 321              22 => array(
 322                  'effect' => 'outerShdw',
 323                  'blur' => '76200',
 324                  'distance' => '12700',
 325                  'direction' => '2700000',
 326                  'size' => array(
 327                      'sy' => '-23000',
 328                      'kx' => '-800400',
 329                  ),
 330                  'algn' => 'bl',
 331                  'rotWithShape' => '0',
 332              ),
 333              23 => array(
 334                  'effect' => 'outerShdw',
 335                  'blur' => '76200',
 336                  'distance' => '12700',
 337                  'direction' => '8100000',
 338                  'size' => array(
 339                      'sy' => '-23000',
 340                      'kx' => '800400',
 341                  ),
 342                  'algn' => 'br',
 343                  'rotWithShape' => '0',
 344              ),
 345          );
 346  
 347          return $presets_options[$shadow_presets_option];
 348      }
 349  
 350      protected function getArrayElementsValue($properties, $elements)
 351      {
 352          $reference = & $properties;
 353          if (!is_array($elements)) {
 354              return $reference[$elements];
 355          } else {
 356              foreach ($elements as $keys) {
 357                  $reference = & $reference[$keys];
 358              }
 359              return $reference;
 360          }
 361          return $this;
 362      }
 363  }