def index():
    try:
        dosen = Dosen.query.all()
        data = formatarray(dosen)
        return response.success(data, "succes")
    except Exception as e:
        print(e)
Пример #2
0
def createBook():
    req_data = request.get_json()
    nomor_buku = req_data.get('nomor_buku')
    judul = req_data.get('judul')
    pengarang = req_data.get('pengarang')
    tahun_terbit = req_data.get('tahun_terbit')
    penerbit = req_data.get('penerbit')
    create_at = datetime.utcnow()
    update_at = datetime.utcnow()

    buku = Buku.query.filter_by(nomor_buku=nomor_buku).first()

    if buku == None:
        book = Buku(nomor_buku=nomor_buku,
                    judul=judul,
                    pengarang=pengarang,
                    tahun_terbit=tahun_terbit,
                    penerbit=penerbit,
                    created_at=create_at,
                    update_at=update_at)

        try:
            db.session.add(book)
            db.session.commit()
            return response.success('', 'Berhasil Mebambahkan Buku')
        except Exception as e:
            return response.badRequest('', 'Gagal menambahkan Buku !!!')
    else:
        return response.badRequest(
            '', f'Buku dengan nomor #{nomor_buku} sudah ada')
Пример #3
0
def login():
    try:
        email = request.form.get('email')
        password = request.form.get('password')

        user = User.query.filter_by(email=email).first()

        if not user:
            return response.badRequest([], 'Email Tidak Terdaftar')

        if not user.checkPassword(password):
            return response.badRequest([], 'Kombinasi Password Salah !')

        data = singleObject(user)
        expires = datetime.timedelta(days=1)
        expires_refresh = datetime.timedelta(days=3)
        access_token = create_access_token(data,
                                           fresh=True,
                                           expires_delta=expires)
        refresh_token = create_refresh_token(data,
                                             expires_delta=expires_refresh)

        return response.success(
            {
                "data": data,
                "access_token": access_token,
                "refresh_token": refresh_token,
            }, "Success")

    except Exception as e:
        print(e)
Пример #4
0
def index():
    '''Menampilkan daftar buku yang terdapar pada table buku '''
    try:
        books = Buku.query.all()
        data_buku = fromatArrayBooks(books)
        return response.success(data_buku, 'Success')
    except Exception as e:
        return response.badRequest('', 'Gagal Menampilkan')
Пример #5
0
def tampilUser():
    '''Tampil User ini digunakan untuk Menampilkan keseluruhan user yang terdaftar pada table user '''
    try:
        users = User.query.all()
        data = formatArray(users)
        return response.success(data, 'Success')
    except Exception as e:
        # return response.badRequest('', 'Gagal Menampilkan')
        print(e)
Пример #6
0
def tampilMahasiswa():
    try:
        mhs = Mahasiswa.query.all()
        if data is None:
            return response.badRequest("", "Tidak ada data mahasiswa")

        data = [serializeMahasiswa(data) for data in mhs]
        return response.success(data, "Success")
    except Exception as e:
        return response.badRequest("", "Tidak dapat menampilkan")
Пример #7
0
def faceCheck():
    user_id = request.form.get('user_id')
    file = request.files.get('file')

    faceEncoding = FaceEncodings(file)
    face_encodings = FaceDatas(user_id)
    distances = FaceDistance(face_encodings, faceEncoding)

    FaceAdd(user_id, faceEncoding, distances['current'])

    return success(distances)
Пример #8
0
def hapusBook(id):
    book = Buku.query.filter_by(nomor_buku=id).first()

    if book == None:
        return response.badRequest('', f'Buku dengan nomor #{id} tidak ada')
    try:
        db.session.delete(book)
        db.session.commit()
        return response.success('',
                                f'Buku dengan nomor #{id} berhasil di Hapus')
    except Exception as e:
        return response.badRequest('', 'Tidak dapat menghapus')
Пример #9
0
def department_get_department_list(department_id, get_employee_info,
                                   sub_department_count, sub_employee_count,
                                   all_sub_department_count,
                                   all_sub_employee_count):
    '''
    [
        {"name": "department_id", "required": 1, "check": "int", "description": "父部门ID"},
        {"name": "get_employee_info", "required": 0, "check": "bool", "description": "是否包含当前部门员工信息"},
        {"name": "sub_department_count", "required": 0, "check": "bool", "description": "部门信息包含一级子部门数"},
        {"name": "sub_employee_count", "required": 0, "check": "bool", "description": "部门信息包含一级子员工数"},
        {"name": "all_sub_department_count", "required": 0, "check": "bool", "description": "部门信息包含所有子部门数"},
        {"name": "all_sub_employee_count", "required": 0, "check": "bool", "description": "部门信息包含所有子员工数"}
    ]
    '''
    if department_id == -1:
        department = Department.get_root_department()
    else:
        department = Department.query.filter(
            Department.enterprise_id == current_enterprise.object_id,
            Department.object_id == department_id).first()
        if not department:
            return custom(-1, "参数错误")
    departments = Department.query.filter(
        Department.enterprise_id == current_enterprise.object_id,
        Department.parent_id == department.object_id).all()
    department_info = []
    for department in departments:
        res = department.to_json()
        if sub_department_count:
            res["sub_department_count"] = department.get_sub_department_query(
            ).count()
        if sub_employee_count:
            res["employee_count"] = department.get_current_employees_query(
            ).count()
        if all_sub_department_count:
            res["all_sub_department_count"] = department.get_all_sub_department_query(
            ).count()
        if all_sub_employee_count:
            res["all_employee_count"] = department.get_all_employees_query(
            ).count()
        department_info.append(res)
    employee_info = []
    if get_employee_info:
        depmems = DepartmentMem.query.options(
            joinedload(DepartmentMem.employee).joinedload(
                Employee.account)).filter(
                    DepartmentMem.department_id == department.object_id).all()
        for depmem in depmems:
            employee_info.append(depmem.to_json())
    return success(data={
        "department_info": department_info,
        "employee_info": employee_info
    })
Пример #10
0
def detailMahasiswabynpm(npm):
    try:
        dataMhs = db.session.query(Mahasiswa.npm, Mahasiswa.nama, Mahasiswa.no_hp, Mahasiswa.angkatan, Mahasiswa.alamat, Prodi.nama_prodi, Fakultas.nama_fakultas).select_from(Mahasiswa).join(
            Prodi).join(Fakultas).filter(Mahasiswa.npm == npm and Mahasiswa.prodi == Prodi.id_prodi and Prodi.id_fakultas == Fakultas.id_fakultas).first()

        if dataMhs is None:
            return response.badRequest('', 'Data tidak ditemukan')

        data = serializeDetailMahasiswa(dataMhs)
        return response.success(data, 'Success')
    except Exception as e:
        return response.badRequest('', 'Gagal menampilkan')
Пример #11
0
def faceUpdate():
    user_id = request.form.get('user_id')
    file = request.files.get('file')

    if file:
        data = FaceEncodings(file)
    else:
        data = None

    UserUpdate(user_id, data)

    return success()
Пример #12
0
def deleteMahasiswa(npm):
    mhs = Mahasiswa.query.filter_by(npm=npm).first()

    if mhs is None:
        return response.badRequest('', f'Mahasiswa dengan NPM #{npm} tidak ada')

    try:
        db.session.delete(mhs)
        db.session.commit()
        return response.success('', 'Success')
    except Exception as e:
        return response.badRequest('', 'Gagal Menambahkan')
Пример #13
0
def detailMahasiwa():
    try:
        dataMhs = db.session.query(Mahasiswa.npm, Mahasiswa.nama, Mahasiswa.no_hp, Mahasiswa.angkatan, Mahasiswa.alamat, Prodi.nama_prodi, Fakultas.nama_fakultas).select_from(Mahasiswa).join(
            Prodi).join(Fakultas).filter(Mahasiswa.prodi == Prodi.id_prodi and Prodi.id_fakultas == Fakultas.id_fakultas).all()

        if dataMhs is None:
            return response.badRequest('', 'Data tidak ada')

        data = [serializeDetailMahasiswa(data) for data in dataMhs]
        # data = formatarray(dataMhs)
        # data = serializeDetailMahasiswa(dataMhs)
        return response.success(data, 'Success')
    except Exception as e:
        print(e)
Пример #14
0
def buatAdmin():
    try:
        name = request.form.get('name')
        email = request.form.get('email')
        password = request.form.get('password')
        level = 1

        users = User(name=name, email=email, level=level)
        users.setPassword(password)
        db.session.add(users)
        db.session.commit()

        return response.success('', 'Sukses menambahkan data Admin')
    except Exception as e:
        print(e)
Пример #15
0
def detailBook(id):
    book = Buku.query.filter_by(nomor_buku=id).first()

    if book == None:
        return response.badRequest('', f'Buku dengan nomor #{id} tidak ada')

    data_buku = {
        'nomor_buku': book.nomor_buku,
        'pengarang': book.pengarang,
        'tahun_terbit': book.tahun_terbit,
        'penerbit': book.penerbit,
        'created_at': book.created_at,
        'update_at': book.update_at
    }

    return response.success(data_buku, f'Data Buku')
def detail(id):
    try:
        dosen = Dosen.query.filter_by(id=id).first()
        mahasiswa = Mahasiswa.query.filter((Mahasiswa.dosen_satu == id)
                                           | (Mahasiswa.dosen_dua == id))

        if not dosen:
            return response.badrequest([], 'Tidak ada data dosen')

        datamahasiswa = formatMahasiswa(mahasiswa)

        data = singleDetailMahasiswa(dosen, datamahasiswa)

        return response.success(data, "success")

    except Exception as e:
        print(e)
Пример #17
0
def tampilDetail():
    '''Fungsi ini digunakan untuk menampilkan data pada table User dengan menggunakan fungsi
    Join untuk mendapatkan nilai yang lebih Detail '''
    users = db.session.query(User.id_user, User.npm, User.nama, User.email,
                             User.password, User.level, Level.id_level,
                             Level.keterangan).join(Level).filter(
                                 User.level == Level.id_level).all()
    # users = db.session.query(
    #     User.id_user, User.npm, User.nama, User.email, User.password,
    #     Level.keterangan, Prodi.nama_prodi, Fakultas.nama_fakultas).join(
    #         Level).join(Mahasiswa).join(Prodi).join(Fakultas).filter(
    #             User.level == Level.id_level and User.npm == Mahasiswa.npm
    #             and Mahasiswa.prodi == Prodi.id_prodi
    #             and Prodi.id_fakultas == Fakultas.id_fakultas).order_by(
    #                 User.id_user).all()

    data = formatArrrayDetail(users)
    return response.success(data, 'Succes')
Пример #18
0
def editMahasiswa(npm):
    mhs = Mahasiswa.query.filter_by(npm=npm).first()

    if mhs is None:
        return response.badRequest('', f'Mahasiswa dengan NPM #{npm} tidak ada')

    req_data = request.get_json()

    mhs.npm = req_data.get('npm')
    mhs.nama = req_data.get('nama')
    mhs.no_hp = req_data.get('no_hp')
    mhs.angakatan = req_data.get('angkatan')
    mhs.alamat = req_data.get('alamat')
    mhs.prodi = req_data.get('prodi')

    try:
        db.session.commit()
        return response.success('', 'Success')
    except Exception as e:
        return response.badRequest('', 'Gagal Update Mahasiswa')
Пример #19
0
def CreateUser():
    '''Untuk Membuat User Admin dan Mahasiswa'''
    try:
        # req_data = request.get_json()
        npm = request.form.get('npm')
        nama = request.form.get('nama')
        email = request.form.get('email')
        password = request.form.get('password')
        level = request.form.get('level')

        users = User(npm=npm, nama=nama, email=email, level=level)
        users.setPassword(password)

        db.session.add(users)
        db.session.commit()

        return response.success('', "Berhasil Menambahkan User")

    except Exception as e:
        print(e)
Пример #20
0
def updateBook(id):
    book = Buku.query.filter_by(nomor_buku=id).first()

    if book == None:
        return response.badRequest('', f'Buku dengan nomor #{id} tidak ada')

    req_data = request.get_json()

    try:
        book.judul = req_data.get('judul')
        book.pengarang = req_data.get('pengarang')
        book.tahun_terbit = req_data.get('tahun_terbit')
        book.penerbit = req_data.get('penerbit')
        book.update_at = datetime.utcnow()

        db.session.commit()
        return response.success(
            '', f'Buku dengan nomor #{id} berhasil di berbaharui !')
    except Exception as e:
        return response.badRequest('', 'Gagal memperbaharui Buku')
Пример #21
0
def saveMahasiswa():
    data_req = request.get_json()
    npm = data_req.get('npm')
    nama = data_req.get('nama')
    no_hp = data_req.get('no_hp')
    angkatan = data_req.get('angkatan')
    alamat = data_req.get('alamat')
    prodi = data_req.get('prodi')

    mahasiswa = Mahasiswa.query.filter_by(npm=npm).first()

    if mahasiswa == None:
        data = Mahasiswa(npm=npm, nama=nama, no_hp=no_hp,
                         angkatan=angkatan, alamat=alamat, prodi=prodi)

        try:
            db.session.add(data)
            db.session.commit()
            return response.success('', 'Data Berhasil di tambahkan')
        except Exception as e:
            return response.badRequest('', 'Data Gagal di tambahkan')
    else:
        return response.badRequest('', f'Mahasiswa dengan npm #{npm} sudah ada')
Пример #22
0
def get(request, category):
  return success({'logs': get_logs(category)})
Пример #23
0
def put(request, category):
  lines = request.get_all('line')
  if len(lines):
    log(category, lines)
  return success()
Пример #24
0
def empty():
    UserEmpty(request.args.get('user_id'))
    return success()
Пример #25
0
def delete():
    UserDeleteFaces(request.args.get('user_id'))
    return success()
Пример #26
0
def create():
    info = UserCreate(request.form.get('user_id'))
    return success({
        'user_id': info.id,
    })
Пример #27
0
def index():
    return success({
        'time': datetime.now(),
    })
Пример #28
0
def get(request, category):
    return success({'logs': get_logs(category)})
Пример #29
0
def put(request, category):
    lines = request.get_all('line')
    if len(lines):
        log(category, lines)
    return success()
Пример #30
0
def department_get_department_tree():
    departments = Department.get_department_tree(current_enterprise.object_id)
    return success(data=[dep.to_json() for dep in departments])