rojak | Project Rojak , Yuk gabung diskusi di Slack nya Rojak | REST library

 'XXXX',
    'environment' => Environment::PRODUCTION,
]);

SquareConnect\Configuration::getDefaultConfiguration()->setAccessToken('XXXX');

$location_ids = ['XXXX'];
$created_at = new \Square\Models\TimeRange();
$created_at->setStartAt('2021-04-14T00:00:00+08:00');
$created_at->setEndAt('2021-04-14T23:59:59+08:00'); 

$date_time_filter = new \Square\Models\SearchOrdersDateTimeFilter();
$date_time_filter->setCreatedAt($created_at);

$filter = new \Square\Models\SearchOrdersFilter();
$filter->setDateTimeFilter($date_time_filter);

$sort = new \Square\Models\SearchOrdersSort('CREATED_AT');
$sort->setSortOrder('DESC');

$query = new \Square\Models\SearchOrdersQuery();
$query->setFilter($filter);
$query->setSort($sort);

$body = new \Square\Models\SearchOrdersRequest();
$body->setLocationIds($location_ids);
$body->setQuery($query);
$body->setLimit(500);
$body->setReturnEntries(false);

$api_response = $client->getOrdersApi()->searchOrders($body);

if ($api_response->isSuccess()) {
    $result = $api_response->getResult();
    $orders = $result->getOrders();
    
    //INSERT INTO DB
       //include db connect class
       require_once __DIR__ . '/db_connect.php';
       // connecting to db
       $myConnection= new DB_CONNECT();
       $myConnection->connect();
       
       $sql="INSERT INTO sale_item(order_id, item_name, item_quantity) VALUES";
    
    foreach($orders as $x => $val) {
    $lineItems = $result->getOrders()[$x]->getLineItems();
    $orderid = $result->getOrders()[$x]->getId();
    
    foreach($lineItems as $q => $val2){
        //$lineItemsID = $lineItems[$q]->getUid();
        $itemName = $lineItems[$q]->getName();
        $itemQty = $lineItems[$q]->getQuantity();
        
        $sql .="('".$orderid."', '".$itemName."', '".$itemQty."'),";
    }   
    }
    
    $sql= rtrim( $sql, ',');
    $result =mysqli_query($myConnection->myconn, "$sql");

    // check if row inserted or not
    if ($result) {
     // successfully inserted into database
      echo "Product successfully created.";       
      }  
    else {
      // failed to insert row
      echo "Oops! An error occurred.";
    }
    
} else {
    $errors = $api_response->getErrors();
}



?>