<script>
        function opennav() {
            $("#mysidenav").css("width", "20em");
            $(".main").fadeTo("slow", 0.5);
            if($("#session").val() == 0) {
                $("#adjustdebt, #asset, #warrant, #courtorder, #prison").remove();
            } else if($("#session").val() == 1) {
                $("#warrant, #courtorder, #prison").remove();
            } else {
                $(".navbtns").show();
            }
        }
        $(".main, .closebtn, #crimdues").click(function closenav() {
            $("#mysidenav").css("width", "0em");
            $(".main").fadeTo("slow", 1.0);
        });
        $(document).ready(()=> {
            $("#ncicform").submit((event)=> {
                if($("#charname").val() != "") {
                    $.get("data.php?name=" + encodeURIComponent($("#charname").val()), (data)=> {
                        //console.log(data);
                        $("#generalinfotbl").DataTable({
                            destroy: true,
                            searching: false,
                            paging: false,
                            ordering: false,
                            data: data['generalInfo'],
                            columns: [
                                {'data': 'username'},
                                {'data': 'charid'},
                                {
                                    'data': null,
                                    render: (data)=> {
                                        let name = data.firstgiven + " " + data.lastgiven;
                                        return name;
                                    }
                                },
                                {'data': 'tickets'},
                                {'data': 'arrests'},
                                {
                                    'data': null,
                                    render: (data)=> {
                                        let debt = "$" + data.owesstate;
                                        return debt;
                                    }
                                },
                                {
                                    'data': null,
                                    render: (data)=> {
                                        let warrants = '<div class="text-danger">'+data.wantsandwarrants+'</div>';
                                        return warrants;
                                    }
                                },
                                {
                                    'data': null,
                                    render: (data)=> {
                                        let courtorders = '<div class="text-danger">'+data.courtorders+'</div>';
                                        return courtorders;
                                    }
                                }
                            ]
                        });
                        $("#ncictbl").DataTable({
                            destroy: true,
                            data: data['ncic'],
                            columns: [
                                {'data': 'cpicid'},
                                {
                                    'data': null,
                                    render: (data)=> {
                                        if(data.type == 1) {
                                            let type = 'Ticket';
                                            return type;
                                        } else {
                                            let type = 'Arrest';
                                            return type;
                                        }
                                    }
                                },
                                {
                                    'data': null,
                                    render: (data)=> {
                                        if(data.type == 1) {
                                            let amount = "$" + data.amount;
                                            return amount;
                                        } else {
                                            let amount = data.amount + " " + "months";
                                            return amount;
                                        }
                                    }
                                },
                                {'data': 'reason'},
                                {'data': 'datetime'}
                            ]
                        });
                        $("#arrestticketcount h4").remove();
                        $("#arrestticketcount").append('<h4>Tickets: '+data['generalInfo'][0].tickets+' | Arrests: '+data['generalInfo'][0].arrests+'</h4>');
                    });
                }
                event.preventDefault();
            });
            $("#home").click(()=> {
                window.location.href = 'index.php';
            });
            $("#adjustdebt").click(()=> {
                window.location.href = 'adjustdebt.php';
            });
            $("#asset").click(()=> {
                window.location.href = 'asset.php';
            });
            $("#warrant").click(()=> {
                window.location.href = 'warrant.php';
            });
            $("#courtorder").click(()=> {
                window.location.href = 'courtorder.php';
            });
            $("#prison").click(()=> {
                window.location.href = 'prison.php';
            });
        });
    </script>