Пример #1
0
    $FileString = "";
    for ($index = 0; $index < mysqli_num_rows($OrderQuery['Query']); $index++) {
        $Data = mysqli_fetch_assoc($OrderQuery['Query']);
        $FileString = $FileString . $Data['OrderID'] . ',';
        // if ( ($index + 1) != mysqli_num_rows($OrderQuery['Query']) ) {
        //   $FileString = $FileString . ',';
        // }
    }
    echo $FileString;
} elseif ($_GET['action'] == "print_nametag") {
    header("Content-type: text/csv");
    header("Content-Disposition: attachment; filename=Nametags.csv");
    header("Pragma: no-cache");
    header("Expires: 0");
    $FileString = "section1,section2,section3,section4,section5\r\n";
    $Data = GetOrderInfo($DBConn);
    if ($Data == false) {
        return false;
    }
    foreach ($Data as $Key => $Value) {
        if ($Value == NULL) {
            $Data[$Key] = "";
        }
    }
    $Days = $Data['Days'];
    $FileString = $FileString . '"' . $Data['LName'] . ", " . $Data['FName'] . "\",\"" . $Data['Address'] . "\",\"" . $Data['City'] . ", " . $Data['State'] . " " . $Data['Zip'] . "\",\"" . $Data['BoothName'] . "\",\"" . $_GET['OrderID'] . "\"\r\n";
    $AttendeeQuery = MySQLQuery($DBConn, 'select FName, LName, SpouseName, City, State, AgeGroup from attendees where OrderID="' . $_GET['OrderID'] . '";');
    if ($AttendeeQuery['Result'] == false) {
        echo $AttendeeQuery['Query'];
        return false;
    }
Пример #2
0

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
							 ->setLastModifiedBy("Maarten Balliauw")
							 ->setTitle("Office 2007 XLSX Test Document")
							 ->setSubject("Office 2007 XLSX Test Document")
							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
							 ->setKeywords("office 2007 openxml php")
							 ->setCategory("Test result file");

							 
$orderarr = GetOrderInfo($id);

$currrow = 1;

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);

$currrow = 0;

$currrow++;
Пример #3
0
		function MetodListOrderStr($field_key,$field_value,$suffix,$line)
		{
//			$a = Array('type'=>'td', 'value'=>$value, 'tdname'=>$tdname, 'sorturl'=>$sorturl, 'ascdesc'=>$ascdesc);
			
			$tdname = '';
			if(isset($field_value['tdname'])) $tdname = $field_value['tdname'];
			
			$sorturl = '';

			$value = '';
			//$value .= htmlspecialchars($this->GetFieldValue($line,$field_key.$suffix,$field_value['fieldtype']));
			$orderarr = GetOrderInfo($line['id'],$line);
			
			
			$value.= '<a href="ordertoxls.php?id='.$line['id'].'" title="Импорт в Excel">'.$this->adm->DrawIcon('xls',' width="32" ').'</a>';

			$value.= '
			<br>
			
			';

    			if($this->GetAdmConfig($this->moduleact,'hideordertable'))
			{
			    $value.= '
				<a href="#" onclick=" document.getElementById(\'_ordertable_id_'.$line['id'].'\').style.display = \'block\'; return false; ">Показать таблицу заказа</a>
				<div style="display:none;" id="_ordertable_id_'.$line['id'].'">';
			}
			
			$value.= '
			<a href="#" onclick=" document.location.href = \'workadmin.php?act=changeadmconfig&modulename='.$this->moduleact.'&var=hideordertable&value=0\'; return false;">Всегда показывать таблицу заказа</a><br>
			<a href="#" onclick=" document.location.href = \'workadmin.php?act=changeadmconfig&modulename='.$this->moduleact.'&var=hideordertable&value=1\'; return false;">Всегда скрывать таблицу заказа</a><br>
			
			<style>
			    .admin_order_table .admin_order_table th, .admin_order_table td { border:1px solid #c7c7c7; border-collapse:collapse; padding:0px; }
			</style>
			';
			
			$value.='<table class="admin_order_table">';
			$value.='<tr><td>Фото</td><td>(ID)</td><td>АРТ</td><td>Товар</td><td>Цена</td><td>К-во</td><td>Сумма</td></tr>';
			foreach($orderarr['products'] AS $key=>$oneproduct)
			{
			    if(isset($oneproduct['isdeleted']))
			    {
				$oneproduct['id'] = ' ';
				$oneproduct['artikul'] = ' ';
				$oneproduct['img'][0] = '';
				$oneproduct['url'] = '';
				$oneproduct['title'] = 'Товар удален из базы';				
				$oneproduct['id'] = '';
			    }
			    else
			    {
				$addstr = GetAddStr(100,75,$oneproduct['img'][0]);
			    }
			    
			    $resprice = $oneproduct['_order_value'] * $oneproduct['_order_price'];
			    
			    $value.='
			    <tr>
				<td>'.($oneproduct['img'][0]=='' ? ' ' : '<a target="_blank" href="'.$oneproduct['url'].'"><img src="'.$oneproduct['img'][0].'" '.$addstr.'></a>').'</td>
				<td>'.$oneproduct['id'].'</td>
				<td>'.htmlspecialchars($oneproduct['artikul']).'</td>
				<td><a '.($oneproduct['url']=='' ? '' : ' href="'.$oneproduct['url'].'"').'>'.$oneproduct['title'].'</a></td>
				<td>'.$oneproduct['_order_price'].'</td>
				<td>'.$oneproduct['_order_value'].'</td>
				<td>'.PriceToStr($resprice).'</td>
			    </tr>
			    ';
			}
			$value.='</table>';
    			if($this->GetAdmConfig($this->moduleact,'hideordertable')) $value.= '</div>';
			
			$a = Array('type'=>'td', 'value'=>$value, 'tdname'=>$tdname, 'sorturl'=>$sorturl, );
			return Array($a);
		    
		}