PHP Dosya Yöneticisi

<?php

$ilktarih = $_GET["ilktarih"] . " 00:00:00";
$sontarih = $_GET["sontarih"] . " 00:00:00";
$kategori = $_GET["kategori"];

// Filtreler
require_once("../../../init.php");
require_once("PHPExcel.php");

// Veritabanı Bağlantısı
try {
    $conn = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8;", DB_USERNAME, DB_PASSWORD);
} catch (PDOException $e) {
    die($e->getMessage());
}

// Fonksiyon
function countRow($data)
{
    global $conn;
    $where = "";
    if ($data["where"]):
        $where = "WHERE ";
        foreach ($data["where"] as $key => $value) {
            $where .= " $key=:$key && ";
            $execute[$key] = $value;
        }
        $where = substr($where, 0, -3);
    else:
        $execute[] = "";
    endif;
    $row = $conn->prepare("SELECT * FROM {$data['table']} $where ");
    $row->execute($execute);
    $validate = $row->rowCount();
    return $validate;
}

// Siparişler Tablosu
$siparisler = $conn->prepare("SELECT * FROM orders WHERE date BETWEEN '" . $ilktarih . "' and '" . $sontarih . "'");
$siparisler->execute(array());
$siparisler = $siparisler->fetchAll(PDO::FETCH_ASSOC);

// Nesne
$Excel = new PHPExcel();

// Başlık
$Excel->getActiveSheet()->setTitle("Siparişler");

// Tablo Stilleri
$Excel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("B")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("C")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("D")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("E")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("F")->setAutoSize(true);
$Excel->getActiveSheet()->getColumnDimension("G")->setAutoSize(true);
$Excel->getActiveSheet()->getRowDimension("1")->setRowHeight(27);

// Arka Plan Rengi
$Excel->getActiveSheet()->getStyle("A1:G1")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB("DC123C");

// Çerçeve
$borderstyle = array(
    "borders" => array(
        "allborders" => array(
            "style" => PHPExcel_Style_Border::BORDER_THIN
        )
    )
);
$Excel->getActiveSheet()->getStyle("A1:G1")->applyFromArray($borderstyle);

// Kalın Yazı
$Excel->getActiveSheet()->getStyle("A1:G1")->getFont()->setBold(true);

// Başlık Sütunları
$Excel->getActiveSheet()->setCellValue("A1", "Sipariş No");
$Excel->getActiveSheet()->setCellValue("B1", "Ad Soyad");
$Excel->getActiveSheet()->setCellValue("C1", "Ürün Sayısı");
$Excel->getActiveSheet()->setCellValue("D1", "Toplam");
$Excel->getActiveSheet()->setCellValue("E1", "Ödeme Tipi");
$Excel->getActiveSheet()->setCellValue("F1", "Durum");
$Excel->getActiveSheet()->setCellValue("G1", "Tarih");

// Başlangıç Satırı
$i = 2;

// Veri Dökümü
$categories = $db->table('categories')->where('c_id', '=', 0)->where('status', '=', '1')->order('title', 'asc')->get();

foreach ($siparisler as $row) {
    $product_order = $db->table("order_products")->where('o_id','=',$row['id'])->get();
    $product_order = $product_order['data'][0];
    $product_cat = $db->table('products')->where('id','=',$product_order['product_id'])->get();
    $product_cat = $product_cat['data'][0];
    if ($_GET['kategori'] != -1) {
        $e = 0;
        foreach ($categories['data'] as $category) {
            if ($category['id'] == $_GET['kategori']) {
                if (strstr($product_cat['c_id'], '[' . $category['id'] . ']')) {
                    $e = 1;
                    break;
                }
                $sub_categories = $db->table('categories')->where('c_id', '=', $category['id'])->where('status', '=', '1')->order('title', 'asc')->get();
                foreach ($sub_categories['data'] as $sub_category) {
                    if (strstr($product_cat['c_id'], '[' . $sub_category['id'] . ']')) {
                        $e = 1;
                        break;
                    }
                }
            }
        }
    } else {
        $e = 1;
    }
    if ($e) {
        $Excel->getActiveSheet()->getStyle("A$i:G$i")->applyFromArray($borderstyle);
        $Excel->getActiveSheet()->setCellValue("A" . $i, $row["id"]);
        $Excel->getActiveSheet()->setCellValue("B" . $i, $row["cargo_name"] . " " . $row["cargo_lastname"]);
        $Excel->getActiveSheet()->setCellValue("C" . $i, countRow(["table" => "order_products", "where" => ["o_id" => $row["id"]]]));
        $Excel->getActiveSheet()->setCellValue("D" . $i, $row["total"] . " TL");
        $Excel->getActiveSheet()->setCellValue("E" . $i, $row["payment_type"]);
        $Excel->getActiveSheet()->setCellValue("F" . $i, strip_tags(m_order_status($row["status"])));
        $Excel->getActiveSheet()->setCellValue("G" . $i, $row["date"]);

// Sonraki Satır
        $i++;
    }
}

// Kaydetme İşlemi
$Kaydet = PHPExcel_IOFactory::createWriter($Excel, 'Excel2007');
$Kaydet->save("Siparisler.xlsx");
    
    echo "<center><h2>Siparişler tablosunu <a href='https://sihirlihali.com/includes/modules/PHPExcel/Siparisler.xlsx'>indir</a></h2></center>";

İptal

📁 PHP Dosya Yöneticisi

📝 excel.php

📝 excel.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)