/frontend/components/ActualTimeline.php

https://gitlab.com/abigabaw/dptt · PHP · 155 lines · 111 code · 29 blank · 15 comment · 0 complexity · 55107e656131ad0b211d0baeaafaf19d MD5 · raw file 

    

  1. <?php

    2. 

  2. namespace frontend\components;

    3. 

  3. use Yii;

    4. 

  4. use yii\base\Widget;

    5. 

  5. use frontend\models\Queries;

    6. 

  6. use frontend\models\IterationType;

    7. 

  7. /*

    8. 

  8. How to run the widget:

    9. 

  9. 

    10. 

  10. use frontend\components\DPTTInfo;

    11. 

  11. <?=DPTTInfo::widget(['message' => ' Yii2.0']) ?>

    12. 

  12. 

    13. 

  13. */

    14. 

  14. class ActualTimeline extends Widget{

    15. 

  15. 	public $id;

    16. 

  16. 	public $elementid;

    17. 

  17.   public $normal_color;

    18. 

  18.   public $repeat_color;

    19. 

  19.   public $iteration_color;

    20. 

  20. 

    21. 

  21. 	//Data for normal progress

    22. 

  22.   public $dataset_normal;

    23. 

  23. 	public $dataset_data_normal;

    24. 

  24.   

    25. 

  25.   //Data for extension of normal progress

    26. 

  26.   public $dataset_normal_extension;

    27. 

  27.   public $dataset_data_normal_extension;

    28. 

  28. 	

    29. 

  29.   //Data for repeat of milestone

    30. 

  30.   public $dataset_repeat;

    31. 

  31. 	public $dataset_data_repeat;

    32. 

  32.   //Data for extension of repeat of milestone

    33. 

  33.   public $dataset_repeat_extension;

    34. 

  34.   public $dataset_data_repeat_extension;

    35. 

  35. 

    36. 

  36.   

    37. 

  37.   //Data for iteration of milestone

    38. 

  38. 	public $dataset_iteration;

    39. 

  39. 	public $dataset_data_iteration;

    40. 

  40.   //Data for extension of iteration of milestone

    41. 

  41.   public $dataset_iteration_extension;

    42. 

  42.   public $dataset_data_iteration_extension;

    43. 

  43. 

    44. 

  44. 

    45. 

  45. 	public function init(){

    46. 

  46. 	$qry                 = Yii::$app->db->createCommand(Queries::qryMilestoneSubmission($this->id))->queryAll();

    47. 

  47.   $this->normal_color     = IterationType::findOne(1)->color_code;

    48. 

  48.   $this->repeat_color     = IterationType::findOne(3)->color_code;

    49. 

  49.   $this->iteration_color  = IterationType::findOne(5)->color_code;

    50. 

  50.     foreach($qry as $key => $ar){

    51. 

  51.     	switch($ar['iteration_type']){

    52. 

  52.     	case 1:

    53. 

  53.             $this->dataset_normal .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    54. 

  54.             $this->dataset_data_normal .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Started milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    55. 

  55.            	

    56. 

  56.            	$this->dataset_normal .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    57. 

  57.             $this->dataset_data_normal .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    58. 

  58.         	//set other values to null

    59. 

  59.         break;

    60. 

  60.       case 2:

    61. 

  61.             $this->dataset_normal_extension .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    62. 

  62.             $this->dataset_data_normal_extension .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Extended milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    63. 

  63.             

    64. 

  64.             $this->dataset_normal_extension .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    65. 

  65.             $this->dataset_data_normal_extension .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    66. 

  66.           //set other values to null

    67. 

  67.             $this->dataset_normal .= '{ x: '.strtotime($ar['start_date']).'000, y: null },';

    68. 

  68.             $this->dataset_normal .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    69. 

  69.     

    70. 

  70. 

    71. 

  71. 

    72. 

  72.         break;

    73. 

  73.       case 3:

    74. 

  74.         	  $this->dataset_repeat .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    75. 

  75.             $this->dataset_data_repeat .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Started repeat of milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    76. 

  76.            	

    77. 

  77.            	$this->dataset_repeat .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    78. 

  78.             $this->dataset_data_repeat .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted repeat of milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    79. 

  79.       	break;

    80. 

  80.       case 4:

    81. 

  81.             $this->dataset_repeat_extension .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    82. 

  82.             $this->dataset_data_repeat_extension .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Extended milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    83. 

  83.             

    84. 

  84.             $this->dataset_repeat_extension .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    85. 

  85.             $this->dataset_data_repeat_extension .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted  of milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    86. 

  86.             

    87. 

  87.             $this->dataset_repeat .= '{ x: '.strtotime($ar['start_date']).'000, y: null },';

    88. 

  88.             $this->dataset_repeat .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    89. 

  89.     

    90. 

  90. 

    91. 

  91.         break;

    92. 

  92.       case 5:

    93. 

  93.         	  $this->dataset_iteration .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    94. 

  94.             $this->dataset_data_iteration .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Started iteration of milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    95. 

  95.            	

    96. 

  96.            	$this->dataset_iteration .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    97. 

  97.             $this->dataset_data_iteration .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted iteration of milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    98. 

  98.       	   

    99. 

  99. 

    100. 

  100.         break;

    101. 

  101.       	case 6:

    102. 

  102.         	$this->dataset_iteration_extension .= '{ x: '.strtotime($ar['start_date']).'000, y: '.$ar['milestone_id'].' },';

    103. 

  103.           $this->dataset_data_iteration_extension .='{ x: '.strtotime($ar['start_date']).'000, text: \'<b>Extended milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    104. 

  104.            	

    105. 

  105.           $this->dataset_iteration_extension .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    106. 

  106.           $this->dataset_data_iteration_extension .='{ x: '.strtotime($ar['end_date']).'000, text: \'<b>Submitted milestone:</b> <br/>'.str_replace('\'', '', $ar['milestone']).'<br/>\' },';

    107. 

  107.       	

    108. 

  108.         	$this->dataset_iteration .= '{ x: '.strtotime($ar['start_date']).'000, y: null },';

    109. 

  109.           $this->dataset_iteration .= '{ x: '.strtotime($ar['end_date']).'000, y: '.$ar['milestone_id'].' },';

    110. 

  110.       	break;

    111. 

  111.         }	

    112. 

  112.         }

    113. 

  113.         $this->dataset_normal 			                 = rtrim($this->dataset_normal);

    114. 

  114.         $this->dataset_data_normal 		               = rtrim($this->dataset_data_normal);

    115. 

  115. 

    116. 

  116.         $this->dataset_normal_extension              = rtrim($this->dataset_normal_extension);

    117. 

  117.         $this->dataset_data_normal_extension         = rtrim($this->dataset_data_normal_extension);

    118. 

  118. 

    119. 

  119.         $this->dataset_repeat 			                 = rtrim($this->dataset_repeat);

    120. 

  120.         $this->dataset_data_repeat 		               = rtrim($this->dataset_data_repeat);

    121. 

  121. 

    122. 

  122.         $this->dataset_repeat_extension              = rtrim($this->dataset_repeat_extension);

    123. 

  123.         $this->dataset_data_repeat_extension         = rtrim($this->dataset_data_repeat_extension);

    124. 

  124. 

    125. 

  125.         $this->dataset_iteration 		                 = rtrim($this->dataset_iteration);

    126. 

  126.         $this->dataset_data_iteration 	             = rtrim($this->dataset_data_iteration);

    127. 

  127. 

    128. 

  128.         $this->dataset_iteration_extension           = rtrim($this->dataset_iteration_extension);

    129. 

  129.         $this->dataset_data_iteration_extension      = rtrim($this->dataset_data_iteration_extension);

    130. 

  130. 

    131. 

  131.     }

    132. 

  132. 

    133. 

  133. 	public function run(){

    134. 

  134. 	return $this->render('/widget/actualtimeline',

    135. 

  135. 						[

    136. 

  136.             'normal_color'                      => $this->normal_color,

    137. 

  137.             'repeat_color'                      => $this->repeat_color,

    138. 

  138.             'iteration_color'                   => $this->iteration_color,

    139. 

  139. 						'dataset_normal' 			              => $this->dataset_normal,

    140. 

  140. 						'dataset_data_normal' 		          => $this->dataset_data_normal,

    141. 

  141.             'dataset_normal_extension'          => $this->dataset_normal_extension,

    142. 

  142.             'dataset_data_normal_extension'     => $this->dataset_data_normal_extension,

    143. 

  143. 						'dataset_repeat' 			              => $this->dataset_repeat,

    144. 

  144. 						'dataset_data_repeat' 		          => $this->dataset_data_repeat,

    145. 

  145.             'dataset_repeat_extension'          => $this->dataset_repeat_extension,

    146. 

  146.             'dataset_data_repeat_extension'     => $this->dataset_data_repeat_extension,

    147. 

  147. 						'dataset_iteration' 		            => $this->dataset_iteration,

    148. 

  148. 						'dataset_data_iteration' 	          => $this->dataset_data_iteration,

    149. 

  149.             'dataset_iteration_extension'       => $this->dataset_iteration,

    150. 

  150.             'dataset_data_iteration_extension'  => $this->dataset_data_iteration,

    151. 

  151. 						'elementid'					                => $this->elementid,

    152. 

  152. 						]);

    153. 

  153. 	}

    154. 

  154. }

    155. 

  155. ?>
    156.