function get_crud_all_quot() {
            $query=$this->db->query("select * from txnquothdr");
            return $query->result();

        }


        function get_all_detailquo() {
            $query=$this->db->query("SELECT
                            `txnquothdr`.*,
                            `mstcust`.`MstCustIDName`
                        FROM
                            `txnquothdr`
                            INNER JOIN `mstcust` ON `txnquothdr`.`MstCustID` = `mstcust`.`MstCustID`
            ");
            return $query->result();

        }
        --------------------------------------------------ini yang buat view---------------------
            function get_all_detailquos($id) {
            $query=$this->db->query("SELECT
                                    `txnquothdr`.*,
                                    `mstcust`.`MstCustIDName`,
                                    `mstcust`.`MstCustIDAddress1`,
                                    `mstcuste`.`MstCustIDPIC1`,
                                    `mstcust`.`MstCustIDPIC2`,
                                    `mstcust`.`MstCustIDNoTlp`,
                                    `mstcust`.`MstCustIDPICEmail1`
                                    FROM
                                    `txnquothdr`
                                        INNER JOIN `mstcust` ON `txnquothdr`.`MstCustID` = `mstcust`.`MstCustID` = '$id' ;
                    ");
                    return $query->result();

                    }