Export record many to many

Export record many to many

anemoneanemone Posts: 2Questions: 1Answers: 0

i have data json like this :

Array
(
    [0] => Array
        (
            [order] => Array
                (
                    [0] => Array
                        (
                            [nama] => Aqilla
                            [spesifikasi] => 115 x 115
                            [berat] => 220
                            [totalBerat] => 220
                            [harga] => 160,500
                            [totalHarga] => 160,500
                            [qty] => 1
                            [id_item] => 565
                            [status] => 0
                            [id_order] => 237531413940522
                            [Pengirim] => 089514332654/ Wulan Sari
                            [Kurir] => sicepat- REG
                            [ongkir] => 8000
                            [lainlain] => 0
                            [Pelanggan] => Aneng djamilah/ 087822365252
                            [alamatPelanggan] => Kota Bandung,Bojongloa Kaler,jl buana indah 1 no 18 rt 05 rw 12 bandung 40233 kecamatan bojongloa kaler kelurahan kopo
                        )

                )

            [totalharga] => Array
                (
                    [0] => Array
                        (
                            [gram] => 220
                            [totalharga] => 200000
                            [totalhargareal] => 160500
                            [totalpotongan] => 39500
                        )

                )

        )

    [1] => Array
        (
            [order] => Array
                (
                    [0] => Array
                        (
                            [nama] => Nabila Yellowsun
                            [spesifikasi] => 115 x 115
                            [berat] => 150
                            [totalBerat] => 150
                            [harga] => 66,750
                            [totalHarga] => 66,750
                            [qty] => 1
                            [id_item] => 566
                            [status] => 0
                            [id_order] => 939561053757202
                            [Pengirim] => 089514332654/ Wulan Sari
                            [Kurir] => sicepat- REG
                            [ongkir] => 19000
                            [lainlain] => 0
                            [Pelanggan] => Dina Lestari/ 087702722277
                            [alamatPelanggan] => Kota Surabaya,Lakar Santri,THE GREENLAKE CITRALAND CM12/50 LIDAH KULON SURABAYA 60213
                        )

                    [1] => Array
                        (
                            [nama] => Nabila Chocolate
                            [spesifikasi] => 115 x 115
                            [berat] => 150
                            [totalBerat] => 150
                            [harga] => 66,750
                            [totalHarga] => 66,750
                            [qty] => 1
                            [id_item] => 567
                            [status] => 0
                            [id_order] => 939561053757202
                            [Pengirim] => 089514332654/ Wulan Sari
                            [Kurir] => sicepat- REG
                            [ongkir] => 19000
                            [lainlain] => 0
                            [Pelanggan] => Dina Lestari/ 087702722277
                            [alamatPelanggan] => Kota Surabaya,Lakar Santri,THE GREENLAKE CITRALAND CM12/50 LIDAH KULON SURABAYA 60213
                        )

                    [2] => Array
                        (
                            [nama] => Nabila Maroon
                            [spesifikasi] => 115 x 115
                            [berat] => 150
                            [totalBerat] => 150
                            [harga] => 66,750
                            [totalHarga] => 66,750
                            [qty] => 1
                            [id_item] => 568
                            [status] => 0
                            [id_order] => 939561053757202
                            [Pengirim] => 089514332654/ Wulan Sari
                            [Kurir] => sicepat- REG
                            [ongkir] => 19000
                            [lainlain] => 0
                            [Pelanggan] => Dina Lestari/ 087702722277
                            [alamatPelanggan] => Kota Surabaya,Lakar Santri,THE GREENLAKE CITRALAND CM12/50 LIDAH KULON SURABAYA 60213
                        )

                    [3] => Array
                        (
                            [nama] => Nabila Pinkrose
                            [spesifikasi] => 115 x 115
                            [berat] => 150
                            [totalBerat] => 150
                            [harga] => 66,750
                            [totalHarga] => 66,750
                            [qty] => 1
                            [id_item] => 569
                            [status] => 0
                            [id_order] => 939561053757202
                            [Pengirim] => 089514332654/ Wulan Sari
                            [Kurir] => sicepat- REG
                            [ongkir] => 19000
                            [lainlain] => 0
                            [Pelanggan] => Dina Lestari/ 087702722277
                            [alamatPelanggan] => Kota Surabaya,Lakar Santri,THE GREENLAKE CITRALAND CM12/50 LIDAH KULON SURABAYA 60213
                        )

                )

            [totalharga] => Array
                (
                    [0] => Array
                        (
                            [gram] => 600
                            [totalharga] => 356000
                            [totalhargareal] => 267000
                            [totalpotongan] => 89000
                        )

                )

        )

)

and i want to using datatables to export all

example like this:

in this case im using fpdf to print data.. but i want to using datatables to export..

thanks.

This question has an accepted answers - jump to answer

Answers

  • rf1234rf1234 Posts: 2,808Questions: 85Answers: 406
    Answer ✓

    That will be a lot of work. If you really want to do this with Data Tables you should love XML and the like. I recommend you do this server side using PHP Spreadsheet for example.
    But here is a thread that highlights the things you can do with Data Tables. You'll find more by just searching the forum.
    https://datatables.net/forums/discussion/comment/167674

  • anemoneanemone Posts: 2Questions: 1Answers: 0

    thanks..

This discussion has been closed.