Code Duplication - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 42-42 lines in 3 locations

main/inc/lib/api.lib.php 3 locations


    $set_type = '';

    switch ($lastEditTypeNoFilter) {
        case 'delete':
            // delete = make item only visible for the platform admin.
            $visibility = '2';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it.
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET lastedit_type       = '".str_replace('_', '', ucwords($tool))."Deleted',
                                lastedit_date       = '$time',
                                lastedit_user_id    = $user_id,
                                visibility          = $visibility,
                                session_id          = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool',$item_id, '$time', $user_id, '$time', '$last_edit_type',$user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type='".str_replace('_', '', ucwords($tool))."Deleted',
                            lastedit_date='$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        case 'visible' : // Change item to visible.
            $visibility = '1';
            if (!empty($session_id)) {

                $result = Database::query($sql);
            }
            break;
        case 'visible' : // Change item to visible.
            $visibility = '1';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it.
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET
                                lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
                                lastedit_date='$time',
                                lastedit_user_id = $user_id,
                                visibility = $visibility,
                                session_id = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
                            lastedit_date='$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        case 'invisible' : // Change item to invisible.
            $visibility = '0';
            if (!empty($session_id)) {

                $result = Database::query($sql);
            }
            break;
        case 'invisible' : // Change item to invisible.
            $visibility = '0';
            if (!empty($session_id)) {
                // Check whether session id already exist into item_properties for updating visibility or add it
                $sql = "SELECT session_id FROM $tableItemProperty
                        WHERE
                            c_id = $course_id AND
                            tool = '$tool' AND
                            ref = $item_id AND
                            session_id = $session_id";
                $rs = Database::query($sql);
                if (Database::num_rows($rs) > 0) {
                    $sql = "UPDATE $tableItemProperty
                            SET
                                lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
                                lastedit_date = '$time',
                                lastedit_user_id = $user_id,
                                visibility = $visibility,
                                session_id = $session_id $set_type
                            WHERE $filter";
                    $result = Database::query($sql);
                } else {
                    $sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id,$to_field, visibility, start_visible, end_visible, session_id)
                            VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
                    $result = Database::query($sql);
                    $id = Database::insert_id();
                    if ($id) {
                        $sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
                        Database::query($sql);
                    }
                }
            } else {
                $sql = "UPDATE $tableItemProperty
                        SET
                            lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
                            lastedit_date = '$time',
                            lastedit_user_id = $user_id,
                            visibility = $visibility $set_type
                        WHERE $filter";
                $result = Database::query($sql);
            }
            break;
        default: // The item will be added or updated.
            $set_type = ", lastedit_type = '$last_edit_type' ";
            $visibility = '1';

		@@ 3628-3669 (lines=42) @@
3625		$set_type = '';
3626
3627		switch ($lastEditTypeNoFilter) {
3628		case 'delete':
3629		// delete = make item only visible for the platform admin.
3630		$visibility = '2';
3631		if (!empty($session_id)) {
3632		// Check whether session id already exist into item_properties for updating visibility or add it.
3633		$sql = "SELECT session_id FROM $tableItemProperty
3634		WHERE
3635		c_id = $course_id AND
3636		tool = '$tool' AND
3637		ref = $item_id AND
3638		session_id = $session_id";
3639		$rs = Database::query($sql);
3640		if (Database::num_rows($rs) > 0) {
3641		$sql = "UPDATE $tableItemProperty
3642		SET lastedit_type = '".str_replace('_', '', ucwords($tool))."Deleted',
3643		lastedit_date = '$time',
3644		lastedit_user_id = $user_id,
3645		visibility = $visibility,
3646		session_id = $session_id $set_type
3647		WHERE $filter";
3648		$result = Database::query($sql);
3649		} else {
3650		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
3651		VALUES ($course_id, '$tool',$item_id, '$time', $user_id, '$time', '$last_edit_type',$user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3652		$result = Database::query($sql);
3653		$id = Database::insert_id();
3654		if ($id) {
3655		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3656		Database::query($sql);
3657		}
3658		}
3659		} else {
3660		$sql = "UPDATE $tableItemProperty
3661		SET
3662		lastedit_type='".str_replace('_', '', ucwords($tool))."Deleted',
3663		lastedit_date='$time',
3664		lastedit_user_id = $user_id,
3665		visibility = $visibility $set_type
3666		WHERE $filter";
3667		$result = Database::query($sql);
3668		}
3669		break;
3670		case 'visible' : // Change item to visible.
3671		$visibility = '1';
3672		if (!empty($session_id)) {
		@@ 3670-3711 (lines=42) @@
3667		$result = Database::query($sql);
3668		}
3669		break;
3670		case 'visible' : // Change item to visible.
3671		$visibility = '1';
3672		if (!empty($session_id)) {
3673		// Check whether session id already exist into item_properties for updating visibility or add it.
3674		$sql = "SELECT session_id FROM $tableItemProperty
3675		WHERE
3676		c_id = $course_id AND
3677		tool = '$tool' AND
3678		ref = $item_id AND
3679		session_id = $session_id";
3680		$rs = Database::query($sql);
3681		if (Database::num_rows($rs) > 0) {
3682		$sql = "UPDATE $tableItemProperty
3683		SET
3684		lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
3685		lastedit_date='$time',
3686		lastedit_user_id = $user_id,
3687		visibility = $visibility,
3688		session_id = $session_id $set_type
3689		WHERE $filter";
3690		$result = Database::query($sql);
3691		} else {
3692		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id, $to_field, visibility, start_visible, end_visible, session_id)
3693		VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3694		$result = Database::query($sql);
3695		$id = Database::insert_id();
3696		if ($id) {
3697		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3698		Database::query($sql);
3699		}
3700		}
3701		} else {
3702		$sql = "UPDATE $tableItemProperty
3703		SET
3704		lastedit_type='".str_replace('_', '', ucwords($tool))."Visible',
3705		lastedit_date='$time',
3706		lastedit_user_id = $user_id,
3707		visibility = $visibility $set_type
3708		WHERE $filter";
3709		$result = Database::query($sql);
3710		}
3711		break;
3712		case 'invisible' : // Change item to invisible.
3713		$visibility = '0';
3714		if (!empty($session_id)) {
		@@ 3712-3753 (lines=42) @@
3709		$result = Database::query($sql);
3710		}
3711		break;
3712		case 'invisible' : // Change item to invisible.
3713		$visibility = '0';
3714		if (!empty($session_id)) {
3715		// Check whether session id already exist into item_properties for updating visibility or add it
3716		$sql = "SELECT session_id FROM $tableItemProperty
3717		WHERE
3718		c_id = $course_id AND
3719		tool = '$tool' AND
3720		ref = $item_id AND
3721		session_id = $session_id";
3722		$rs = Database::query($sql);
3723		if (Database::num_rows($rs) > 0) {
3724		$sql = "UPDATE $tableItemProperty
3725		SET
3726		lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
3727		lastedit_date = '$time',
3728		lastedit_user_id = $user_id,
3729		visibility = $visibility,
3730		session_id = $session_id $set_type
3731		WHERE $filter";
3732		$result = Database::query($sql);
3733		} else {
3734		$sql = "INSERT INTO $tableItemProperty (c_id, tool, ref, insert_date, insert_user_id, lastedit_date, lastedit_type, lastedit_user_id,$to_field, visibility, start_visible, end_visible, session_id)
3735		VALUES ($course_id, '$tool', $item_id, '$time', $user_id, '$time', '$last_edit_type', $user_id, $toValueCondition, $visibility, $startVisible, $endVisible, $session_id)";
3736		$result = Database::query($sql);
3737		$id = Database::insert_id();
3738		if ($id) {
3739		$sql = "UPDATE $tableItemProperty SET id = iid WHERE iid = $id";
3740		Database::query($sql);
3741		}
3742		}
3743		} else {
3744		$sql = "UPDATE $tableItemProperty
3745		SET
3746		lastedit_type = '".str_replace('_', '', ucwords($tool))."Invisible',
3747		lastedit_date = '$time',
3748		lastedit_user_id = $user_id,
3749		visibility = $visibility $set_type
3750		WHERE $filter";
3751		$result = Database::query($sql);
3752		}
3753		break;
3754		default: // The item will be added or updated.
3755		$set_type = ", lastedit_type = '$last_edit_type' ";
3756		$visibility = '1';

chamilo / chamilo-lms

Code Duplication Length = 42-42 lines in 3 locations

main/inc/lib/api.lib.php 3 locations