fabiz_php/sendRequestItem.php at master · devaliakbar/fabiz_php · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
include 'common/common.php';

$userName = $_POST['my_username'];
$password = null;
$version = $_POST['app_version'];
if ( $version != $app_version ) {
    $response['status'] = 'VERSION';
} else {
    $userSignature = $_POST['mysign'];
    $resultOfAuth = checkUserNamePassword( $conn, $userName, $password, $userSignature );
    if ( $resultOfAuth != null ) {
        if ( $forcePush_data ) {
            $response['status'] = 'PUSH';
        } else {
            if ( $update_data ) {
                $response['status'] = 'UPDATE';
            } else {
                mysqli_autocommit( $conn, false );
                $commitTransaction = true;
                $tableName = RequestItem::$TABLE_NAME;
                $columnName = RequestItem::$COLUMN_NAME;
                $columnQty = RequestItem::$COLUMN_QTY;

                for ( $i = 0; $i < $_POST['row_size']; $i++ ) {
                    $name = $_POST[$columnName . $i];
                    $qty = $_POST[$columnQty . $i];
                    $insertRequestItemQuery = "INSERT INTO $tableName($columnName, $columnQty) VALUES ('$name','$qty')";
                    if ( !mysqli_query( $conn, $insertRequestItemQuery ) ) {
                        $commitTransaction = false;
                    }
                }
                if ( $commitTransaction ) {
                    if ( mysqli_query( $conn, 'DELETE FROM ' . AppSync::$TABLE_NAME .
                    ' WHERE ' . AppSync::$COLUMN_TABLE_NAME . " = '" . RequestItem::$TABLE_NAME . "'" ) ) {
                        $timestamps = time();
                        $insertSyncLogQuery = 'INSERT INTO ' . AppSync::$TABLE_NAME . "
                        (" . AppSync::$COLUMN_OP_CODE . " ,
                        " . AppSync::$COLUMN_TIMESTAMP . " ,
                        " . AppSync::$COLUMN_ROW_ID . " ,
                          " . AppSync::$COLUMN_TABLE_NAME . " ,
                          " . AppSync::$COLUMN_OPERATION . " )
                          VALUES
                        ('REQUEST_ITEM','1','1','1','1')";
                        if ( mysqli_query( $conn, $insertSyncLogQuery ) ) {
                            mysqli_commit( $conn );
                            $response['success'] = true;
                        } else {
                            mysqli_rollback( $conn );
                        }
                    } else {
                        mysqli_rollback( $conn );
                    }

                } else {
                    mysqli_rollback( $conn );
                }
            }
        }

    } else {
        $response['status'] = 'USER';
    }
}
echo json_encode( $response );
?>