</div>
<?php 
/*
$TEST = $baseService->getDB()->Execute("SELECT * FROM BO_PHAN WHERE TRUE");
debugging_p($TEST);
$TEST2 = $baseService->getDB()->GetAll("SELECT * FROM BO_PHAN WHERE TRUE");
debugging_p($TEST2);

$arr234 = $baseService->getDB()->GetAssoc("select * from BO_PHAN"); # returns associative array $key=>col
debugging_p($arr234);
*/
//build a staic header
$boPhanArray = $baseService->getDB()->GetAll("SELECT * FROM BO_PHAN WHERE TRUE");
$loaiNgayArray = $baseService->getDB()->GetAll("SELECT * FROM LOAI_NGAY WHERE TRUE");
debugging_p($boPhanArray, "bophanArray");
debugging_p($loaiNgayArray, "loaiNgayArray");
$htmlHeader = "";
$firstRowHeader = "";
$secondRowHeader = "";
// add chi Nhanh - ca columns
$firstRowHeader = '<th class="sorting_disabled" colspan="1" rowspan="2">Chi nhánh - Ca</th>';
//$secondRowHeader = '<th class="sorting_disabled" colspan="0"></th>';
foreach ($loaiNgayArray as $loaiNgay) {
    //debugging("asd");
    $firstRowHeader = $firstRowHeader . '<th align="center" class="sorting_disabled" colspan="' . count($boPhanArray) . '" rowspan="1"><div align="center">' . $loaiNgay['TEN'] . '</div></th>';
}
$firstRowHeader = '<tr role="row">' . $firstRowHeader . '</tr>';
foreach ($loaiNgayArray as $loaiNgay) {
    foreach ($boPhanArray as $boPhan) {
        $secondRowHeader = $secondRowHeader . '<th class="sorting_disabled" colspan="1" rowspan="1">' . $boPhan['TEN'] . '</th>';
    }
 public function addElementMultiPrimaryKey($table, $obj)
 {
     $ele = new $table();
     //debugging_p($ele, "ele")	;
     $PrimaryKeyName = $ele->PrimaryKeyName();
     debugging_p($PrimaryKeyName, "PrimaryKeyName");
     $arrArgLoad = array();
     $strPrimaryKeyName = "";
     foreach ($PrimaryKeyName as $pkey) {
         array_push($arrArgLoad, $obj[$pkey]);
         $strPrimaryKeyName = $strPrimaryKeyName . $pkey . ' = ? ';
         if ($i < count($PrimaryKeyName) - 1) {
             $strPrimaryKeyName = $strPrimaryKeyName . ' AND ';
         }
         $i++;
     }
     $ele->Load($strPrimaryKeyName, $arrArgLoad);
     //check in database the existance of this record or not.
     /*
     $strPrimaryKeyName = '';
     $i = 0;
     foreach ($PrimaryKeyName as $pkey) {
     	$strPrimaryKeyName = $strPrimaryKeyName.$pkey.' = '.$obj[$pkey];
     	if ($i < count($PrimaryKeyName) - 1) {
     		$strPrimaryKeyName = $strPrimaryKeyName.' AND ';
     		}
     	$i++;
     }
     
     //$strPrimaryKeyName = $strPrimaryKeyName.'TRUE ';
     
     $ele->Load($strPrimaryKeyName);
     */
     debugging_p($ele, "ele");
     //update this record with new content.
     /*
     foreach($obj as $k=>$v){
     	if($k == 't' || $k == 'a' || $k == 'id'){
     		continue;	
     	}
     	if($v == "NULL"){
     		$v = null;	
     	}
     	$ele->$k = $v;	
     }
     */
     $ele->SO_LUONG = $obj['SO_LUONG'];
     debugging_p($ele, "ele after update new content");
     $ok = $ele->Save();
     debugging_p($ele, "ele after saved");
     if (!$ok) {
         debugging($ele->ErrorMsg(), "ele->ErrorMsg()");
         //error_log($ele->ErrorMsg());
         return $this->findError($ele->ErrorMsg());
     }
     return $ele->SO_LUONG;
 }