Announcement

Collapse
No announcement yet.

Error actionCreate

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error actionCreate

    I can not run actionCreate function. I am writing custom controller for entity, but am getting error.I can not add records to the database. --> "bad server response"

    Code:
    <?php
    
    namespace Espo\Custom\Controllers;
    
    class BesProduct extends \Espo\Core\Templates\Controllers\Base
    {
        protected function getEntityManager()
        {
            return $this->getContainer()->get('entityManager');
        }
        
        public function actionCreate($params, $data, $request)
        {
            //return json_encode($data);
            
            $pdo = $this->getEntityManager()->getPDO();
            
            if($data->status == "3"){
                /* Get user */
                $userSql = "SELECT career_steps_id FROM user WHERE id='".$data->assignedUserId."'";
                $userResult = $pdo->prepare($userSql);
                $userResult->execute();
                $userRow = $userResult->fetch(\PDO::FETCH_ASSOC);
                
                /* Get career step */
                $stepCommissionSql = "SELECT * FROM career_commissions WHERE career_steps_id='".$userRow['career_steps_id']."'";
                $stepCommissionResult = $pdo->prepare($stepCommissionSql);
                $stepCommissionResult->execute();
                $stepCommissionRow = $stepCommissionResult->fetchAll(\PDO::FETCH_ASSOC);
                
                $x = 1;
                while($x <= $stepCommissionRow['payment_period']){
                    $commissionValue = $data->amount * $stepCommissionRow['commission_value'] / 100;
                    $totalPay = $commissionValue / $stepCommissionRow['payment_period'];
                    
                    /* Update career history table */
                    $id = uniqid();
                    $commissionSql = "INSERT INTO career_history (id,name,deleted,description,created_at,modified_at,created_by_id,modified_by_id,assigned_user_id,payable,month) 
                                                       VALUES ('".$id."','','0','','".$date."','".$date."','1','1','".$data->assignedUserId."','".$totalPay."','".$x."')";
                    $sthCommission = $pdo->prepare($commissionSql);
                    $sthCommission->execute();
                    $x++;
                }
            }
        }
    }

  • #2
    Ok, I'm solved. Thanx.

    Comment

    Working...
    X