chamilo / chamilo-lms

     * @param int $newStatus The new status

     * @return boolean

     */

    private function updateServiceSaleStatus($serviceSaleId, $newStatus = self::SERVICE_STATUS_PENDING)

    {

        $serviceSaleTable = Database::get_main_table(self::TABLE_SERVICES_NODE);

        return Database::update(

            $serviceSaleTable,

            ['status' => intval($newStatus)],

            ['id = ?' => intval($serviceSaleId)]

        );

    }

    /**

     * Complete sale process. Update sale status to completed

     * @param int $productType The type of product

     * @return int The number of affected rows. Otherwise return false

     */

    public function updateItem(array $itemData, $productId, $productType)

    {

        $itemTable = Database::get_main_table(BuyCoursesPlugin::TABLE_ITEM);

        return Database::update(

            $itemTable,

            $itemData,

            [

                'product_id = ? AND ' => intval($productId),

                'product_type' => $productType

            ]

        );

    }

    /**

     * Remove all beneficiaries for a item

     * @param int $status The status to set (-1 to cancel, 0 to pending, 1 to completed)

     * @return array

     */

    public function setStatusPayouts($payoutId, $status)

    {

        $payoutsTable = Database::get_main_table(BuyCoursesPlugin::TABLE_PAYPAL_PAYOUTS);

        Database::update(

            $payoutsTable,

            ['status' => intval($status)],

            ['id = ?' => intval($payoutId)]

        );

    }

    /**

     * Gets the stored platform commission params

     * @param int $params platform commission

     * @return int The number of affected rows. Otherwise return false

     */

    public function updateCommission($params)

    {

        $commissionTable = Database::get_main_table(BuyCoursesPlugin::TABLE_COMMISSION);

        return Database::update(

            $commissionTable,

            ['commission' => intval($params['commission'])]

        );

    }

    /**

     * Register addicional service

     * @param string recurring profile Id

     * @return Mixed

     */

    public function updateRecurringProfileId($serviceSaleId, $recurringProfileId)

    {

        $servicesSaleTable = Database::get_main_table(BuyCoursesPlugin::TABLE_SERVICES_NODE);

        return Database::update(

            $servicesSaleTable,

            ['recurring_profile_id' => $recurringProfileId],

            ['id = ?' => intval($serviceSaleId)]

        );

    }

    /**

     * Check if a node got an activated service