<a href="<?php
echo $root . '/logout.php';
?>
" >
Sair
</a>
</div>
<!-- MENU LATERAL ALTERNATIVO
<div style="width:260px; height:800px; float:left;" >
<hr noshade="noshade" style="width:260px; color:white;" />
<?php
foreach ($contractArray as $contract) {
$contractNum = str_pad($contract->numero, 5, '0', STR_PAD_LEFT);
$clientName = new Text(BusinessPartnerDAO::GetClientName($dataConnector->sqlserverConnection, $contract->pn));
$contractStatus = ContractDAO::GetStatusAsText($contract->status);
$subContractArray = $subContractDAO->RetrieveRecordArray("contrato_id=" . $contract->id);
$typeEnumeration = "";
foreach ($subContractArray as $subContract) {
if (!empty($typeEnumeration)) {
$typeEnumeration .= ', ';
}
$typeEnumeration .= $subContract->siglaTipoContrato;
}
$contractTypes = new Text($typeEnumeration);
$tags = $contractNum . ' ' . $clientName->Truncate(50) . ' ' . $contractTypes->Truncate(20) . ' ' . $contractStatus;
echo '<a style="float:left; text-align:center;" class="contractIcon" rel="' . $contract->id . '" rev="' . $tags . '" >';
echo '<img src="' . $pathImg . '/document.png" alt="" style="width:50px; height:50px;" /><br/>';
echo $contractNum;
echo '</a>';
}
function BuildReportTable($startColumn, $startRow)
{
global $dataConnector;
global $objPhpExcel;
global $contractArray;
global $model;
global $searchMethod;
$contractDAO = new ContractDAO($dataConnector->mysqlConnection);
$contractDAO->showErrors = 1;
$subContractDAO = new SubContractDAO($dataConnector->mysqlConnection);
$subContractDAO->showErrors = 1;
$contractItemDAO = new ContractItemDAO($dataConnector->mysqlConnection);
$contractItemDAO->showErrors = 1;
$equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection);
$equipmentDAO->showErrors = 1;
$equipmentModelDAO = new EquipmentModelDAO($dataConnector->mysqlConnection);
$equipmentModelDAO->showErrors = 1;
$salesPersonDAO = new SalesPersonDAO($dataConnector->sqlserverConnection);
$salesPersonDAO->showErrors = 1;
// Define o titulo da tabela
$currentRow = $startRow;
$activeSheet = $objPhpExcel->getActiveSheet();
$activeSheet->setCellValue($startColumn . $startRow, 'CONTRATOS');
$styleArray = array('font' => array('bold' => true, 'size' => 16));
$activeSheet->getStyle($startColumn . $startRow . ':' . $startColumn . $startRow)->applyFromArray($styleArray);
// Cria o cabeçalho da tabela
$colNum = ord($startColumn);
$headers = array('Número', 'Cliente', 'Detalhes', 'Assinatura', 'Encerramento', 'Inicio do Atendimento', 'Fim do Atendimento', 'Parcela', 'Vendedor', 'Status', 'Global(S OU N)');
$offset = 0;
foreach ($headers as $header) {
$activeSheet->getColumnDimension(chr($colNum + $offset))->setWidth(25);
$offset++;
}
$activeSheet->getColumnDimension(chr($colNum + 1))->setWidth(50);
$activeSheet->getColumnDimension(chr($colNum + 2))->setWidth(50);
$currentRow++;
InsereLinhaPlanilha($currentRow, $startColumn, $headers, PHPExcel_Style_Color::COLOR_YELLOW, 30, PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// Busca os modelos de equipamento cadastrados no sistema
$modelArray = array(0 => "");
$equipmentModelArray = $equipmentModelDAO->RetrieveRecordArray();
foreach ($equipmentModelArray as $modelDTO) {
$modelArray[$modelDTO->id] = $modelDTO->modelo;
}
// Busca os vendedores cadastrados no sistema
$retrievedArray = $salesPersonDAO->RetrieveRecordArray();
$salesPersonArray = array();
foreach ($retrievedArray as $salesPersonDTO) {
$salesPersonArray[$salesPersonDTO->slpCode] = $salesPersonDTO->slpName;
}
// Gera as linhas da tabela
$identifierArray = array();
$LFCR = chr(10) . chr(13);
foreach ($contractArray as $contract) {
if (array_key_exists($contract->id, $identifierArray)) {
continue;
}
// contrato repetido, pula para o próximo registro
$clientName = BusinessPartnerDAO::GetClientName($dataConnector->sqlserverConnection, $contract->pn);
$salesPersonName = $salesPersonArray[$contract->vendedor];
$details = "";
$subContractArray = $subContractDAO->RetrieveRecordArray("contrato_id=" . $contract->id);
foreach ($subContractArray as $subContract) {
if (!empty($details)) {
$details = $details . $LFCR;
}
$details = $details . $subContract->siglaTipoContrato;
$itemArray = $contractItemDAO->RetrieveRecordArray("subContrato_id=" . $subContract->id);
foreach ($itemArray as $contractItem) {
$equipment = $equipmentDAO->RetrieveRecord($contractItem->codigoCartaoEquipamento);
$installationDate = empty($equipment->installationDate) ? '' : $equipment->installationDate->format('d/m/Y');
// filtra apenas os items ativos e emprestados
if ($equipment->status == 'A' || $equipment->status == 'L') {
if (!empty($details)) {
$details = $details . $LFCR;
}
$equipmentModel = "";
if (array_key_exists($equipment->model, $modelArray)) {
$equipmentModel = $modelArray[$equipment->model];
}
$details = $details . $equipmentModel . ' Série ' . $equipment->manufacturerSN . ' Data Instalação ' . $installationDate;
}
}
}
if ($searchMethod == 1 || $searchMethod == 2) {
if (!empty($model)) {
$modelMatched = false;
if (strpos($details, $model)) {
$modelMatched = true;
}
if (!$modelMatched) {
continue;
}
}
}
$currentRow++;
$row = array();
$row[0] = str_pad($contract->numero, 5, '0', STR_PAD_LEFT);
$row[1] = $clientName;
$row[2] = $details;
$row[3] = $contract->dataAssinatura;
$row[4] = $contract->dataEncerramento;
$row[5] = $contract->inicioAtendimento;
$row[6] = $contract->fimAtendimento;
$row[7] = $contract->parcelaAtual . '/' . $contract->quantidadeParcelas;
$row[8] = $salesPersonName;
$row[9] = $contractDAO->GetStatusAsText($contract->status);
$row[10] = $contract->global == 0 ? 'N' : 'S';
InsereLinhaPlanilha($currentRow, $startColumn, $row);
$identifierArray[$contract->id] = $contract->numero;
}
}
$retrievedArray = $salesPersonDAO->RetrieveRecordArray();
$salesPersonArray = array();
foreach ($retrievedArray as $salesPersonDTO) {
$salesPersonArray[$salesPersonDTO->slpCode] = $salesPersonDTO->slpName;
}
// Gera as linhas da tabela
$identifierArray = array();
foreach ($contractArray as $contract) {
if (array_key_exists($contract->id, $identifierArray)) {
continue;
}
// contrato repetido, pula para o próximo registro
$numero = str_pad($contract->numero, 5, '0', STR_PAD_LEFT);
$clientName = BusinessPartnerDAO::GetClientName($dataConnector->sqlserverConnection, $contract->pn);
$salesPersonName = $salesPersonArray[$contract->vendedor];
$status = $contractDAO->GetStatusAsText($contract->status);
$parcela = $contract->parcelaAtual . '/' . $contract->quantidadeParcelas;
$global = $contract->global == 0 ? 'N' : 'S';
$details = $clientName . ' Vendedor ' . $salesPersonName;
$subContractArray = $subContractDAO->RetrieveRecordArray("contrato_id=" . $contract->id);
foreach ($subContractArray as $subContract) {
if (!empty($details)) {
$details = $details . '<br/>';
}
$details = $details . $subContract->siglaTipoContrato;
$itemArray = $contractItemDAO->RetrieveRecordArray("subContrato_id=" . $subContract->id);
foreach ($itemArray as $contractItem) {
$equipment = $equipmentDAO->RetrieveRecord($contractItem->codigoCartaoEquipamento);
$installationDate = empty($equipment->installationDate) ? '' : $equipment->installationDate->format('d/m/Y');
// filtra apenas os items ativos e emprestados
if ($equipment->status == 'A' || $equipment->status == 'L') {
<th style="width: 45%;" >Alteração</th>
</tr>
</thead>
<tbody>
<?php
if (sizeof($actionLogArray) == 0) {
echo '<tr><td colspan="3" align="center" >Nenhum registro encontrado!</td></tr>';
}
foreach ($actionLogArray as $actionLog) {
$login = $loginDAO->RetrieveRecord($actionLog->login_id);
$action = '';
if ($actionLog->tipoObjeto == 'contrato') {
$newValue = $actionLog->valor;
$checkBoxCaption = array("0" => "desmarcado", "1" => "marcado");
if ($actionLog->propriedade == 'status') {
$newValue = ContractDAO::GetStatusAsText($newValue);
}
if ($actionLog->propriedade == 'categoria') {
$newValue = ContractDAO::GetCategoryAsText($newValue);
}
if ($actionLog->propriedade == 'vendedor') {
$newValue = SalesPersonDAO::GetSalesPersonName($dataConnector->sqlserverConnection, $newValue);
}
if ($actionLog->propriedade == 'contato') {
$newValue = ContactPersonDAO::GetContactPersonName($dataConnector->sqlserverConnection, $newValue);
}
if ($actionLog->propriedade == 'indiceReajuste') {
$newValue = AdjustmentRateDAO::GetAlias($dataConnector->mysqlConnection, $newValue);
}
if ($actionLog->propriedade == 'global') {
$newValue = $checkBoxCaption[$newValue];
